pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (17+ messages)  latest in thread

Message-ID: <3C87A193.1FA76194@wcom.com>
Permalink:  ../3C87A193.1FA76194@wcom.com/
Also on:    postgresql.org/message-id/3C87A193.1FA76194@wcom.com

 · 

reply

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