Re: Trouble Upgrading Postgres

2018-11-04 Thread Adrian Klaver
On 11/4/18 2:55 PM, Charles Martin wrote: Yep, you called it: Nov  2 20:30:45 localhost kernel: Out of memory: Kill process 30438 (postmaster) score 709 or sacrifice child Nov  2 20:30:45 localhost kernel: Killed process 30438, UID 26, (postmaster) total-vm:3068900kB, anon-rss:1695392kB, file-

Re: Trouble Upgrading Postgres

2018-11-04 Thread Tom Lane
Charles Martin writes: > Yep, you called it: > Nov 2 20:30:45 localhost kernel: Out of memory: Kill process 30438 > (postmaster) score 709 or sacrifice child > Nov 2 20:30:45 localhost kernel: Killed process 30438, UID 26, > (postmaster) total-vm:3068900kB, anon-rss:1695392kB, file-rss:1074692kB

Re: Trouble Upgrading Postgres

2018-11-04 Thread Ron
Not enough swap space? On 11/04/2018 04:55 PM, Charles Martin wrote: Yep, you called it: Nov  2 20:30:45 localhost kernel: Out of memory: Kill process 30438 (postmaster) score 709 or sacrifice child Nov  2 20:30:45 localhost kernel: Killed process 30438, UID 26, (postmaster) total-vm:3068900k

Re: Trouble Upgrading Postgres

2018-11-04 Thread Charles Martin
Yep, you called it: Nov 2 20:30:45 localhost kernel: Out of memory: Kill process 30438 (postmaster) score 709 or sacrifice child Nov 2 20:30:45 localhost kernel: Killed process 30438, UID 26, (postmaster) total-vm:3068900kB, anon-rss:1695392kB, file-rss:1074692kB So it's running out of memory w

Re: Trouble Upgrading Postgres

2018-11-04 Thread Adrian Klaver
On 11/4/18 8:38 AM, Charles Martin wrote: Adtrian said: pg_dump: Error message from server: server closed the connection unexpectedly >Is this error the client reporting? >Is this the same that is showing up in the server log? Yes, that's the client message, i.e. what appeared in the termi

Re: Trouble Upgrading Postgres

2018-11-04 Thread Andreas Kretschmer
Am 04.11.2018 um 17:38 schrieb Charles Martin: Andreas said: >which exact minor version please? PostgreSQL 9.6.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-23), 64-bit okay, i asked to just rule out a stale version. 9.6.7, for instance, contains som

Re: Trouble Upgrading Postgres

2018-11-04 Thread Charles Martin
Adtrian said: >> pg_dump: Error message from server: server closed the connection >> unexpectedly >Is this error the client reporting? >Is this the same that is showing up in the server log? Yes, that's the client message, i.e. what appeared in the terminal window that gave the command. The serve

Re: Trouble Upgrading Postgres

2018-11-04 Thread Andreas Kretschmer
Am 03.11.2018 um 23:47 schrieb Charles Martin: When I do a pg_dump using PG 9.6, I got this: pg_dump: Dumping the contents of table "docfile" failed: PQgetCopyData() failed. pg_dump: Error message from server: server closed the connection unexpectedly This probably means the server term

Re: Trouble Upgrading Postgres

2018-11-04 Thread Laurenz Albe
Charles Martin wrote: > When I do a pg_dump using PG 9.6, I got this: > > > pg_dump: Dumping the contents of table "docfile" failed: PQgetCopyData() > > failed. > > pg_dump: Error message from server: server closed the connection > > unexpectedly > > This probably means the server terminated

Re: Logical replication hangs up.

2018-11-04 Thread Aleš Zelený
Hello, wal_sender_timeout did not help (from default 60s to 600s), but I haven't tested receiver timeout since it was sender complaining and receiver loops over ( recvfrom with "Resource temporarily unavailable" result, so i thought it is waiting for master sender to provide some data), thanks fo

Unsuscribe

2018-11-04 Thread Christophe TAVERNE
Hi, I would like to unsuscribe but I can't recover my account. How can I process ? Please, admin, could you remove my email from List? Thanks regards, Chris signature.asc Description: OpenPGP digital signature