Generate script creation postgres_fdw

Question

We use postgres_fdw and we have many servers created and many schema imported. Each time we need to refresh the data of an environment by another environment we need to manually update all the servers to link to the right server.

Is there a way we can generate the script of the foreign server creation and import schema for all the databases in a server?

Thank you

What specifically needs to be refreshed? Do your hosts keep changing their names? — jjanes, Jun 23 '21 at 18:02
@jjanes the host name changes since we replace the database by the backup of the database of another environment — Yousra, Jun 24 '21 at 08:11

score 2 · Accepted Answer · answered Jun 24 '21 at 14:14

2

You don't need to recreate the server and reimport the schema. You can just change the hostname on the existing server.

ALTER SERVER foo OPTIONS (SET host 'newhost');

But why not just use dns to repoint the server name to the new machine?

answered Jun 24 '21 at 14:14

jjanes

37,812
5
27
34

Generate script creation postgres_fdw

1 Answers1