Tom Lane wrote:
I just recreated the problem with a slightly different command. The problem was caused by using a list file to skip loading some function definitions that were causing problems. The command that loaded everything into template1 was:I tried to replicate this, and could not: the restore went into the expected database. (But I did notice that pg_restore needed to be explicitly told -Ft, which seems less than bright of it.) Are you sure those are the exact commands you issued? Were you using the 7.3 versions of pg_dump and pg_restore?
pg_restore -C -d template1 -L mpmx.lst -Ft mpmx.tar
The list file was created without doing a
It looks like the CREATE DATABASE call isn't done unless the -C flag is included both when the list file is created and when doing the restore.
This works correctly:
pg_restore -C -l -Ft mpmx.tar > mpmx.lst
pg_restore -C -d mpmx -L mpmx.lst -Ft mpmx.tar
It would be good if pg_restore warned if the -C flag was included on the list file generation or the
- Ian
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
