Open HogeBlekker opened 7 years ago
I'm getting a similar problem though different error. I was able to successfully install and create the extension. I then created the Wikipedia example. When I run this:
select * from www_fdw_wiki where search='postgres' limit 1;
I get this in my DB client (Squirrel):
An I/O error occured while sending ot the backend. SQLState: 08006 ErrorCode: 0
Then I run:
tail postgresql-9.5-main.log
and it appears the server died:
2017-02-27 11:57:32 EST [17366-3] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2017-02-27 11:57:32 EST [17366-4] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-02-27 11:57:32 EST [1345-15] LOG: all server processes terminated; reinitializing
2017-02-27 11:57:32 EST [17393-1] LOG: database system was interrupted; last known up at 2017-02-27 11:52:53 EST
2017-02-27 11:57:32 EST [17393-2] LOG: database system was not properly shut down; automatic recovery in progress
2017-02-27 11:57:33 EST [17393-3] LOG: invalid record length at 0/791DC50
2017-02-27 11:57:33 EST [17393-4] LOG: redo is not required
2017-02-27 11:57:33 EST [17393-5] LOG: MultiXact member wraparound protections are now enabled
2017-02-27 11:57:33 EST [1345-16] LOG: database system is ready to accept connections
System: Debian Jessie 8.5.1 PostgreSQL 9.2 (as per https://www.postgresql.org/download/linux/debian/)
Then, what should be a really simple example:
Logfile:
Seems to be linked with #28?