hi, Before taking backup with pg_dump, give createdb and createuser privileges to all the users of the first database.Then restore it in the second database with pg_restore.I don't know why they made the privileges required for taking backup. --with regrard chava --
Srinivasa R Chava (Chava) <[EMAIL PROTECTED]> - Boss: Sean T Laduderdale <[EMAIL PROTECTED]> vnet4603575 Application Developer Corporate Intra/Internet Systems WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM 500 Clinton Center Drive (Corporate Headquarters) Clinton, Mississippi (MS) USA 39056 (601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257 ---------------------------(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
