Questions tagged [postgresql-fdw]
Foreign Data Wrappers (FDW) enable access to remote data stores from PostgreSQL.
50 questions
0
votes
0
answers
21
views
Exporting a whole iSeries database to reinject it in PostgreSQL
I am trying to recover a client's data hosted on an iSeries server. It is very probably a DB2. There are 2000+ tables to transfer.
I have access with jdbc and tried with DBeaver (which gives the best ...
- 197
2
votes
1
answer
69
views
postgres_fdw passes/does not pass the LIMIT clause to the remote destination
I'm making a FDW (Foreign Data Wrapper) in PostgreSQL for myself using C.
And in the test environment below,
myFDW receives the query with/without LIMIT clause case by case.
Test environment:
psql → ...
- 21
1
vote
1
answer
744
views
Set a column value using the (remote) default when inserting a row into a foreign table
I have a database with a table whose primary key is a serial column, or a column with a locally-computed default value that prevents conflicts, for instance:
CREATE TABLE foo (
foo_id serial ...
- 223
1
vote
1
answer
2k
views
permission denied for view my_view in postgres_fdw
I have 2 databases db1 & db2,
I created postgres_fdw into db1 & db 2 with:
CREATE EXTENSION postgres_fdw;
I configured server and user mapping into db2 :
CREATE SERVER remote_server FOREIGN ...
1
vote
1
answer
851
views
Create user mapping without password how to configure authentication
I am trying to create a user mapping in PostgreSQL without a password, but I am encountering an error that says.
local_db=> select * from employee;
ERROR: could not connect to server "...
- 11
0
votes
1
answer
171
views
postgres_fdw: from where, is the resource utilized? remote or local?
I have an OLTP database and ETL jobs are running in the same database in the background.
I was thinking of separating the OLTP and ETL instances so that resource utilization would be distributed. ...
- 312
0
votes
1
answer
93
views
Can Postgresql FDW avoid n+1 when planning joins?
Does the PostgreSQL executor / planner have the ability to avoid n+1 querying of FDW tables? If so, what conditions have to be in place for this to happen, e.g. does the FDW need to emit a specific ...
- 719
4
votes
1
answer
5k
views
Error: SSL connection closed unexpectedly. Error while fetching large data using postgres FDW
I am using postgres 13 and created a foreign server with use_remote_estimate: on and fetch_size: 10000. tableA here is a partition table by created_date. The query is running fine if the number of ...
- 41
0
votes
1
answer
145
views
WALs increase for some reason
This is new to me. I have been searching the net but no result.
I have a server, Server A, that has been running for a few weeks, it is a new server. I set up FDW for this server to access all tables ...
- 327
0
votes
2
answers
747
views
Grouping user into Role to access FDW table
Recently I setup Forward Data Wrapper. Here is what I do:
CREATE SERVER foreign_server FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host '192.168.125.1', port '5432', dbname 'template1 ');
IMPORT ...
- 327
0
votes
2
answers
3k
views
How can I get list of foreign server's tables in postgresql?
I create a foreign server in postgresql. Before adding foreign table, I want to get list of tables in this foreign server.
Is there any way I can do this?
This sql query show the created foreign ...
- 123
0
votes
1
answer
917
views
Postgres FDW: Is it possible to execute a foreign function in a foreign server after importing the foreign schema?
I imported a foreign schema using IMPORT FOREIGN SCHEMA.
Now I'm able to access all the table content in that schema, but still unable to access any of the functions.
Is it possible to execute a ...
0
votes
1
answer
3k
views
PostgreSQL Foreign Data Wrappers - Simultaneous queries won't finish
We're using foreign data wrappers in a database which points to another server (which is a read-only replica). We run scheduled jobs using python ( more on this here: https://github.com/sqlalchemy/...
- 13
0
votes
1
answer
3k
views
How to give Read_write users access to foreign tables imported through foreign data wrapper?
I had a question regarding the extension postgres_fdw. I am trying to use postgres_fdw to import foreign tables from DB A to DB B. These databases are on the same host.
In Database B, I have a set of ...
- 11
0
votes
1
answer
1k
views
POSTGRESQL table replication between 2 servers
I want to to replicate A TABLE from one server A to another B so that A and B always in-sync.
This table on server A has like 4 - 5 million rows, whereas the table B is empty.
What I want to do is ...
- 327