DBA Hub

📋Steps in this guide1/1

Create database link between postgres dbs

1. Create extension:

postgresql configurationintermediate
by PostgreSQL
19 views
1

Create database link between postgres dbs

1. Create extension: 2. Create foreign server:( use the target postgres details. 3. Create user mapping details. 4. Test the database link: 5. Fetch data using db_link:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
postgres# create extension dblink;
postgres=# CREATE SERVER oracle_dblink FOREIGN DATA WRAPPER dblink_fdw OPTIONS ( host '10.21.120.131' ,dbname 'postgres' , port '5444');
postgres=# CREATE USER MAPPING FOR enterprisedb SERVER oracle_dblink OPTIONS ( user 'dba_raj' ,password 'dba_raj');
postgres=# SELECT dblink_connect('my_new_conn', 'oracle_dblink');
dblink_connect
----------------
OK
(1 row)
postgres=# select * from dblink('oracle_dblink','select object_name from test') as test_object(object_name varchar );
object_name
---------------------------------------------------
PG_AGGREGATE_FNOID_INDEX
PG_AM_NAME_INDEX
PG_AM_OID_INDEX
PG_AMOP_FAM_STRAT_INDEX

Comments (0)

Please to add comments

No comments yet. Be the first to comment!