Hi, 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? Chris ---------------------------(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