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
1 answer

How would I formulate an insert query into another database using postgres_fdw?

Here is the query that I want to run - Let's the current database that I am running this query in is db1 and the database in which I want to insert records is db2. insert into db2.employee(id, name, group) values(id, ,…
Tisha
  • 827
  • 3
  • 11
  • 34
1
vote
2 answers

SQLAlchemy not finding Postgres table connected with postgres_fdw

Please excuse any terminology typos, don't have a lot of experience with databases other than SQLite. I'm trying to replicate what I would do in SQLite where I could ATTACH a database to a second database and query across all the tables. I wasn't…
RunDeep
  • 186
  • 1
  • 10
1
vote
1 answer

Postgresql problems with postgres_fdw module

I'm trying, using the PostgreSQL Maestro tool, to reference a foreign key coming from a "local" DB to an other primary key inside an other DB (actually, they're both on the same remote machine). I've heard about the postgres_fdw module to create a…
JinLemon
  • 25
  • 3
1
vote
1 answer

Postgres JDBC FDW Ubuntu 14 install error: Makefile:53: ../../src/Makefile.global: Datei oder Verzeichnis nicht gefunden

I tried both JDBC FDWs (jdbc (atris) and jdbc2 (heimir sverrisson)) mentioned on the FDW wiki page and following the source install instructions, but always get this error: root@...:/usr/share/postgresql/9.3/contrib/jdbc2_fdw-master# make…
Andreas Covidiot
  • 4,286
  • 5
  • 51
  • 96
1
vote
1 answer

Faster way to dump data from redis hash to postgresql table

Am doing bulk data processing and for speed's sake am first storing the data in redis before dumping it into a postgresql database in 2 minute intervals. I've used a redis hash to store the data and even the hash keys in redis correspond to the…
lukik
  • 3,919
  • 6
  • 46
  • 89
1
vote
1 answer

Can't access data from pg_index using Foreign Data Wrapper in postgreSQL 9.3

I implement Foreign data wrapper in postgreSQL 9.3 in another postgreSQL DATABASE as below: CREATE SERVER app_db FOREIGN DATA WRAPPER postgres_fdw OPTIONS (dbname 'postgres', host 'localhost'); CREATE USER…
Ilesh Patel
  • 2,053
  • 16
  • 27
1
vote
2 answers

postgres_fdw error could not connect server

I wrote this PostgreSQL code lines, but I'm having the following error: ERROR: could not connect to server "server\sqlexpress" SQL state: 08001 What am I doing wrong? My code: USING PostgreSQL 9.3 on Windows 8.1 and MS SQL Express 2012 on same…
Capanga
  • 77
  • 1
  • 8
0
votes
0 answers

How to grant read access to Foreign Data Wrapper (FDW) in Postgres

We have a database that contains two schemas, "FDW" and "main_schema". The IT department and I are trying to grant read access for me to the "FDW", I already have read access to "main_schema". Neither myself nor the IT department built the database…
Eizy
  • 253
  • 1
  • 9
0
votes
0 answers

Workaround for building oracle_fdw on m1 mac

I'm trying to compile oracle_fdw on an m1 mac, of course its not supported yet due to the unavailability of an arm version of oracle instant client. Are there any workarounds for that?
YosefAhab
  • 64
  • 10
0
votes
0 answers

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 doesn't preserve constraints, indexes and rights.…
yam0925
  • 9
  • 1
0
votes
0 answers

Is there a faster alternative to using dblink or fdw extension to create materialized views in Postgres?

I used the dblink (into postgresql) to create materialized views from another base. However, this way is not optimal I use it like this: CREATE MATERIALIZED VIEW schema.vm_nom AS SELECT t1.colonne1, t1.colonne2 , t3.geom FROM…
yam0925
  • 9
  • 1
0
votes
0 answers

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 the table in postgres?
Sujeet Chaurasia
  • 97
  • 8
0
votes
1 answer

Postgres-FDW with Microsoft Access Error 3073: Operation must use an updatable query

I'm using Microsoft Access to connect to a postgres-database. On that postgres database I have a foreign-table via postgres_fdw. I can select on that table with MS Access, however running updates will throw the error: Error 3073: Operation must use…
octavio
  • 456
  • 4
  • 14
0
votes
2 answers

Postgresql: how to ignore unavailable foreign tables when selecting data from them

I have a view as a union of several external tables (postgres_fdw). When selected in this view, some of the external servers may be unavailable (there is no network connection), and the select raise an error. Is it possible to ignore such errors and…
Evgenii Sokolov
  • 1
0
votes
1 answer

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 it outside of the FdwRoutine functions, so I…
Vlad Keel
  • 372
  • 2
  • 13
1 2 3
…
9 10