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:
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 ms | psql -q
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
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
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 suppose I
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.0devel
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