Re: [HACKERS] testing cvs HEAD - HS/SR - PANIC: cannot make new WAL entries during recovery

2010-02-19 Thread Erik Rijkers
On Thu, February 18, 2010 23:32, Andres Freund wrote: > On Thursday 18 February 2010 22:25:35 Erik Rijkers wrote: >> localhost:55432 => 8.4.2 instance (ssh tunnel) >> /tmp:7575 => a 9.0devel standby >> >> time pg_dump -h localhost -p 55432 -t public.tab_jobs --clean --no-owner >> --no-privileges m

Re: [HACKERS] testing cvs HEAD - HS/SR - PANIC: cannot make new WAL entries during recovery

2010-02-19 Thread Simon Riggs
On Thu, 2010-02-18 at 23:13 +0100, Erik Rijkers wrote: > I ran this by accident Good test, thanks for running it. -- Simon Riggs www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] testing cvs HEAD - HS/SR - PANIC: cannot make new WAL entries during recovery

2010-02-18 Thread Heikki Linnakangas
Andres Freund wrote: > Trivial patch attached. Thanks, committed. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] testing cvs HEAD - HS/SR - PANIC: cannot make new WAL entries during recovery

2010-02-18 Thread Andres Freund
On Thursday 18 February 2010 22:25:35 Erik Rijkers wrote: > When accidentally running pg_dump from an 8.4.2 instance into a 9.0devel > (cvs as of 2010.02.17) slave as below, this causes a PANIC. The slave can > be restarted. > > localhost:55432 => 8.4.2 instance (ssh tunnel) > /tmp:7575 => a 9.0d

Re: [HACKERS] testing cvs HEAD - HS/SR - PANIC: cannot make new WAL entries during recovery

2010-02-18 Thread Erik Rijkers
On Thu, February 18, 2010 23:08, Alvaro Herrera wrote: > Erik Rijkers wrote: > >> And to be clear: I realize that one cannot expect a pg_dump at a slave to >> work: > > Hmm, why not? Because the slave is readonly. My case was: pg_dump $pg8.4.2 | psql $slave I ran this by accident. I suppo

Re: [HACKERS] testing cvs HEAD - HS/SR - PANIC: cannot make new WAL entries during recovery

2010-02-18 Thread Alvaro Herrera
Erik Rijkers wrote: > And to be clear: I realize that one cannot expect a pg_dump at a slave to > work: Hmm, why not? -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hac

[HACKERS] testing cvs HEAD - HS/SR - PANIC: cannot make new WAL entries during recovery

2010-02-18 Thread Erik Rijkers
When accidentally running pg_dump from an 8.4.2 instance into a 9.0devel (cvs as of 2010.02.17) slave as below, this causes a PANIC. The slave can be restarted. localhost:55432 => 8.4.2 instance (ssh tunnel) /tmp:7575 => a 9.0devel standby time pg_dump -h localhost -p 55432 -t public.tab_jobs -