Postgres foreign-data wrapper is a module which can be used to access data stored in external PostgreSQL servers.
Questions tagged [postgres-fdw]
144 questions
0
votes
1 answer
What am I doing here while updating a table in a remote db using postgres_fdw?
Here is how I am doing it:
CREATE EXTENSION IF NOT EXISTS postgres_fdw;
DROP SERVER IF EXISTS myserver CASCADE;
CREATE SERVER myserver FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host '10.1.1.1', dbname 'mydb', port '5432');
DROP USER…
Tisha
- 827
- 3
- 11
- 34
0
votes
1 answer
How to check foreign table permissions on Postgres
does anybody know how to check user permissions for a foreign table on Postgres?
I've tried \dE and \det, but no luck.
I just want to know who can select, insert, update and delete from a foreign table.
Alexander Rumanovsk
- 2,043
- 4
- 21
- 33
0
votes
1 answer
Impala FDW for Postgres 9.5
I am looking for Impala Foreign Data Wrapper for Postgres 9.5. I have tried to figure out from the internet and can only have one reference to https://github.com/lapug/impala_fdw
But it seems the fdw is yet to be completed as per the readme…
Kallol
- 302
- 4
- 16
0
votes
0 answers
BigSQL PostgreSQL CREATE EXTENSION errors
I have windows 8.1 and I want to try hadoop_fdw. Problem is with loading the extension with:
CREATE EXTENSION hadoop_fdw;
ddssdg
ERROR: could not load library "D:/PROGRA~2/POSTGR~2/pg95/../pg95/lib/postgresql/hadoop_fdw.dll": unknown error…
dkocich
- 221
- 4
- 7
0
votes
1 answer
Postgres FDW Connection Linux
I am actively working with fdw under windows and Linux.
Under windows opened fdw connections on the other side are closed immediately if the main (and reading/writing) connection under windows is closed.
But under Linux opened fdw connections on…
raphaelgeng
- 1
- 3
0
votes
1 answer
How to get SQL generated by IMPORT FOREIGN SCHEMA?
When I do import foreign schema constructor from server mysql_svr into mysql_fdw; I get:
ERROR: type "set" does not exist
LINE 6: type set NOT NULL,
^
QUERY: CREATE FOREIGN TABLE search_requests (
id int NOT NULL,
ctime…
Eugen Konkov
- 22,193
- 17
- 108
- 158
0
votes
0 answers
ODBC Driver and Postgres Foreign Data Wrapper
I am trying to understand PostgreSQL's FDW and an ODBC driver.
From my understanding, the FDW just makes other data sources look like Postgres tables, essentially a bridge between PostgreSQL and the external data source.
So, you would write your…
Yolo49
- 489
- 2
- 7
- 14
0
votes
1 answer
Docker and Analytics Install
I have a docker file called quasar.dockerfile. I built the docker file and everything loaded successfully.
#quasar.dockerfile
FROM java:8
WORKDIR /app
ADD docker/quasar-config.json quasar-config.json
RUN apt-get update && \
apt-get install…
Yolo49
- 489
- 2
- 7
- 14
0
votes
0 answers
Informix Database Crash with Postgres FDW and Grails Searchable Plug-in
I have quite a complex setup:
an Informix (11.5) legacy database which contains some of the business data,
a Postgres (9.3) database which connects via foreign data wrapper (FDW) to the Informix instance, and
a Grails application (2.4.4) which…
Klaus
- 1