Accessing objects in other PostgreSQL databases
Sometimes we want to access data in other PostgreSQL databases. Reasons might be as follows:
- You have more than one database server, and you need to extract data from one and load it into the other, such as reference data.
- You want to access data that is in a different database on the same database server which had been split up for administrative purposes.
- You want to perform some changes that you do not wish to rollback in the event of an error or transaction abort—known as function side-effects or autonomous transactions.
You might also be considering this because you are exploring scale out, sharding or load-balancing approaches. If so, please read the last part of this recipe See Also, and then ...