Re: pg_restore new option -m

Andrew Dunstan <andrew@dunslane.net>

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>
Date: 2009-02-20T02:58:18Z
Lists: pgsql-hackers

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.

cheers

andrew