163 questions
1
vote
1
answer
46
views
django admin migration with postgres_fdw
I use postgres_fdw to create relations between my databases
Here I have a foreign model with the name:
class User(AbstractUser):
...
class Meta:
db_table = '"foreign_user".&...
- 105
0
votes
0
answers
50
views
Not able to read FDW table in Azure database for postgresql
I have two Postgresql database Server running on Azure, both of version 16.8.
I created the foreign data wrapper and created foreign table as well, everything created well.
but when I am trying to ...
- 152
1
vote
0
answers
39
views
Issues with UPDATE and DELETE Queries Using redis_fdw in PostgreSQL
I am using redis_fdw in a PL/pgSQL function to interact with a Redis server, and I’ve encountered issues with certain queries. Here is the summary:
CREATE FOREIGN TABLE redis_db7 (key text, val text)
...
0
votes
0
answers
65
views
Postgres data sync between different servers
I have 2 postgres clusters (A and B) on different servers. Whenever data is written to the table on server A, I want to copy the data to the table on server B.
But the data retention in the table on ...
- 13
5
votes
1
answer
133
views
Where did the where clause go? Updating a date column in Oracle via oracle_fdw foreign table and postgres_fdw
We have a (perhaps) slightly unusual setup for the connection between our Oracle database(s) and our Postgres database(s), which relies on the oracle_fdw extension (which I have great appreciation for)...
- 51
0
votes
1
answer
741
views
FOREIGN DATA WRAPPER file_fdw not exist, how to install it?
FDW (Foreign Data Wrappers) are very useful, and I need them to read CSV files. (Please do not reply to say "use COPY"). Generally using it on other machines is "plug and play"... ...
- 44
2
votes
1
answer
63
views
Age function computes differently when used through a view in PostgreSQL FDW
I have a view which has a column for age (like Age (CURRENT_TIMESTAMP, birth_dtm)). This works fine, but when used through a FDW offsets the age by current timezone's offset from GMT. PostgreSQL ...
0
votes
2
answers
645
views
Is it possible to have foreign schema in ClickHouse, to query other database inside your own?
In PostgreSQL there is postgres_fdw extension, which allows to add a foreign schema to your own database, like a view which makes it possible to get data from another Postgres making queries to it ...
0
votes
0
answers
101
views
Handling Foreign Data Wrapper (FDW) Inaccessibility in PostgreSQL Join
I have a PostgreSQL database "local_db" with a foreign data wrapper (FDW) connection to an external database "foreign_db". In the external database, there is a table called Pricing(...
0
votes
0
answers
30
views
How to use ALTER USER MAPPING command with arguments through db.Exec() [duplicate]
Below is the code snippet
if _, err := db.Exec(cmd, args...); err != nil {
return fmt.Errorf("failed to execute command: command %s %v", v.Command, err)
}
where cmd being passed is
...
- 87
1
vote
1
answer
223
views
Upgrading `go version` for `CGO` a Postgres FDW project
I am trying to build the steampipe-postgres-fdw project in a Mac M1 with the latest go version (1.21).
It currently uses go version 1.19.
The FDW is designed to work with Postgresql 14.
The project ...
- 636
0
votes
0
answers
41
views
Inheriting column comments with an FDW
I have 2 postgresql database instances and I use fdw to import schemas from one instance to another. However I've seen that my local column comments don't import with schemas. I know that inheritance ...
- 9
1
vote
0
answers
725
views
Is there a way to replicate/sync the postgresql views from a primary database to the table on secondary postgresql database?
I have a view on the primary database, now I want to have the data of this view to be on the secondary database but in a table. Is there a way or a third-party tool to keep the view data in sync with ...
- 163
3
votes
1
answer
878
views
Postgres query of a partitioned table pointing to foreign data workers many times slower than querying fdw directly
Thanks in advance to anyone who might be able to help with this.
I have a Postgres 15.2 database which uses a partition table to access foreign data worker tables by a Zone id. Each zone further ...
- 33
0
votes
1
answer
118
views
How to share memory between processes in Postgres FDW
I'm writing a postgres FDW extension for my custom data storage.
I have a class that provides the API for the storage. initialization of the class is rather costly, and I also need to have access to ...
- 410
0
votes
1
answer
746
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 "...
- 125
1
vote
0
answers
47
views
Limitations in FDW code on passing List* metadata between GetForeignPlan() and BeginForeignScan()
I'm writing an FDW for a non-SQL data source. Platform is Windows 10, C (MS Visual Studio), Postgresql 14. My FDW code is modeled after FDW example codes I have studied such as SQLite, JSON, CSV, File,...
- 446
0
votes
0
answers
197
views
How Can I Connect to a Remote SQL Server From a Local Postgres Database Using Postgres_fdw?
I've been working on a major project that compares data from multiple data sources. I've been using postgres_fdw for this and I've been successful in retrieving data to my local postgres instance from ...
- 668
1
vote
1
answer
2k
views
How to get postgres_fdw to push queries with small LIMITs to the foreign server?
I'm using postgres_fdw to connect to another PostgreSQL server. The foreign data wrapper is currently configured with a large fetch_size and extremely large fdw_startup_cost. This working well for ...
- 5,684
0
votes
1
answer
140
views
Postrgres FDW vs multiple clients
Say I have two db1 and db2, with schema
- db1.public.orders
- db1.public.accounts
- db2.public.orders
- db2.public.accounts
If I wish to have access to two databases, would it be recommended ...
- 11
1
vote
1
answer
1k
views
Postgres FDW could not serialize access due to concurrent update
This is similar to this question Postgres could not serialize access due to concurrent update, however because of characteristics of FDW the suggestions aren't applicable.
The error is "could not ...
- 472
0
votes
2
answers
949
views
Postgres FDW Remote only JOIN causes fetch all data
I'm trying to fetch data from a remote server with JOIN clause which involves only remote tables, but it is very slow because the planner decides to fetch all data from two tables and merge it locally....
- 3
0
votes
0
answers
54
views
How to associate source files with dynamic library
I need to debug Postgres foreign data wrapper mysql_fdw.so. In Clion i try to attach postgres process.
Debugger attached to process 8818
In source code of fdw i try to set break points, but it says ...
- 301
2
votes
1
answer
340
views
FDW with an IAM DB Auth user
I have a user with role rds_iam so IAM DB Auth is required for the user to connect to my Aurora PostgreSQL server (server A). Which works as expected. I have added a role to Server B that has ...
- 588
0
votes
1
answer
749
views
Replace Oracle db with Postgres db , add an adapter
I have a source code querying an Oracle database.
Is it possible to replace the Oracle database by a PostgreSQL database without modifying the source code ?
I thought about adding an adapter/wrapper ...
- 585