DBA Hub

📋Steps in this guide1/1

Create/Modify foreign server

1. Create foreign server:( use the target postgres details.

postgresql configurationintermediate
by PostgreSQL
17 views
1

Create/Modify foreign server

1. Create foreign server:( use the target postgres details. 2. Add new parameter to existing foreign server: 3. Modify parameters in foreign server: 4. Drop foreign server:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
postgres=#
CREATE SERVER oracle_dblink FOREIGN DATA WRAPPER dblink_fdw OPTIONS ( host '10.21.120.131' ,dbname 'postgres' , port '5444');
postgres=#
ALTER SERVER oracle_dblink options ( ADD port '5444');
postgres=#
ALTER SERVER oracle_dblink options ( SET port '5432');
postgres=#
DROP SERVER oracle_dblink CASCADE;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!