Last active
July 15, 2019 17:07
-
-
Save achampav/05c014ea5cdf66769993b24d0c7eb6ae to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Connexion à l'utilisateur postgres sur la base de données cadastredb du serveur postgresql1102 | |
-- Ajout de l'extension Foreign Data Wrapper spécifique à PostgreSQL | |
create extension postgres_fdw; | |
-- Création d'un serveur pointant sur l'autre instance du serveur postgresql1101 | |
create server postgresql1101 | |
foreign data wrapper postgres_fdw | |
options (host 'postgresql1101', port '5432', dbname 'cadastredb'); | |
-- Changement de propriétaire du serveur pour l'utilisateur cadastre | |
alter server postgresql01 owner to cadastre; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment