On Thu, 19 Feb 2009, Andrew Dunstan wrote:
Date: Thu, 19 Feb 2009 21:58:18 -0500
From: Andrew Dunstan <and...@dunslane.net>
To: Tom Lane <t...@sss.pgh.pa.us>
Cc: o...@pyrenet.fr, pgsql-hackers list <pgsql-hackers@postgresql.org>
Subject: Re: [HACKERS] pg_restore new option -m
Tom Lane wrote:
o...@pyrenet.fr writes:
pg_restore -C -m 4 -d template1 db.dmp
gives numerous errors, mostly no such relation at index creation time.
You sure you don't get exactly the same without -m?
Yeah, I have reproduced this. It's because we reconnect to the wrong db in
this case (i.e. to the -d database, not the created one) in the workers and
subsequent connects.
I've applied a trivial patch to fix it.
works like a charm!
cheers
andrew
thanks
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
15, Chemin des Monges +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: o...@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
