From: Srinivasa R Chava <s.chava@wcom.com>
To: Alex Hudich <altx@mail.ru>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_restore problem.
Date: Thu, 07 Mar 2002 11:21:23 -0600
Message-ID: <3C87A193.1FA76194@wcom.com> (raw)
References: <E16hlHD-000AMH-00@f6.mail.ru>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: s.chava@wcom.com, altx@mail.ru
Subject: Re: pg_restore problem.
In-Reply-To: <3C87A193.1FA76194@wcom.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox