Stack Overflow
Stack Overflow

Questions tagged [postgres-fdw]

Postgres foreign-data wrapper is a module which can be used to access data stored in external PostgreSQL servers.

144 questions
0
votes
1 answer

Mongodb FDW Extension for postgres

Can i get proper documentation for MongoDB foreign data wrapper extension installation For PostgreSQL ? Will it support AWS RDS and Aurora? I'm trying to create a MongoDB foreign data wrapper extension from PostgreSQL db to MongoDB. But i'm not…
Dhivya Elangovan
  • 3
  • 1
0
votes
1 answer

Postgres FDW join query on local and foreign table is slow with ORDER BY and JSONB data

I have two tables the local table debtors and the foreign table debtor_registry. I'm using PostgreSQL v13. My problem here is whenever I try the following query, It takes 14secs to get the 1000 records. SELECT debtors.id, debtors.name, …
Shift 'n Tab
  • 8,808
  • 12
  • 73
  • 117
0
votes
0 answers

Postgres FDW connectivity issue from Azure RDS to AWS RDS

I was using FDW extension in PostgreSQL from 2 years to load data from one database to another database. Now, one of my RDS has been moved from AWS to Azure. Now, when I tries to make connection from Azure to AWS it says the host is invalid. So, in…
UmaShankar
  • 221
  • 5
  • 14
0
votes
1 answer

Generate script creation postgres_fdw

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…
Yousra
  • 73
  • 1
  • 9
0
votes
1 answer

Create Postgres FDW using the postgres super user yet have read only access to the remote schema

I am trying to create an FDW using the postgres super user credentials using the following steps - My super user is postgres CREATE SERVER testfdw FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host '10.10.10.171', dbname 'testdb', port '5432',…
Priya Sooraj
  • 23
  • 4
0
votes
1 answer

How to monitor/list outgoing connections to foreign servers in postgres?

I currently use the native foreign data wrapper extension to connect to some other postgres instances (sharding architecture). Now I would like to understand how those underlying outgoing connections are managed by the fdw. I read in the…
biocarl
  • 111
  • 1
  • 5
0
votes
1 answer

Several Build errors while building jdbc2_fdw for postgres by heimir-sverrisson

I am installing jdbc2_fdw extension for PostgreSQL 9.6 ( Have tried with PostgreSQL 12, didn't work). I am using the command sudo PATH=/usr/lib/postgresql/9.6/bin/:$PATH make USE_PGXS=1install to compile and build. I am getting a bunch of errors and…
karthi keyan
  • 53
  • 2
  • 7
0
votes
1 answer

PostgreSQL FDW over pgBouncer drops connection to PostgreSQL

we have a PostgreSQL setup where we directed FDW (Forward Data Wrapper) connection to other databases over pgBouncer. Once we execute the query to FDW schema, connection from FDW to pgBouncer to another PostgreSQL server is opened correctly but once…
khorvat
  • 1,630
  • 2
  • 20
  • 31
0
votes
1 answer

Hourly Segregate pg_stat_statements On Reader Instance

Aurora Postgres 11.8 I have to segregate pg_stat_statements on an hourly basis on Reader instance. On Writer instance it's simple, create a table and backup pg_stat_statements on an hourly basis and then clean up pg_stat_statements using…
user3706888
  • 159
  • 2
  • 11
0
votes
1 answer

Postgres fdw server relation doesn't exist

I am trying to create a link between postgres databases on my local, using FDW. Here is my code to create this link: CREATE EXTENSION IF NOT EXISTS postgres_fdw; CREATE SERVER IF NOT EXISTS TEST_SERVER FOREIGN DATA WRAPPER postgres_fdw OPTIONS…
user2921015
  • 69
  • 1
  • 9
0
votes
1 answer

Low performance of postgres_fdw extension

I need to periodically copy data from the TMP database to the remote PROD database with some data modifications in columns. When I use the postgres_fdw extension from the PROD database (with mapping foreign schema), the process of copying a million…
Fral
  • 1
0
votes
1 answer

How to connect PostgreSQL database to Oracle

I have migrated an oracle database to AWS Aurora PostgreSQL. My application is connecting to another upstream application on Oracle database on AWS RDS. I'm generating inventory reports from the upstream application. earlier it was both Oracle…
aan anna philip
  • 61
  • 1
  • 9
0
votes
1 answer

How can I import a foreign schema with anyarray columns?

Is it possible to query the pg_catalog schema of a remote Postgres server? I'm trying to access some simple statistics of a remote server. I've tried importing the foreign schema, but it fails on an anyarray column. psql> IMPORT FOREIGN SCHEMA…
Ian Hunter
  • 9,466
  • 12
  • 61
  • 77
0
votes
0 answers

PostgreSQL - Why does planner underestimate number of rows when doing a Foreign Scan?

I am running a query with an INNER JOIN through a foreign data wrapper (postgres_fdw), and when I view the EXPLAIN ANALYZE, it shows one of the Foreign Scan subnodes underestimates that it will only scan 1 row when it actually scans 7 causing the…
geckels1
  • 347
  • 1
  • 3
  • 13
0
votes
1 answer

PostgreSQL Create Views and Import Foreign Schema in the same transaction

I have setup postgres_fdw between two databases (sourcedb, targetdb) so that I can create Foreign Data Tables in targetdb from a schema in sourcedb. All the above is configured and working as expected. The next step was to re-Import Foreign Schema…
Giannis Dim
  • 37
  • 1
  • 8
1 2 3
…
9 10