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