Re: pg_restore new option -m

On Thu, 19 Feb 2009, Andrew Dunstan wrote:

> Date: Thu, 19 Feb 2009 21:58:18 -0500
> From: Andrew Dunstan <andrew@dunslane.net>
> To: Tom Lane <tgl@sss.pgh.pa.us>
> Cc: ohp@pyrenet.fr, pgsql-hackers list <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] pg_restore new option -m
> 
>
>
> Tom Lane wrote:
>> ohp@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: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)