Re: pg_restore new option -m - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: pg_restore new option -m
Date
Msg-id 499E1C4A.8070601@dunslane.net
Whole thread Raw
In response to Re: pg_restore new option -m  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_restore new option -m  (ohp@pyrenet.fr)
List 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





pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: ORDER BY with EXCEPT?
Next
From: Robert Haas
Date:
Subject: Re: GIN fast insert