Hi,
On Thu, 2003-01-16 at 10:13, Christopher Kings-Lynne wrote: > In postgresql 7.3.1, if I do pg_dumpall -c, at the top of the dump file is > this: > > DROP DATABASE au_shipping > ;CREATE DATABASE au_shipping WITH OWNER = auadmin TEMPLATE = template0 > ENCODING = 'SQL_ASCII'; > DROP DATABASE au_test > ;CREATE DATABASE au_test WITH OWNER = chriskl TEMPLATE = template0 ENCODING > = 'SQL_ASCII'; > DROP DATABASE australia > ;CREATE DATABASE australia WITH OWNER = auadmin TEMPLATE = template0 > ENCODING = 'SQL_ASCII'; > DROP DATABASE geeklog > ;CREATE DATABASE geeklog WITH OWNER = chriskl TEMPLATE = template0 ENCODING > = 'SQL_ASCII'; > DROP DATABASE keystone > ;CREATE DATABASE keystone WITH OWNER = chriskl TEMPLATE = template0 ENCODING > = 'SQL_ASCII'; > > Why are all the CREATE DATABASE statements commented out? Surely that will > make the restore fail? Just guessing: The first line does not have a ; at the end; so the first semicolon (at the beginning of second line) will end the first line; will not comment the CREATE DATABASE line... I mean, it might work as below: DROP DATABASE au_shipping; CREATE DATABASE au_shipping WITH OWNER = auadmin TEMPLATE = template0 ENCODING = 'SQL_ASCII'; ? Best regards, -- Devrim GUNDUZ TR.NET Sistem Destek Uzmani Tel : (312) 295 93 18 Fax : (312) 295 94 94 Tel : (216) 542 90 00 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
