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) <s.chava@wcom.com>
- Boss: Sean T Laduderdale <sean.lauderdale@wcom.com>
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