The first requirement of data federation is the ability to connect to remote databases. With this capability, we can read or write to a remote PostgreSQL database table as if it were local. By doing so, certain query elements can be offloaded to the other server. We can also access metadata that is stored in a central location that acts as a shared resource for all database servers.
This recipe will describe how to create a foreign PostgreSQL server and will be the basis for several of the upcoming sections.
