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
1
vote
0 answers

ERROR could not load library "/usr/pgsql-11/lib/postgres_fdw.so"

I'm getting the following error when attempting to access a foreign table. ERROR: could not load library "/usr/pgsql-11/lib/postgres_fdw.so": /usr/pgsql-11/lib/postgres_fdw.so: undefined symbol: TimestampDifferenceMilliseconds This was not a…
zjmrl
  • 11
  • 2
1
vote
1 answer

What happens when a User Mapping's Password Changes?

I would like to use a service with our Database, but it doesn't support Amazon RDS IAM Database authentication. My plan is to have a mock-database that only has tables it needs from the original postgres DB, and to have a script that refreshes the…
Ecumene
  • 87
  • 6
1
vote
1 answer

Postgres fdw inserting record with foreign triggers

I have established a foreign data wrapper to a second Postgres database and imported the foreign schema. Now, when I attempt to insert a row to one of the foreign tables from my primary database it hits a function called on the insert trigger. …
L.Nelson
  • 21
  • 3
1
vote
1 answer

postgres_fdw reduce data download during analyse

During analyse of foreign table I see a lot of postgres_fdw fetches on foreign server. For big tables it fetches all of it, even though it gives me 300 records in sample: INFO: "test_table": table contains 59280698 rows, 300 rows in sample I…
JustMe
  • 2,329
  • 3
  • 23
  • 43
1
vote
1 answer

PostgresSQL Nested Loops - When does the planner decide to use Nested Loop when doing an INNER JOIN?

I am running a query with an INNER JOIN where the planner decides to use a Nested Loop. I've figured out that it has do with the WHERE conditions as I have tried writing the query with different WHERE conditions so it returns the same result but…
geckels1
  • 347
  • 1
  • 3
  • 13
1
vote
1 answer

Postgresql Foreign data wrapper error Non-superuser cannot connect if the server does not request a password

We are using postgres_fdw extension to access views of another database. I have tested accessing foreign tables on 2 different PostgreSQL servers, it's working on one server and another server is throwing below error SQL Error [2F003]: ERROR:…
YogeshR
  • 1,606
  • 2
  • 22
  • 43
1
vote
1 answer

PostgreSQL - How to import custom data type when creating foreign table (using postgres-fdw)?

I'm trying to create foreign table view using postgresql_fdw (https://www.postgresql.org/docs/current/postgres-fdw.html). When trying to IMPORT FOREIGN SCHEMA public FROM SERVER replica_db1 INTO db1, it reports type "public.custom_type" does not…
ZK Zhao
  • 19,885
  • 47
  • 132
  • 206
1
vote
1 answer

How to fetch records from another database using postgres_fdw in postgresql

My case I have connected to another GP DB to import data into my PostgreSQL tables and written Java schedulers to refresh it Daily. But when I'm trying to fetch the records everyday by using SQL functions, it's giving me an error Greenplum Database…
UmaShankar
  • 221
  • 5
  • 14
1
vote
0 answers

Maximum table/query size limits for Postgres Foreign Data Wrapper (FDW)?

Are there limits to the PostgreSQL Foreign Data Wrapper extension? i.e. is there some maximum size of source table (or schema/database) that can be set up as a Foreign Table via FDW? We are using Postgres 10.6 We've occasionally run into situations…
rocksteady
  • 1,697
  • 14
  • 18
1
vote
2 answers

Oracle FDW support in AWS

I have an OLTP DB in Oracle and a downstream OLAP System in PostgreSQL on-premises. The data from Oracle is pumped into PostgreSQL using Oracle_FDW. I am exploring the possibility of moving the PostgreSQL to AWS, but none of the RDS have Oracle_fdw…
Ashwin Sridhar
  • 125
  • 1
  • 14
1
vote
1 answer

postgres_fdw pushing down sum and count, but not min and max

As of PostgreSQL 10.x, foreign tables support aggregate pushdown. I noticed that sum and count operations are being pushed to the remote server but min and max are not pushed the same way. select min(col) from foreign_table shows a foreign scan…
wrschneider
  • 17,913
  • 16
  • 96
  • 176
1
vote
1 answer

can i simplify the use of postgres_fdw if the foreign db is in the same server

my server has several databases. I want to be able to read db1 from queries in db2. I know I can use postgres_fdw to do it but that has a couple of drawbacks. The main one is that I have to pass credentials around, worry over when I change passwords…
pm100
  • 48,078
  • 23
  • 82
  • 145
1
vote
0 answers

Postgres multicorn undefined symbol oid_hash

I've built the multicorn extensions from source (downloaded 1.3.4 from pgxn website) but am unable to create extension. When I run: CREATE EXTENSION multicorn; The response I am getting is: ERROR: could not load library…
nclu
  • 1,057
  • 1
  • 8
  • 19
1
vote
1 answer

TDS FDW Adaptive Server connection failing, But message is "Success"

I was able to build the TDS_FDW and bring the extension into Postgresql 10. However, I'm getting the unusual message that it fails with a message of "Success". ERROR: DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed…
nclu
  • 1,057
  • 1
  • 8
  • 19
1
vote
1 answer

PostgreSQL fdw and view, working with timestamp

I have a PostgreSQL 9.6 server connecting to remote 9.3 server. I'm trying to create the following materialized view : CREATE MATERIALIZED VIEW test AS SELECT id FROM remote.logs WHERE remote.logs.created_at > (now() - interval '1 day') It's…
Luma
  • 11
  • 2
1 2 3
…
9 10