Skip site navigation (1) Skip section navigation (2)

restore from a pg_dumpall file

From: "Bob Powell" <Bob(at)hotchkiss(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: restore from a pg_dumpall file
Date: 2004-05-25 14:20:49
Message-ID: s0b31e13.077@grpwise.hotchkiss.org (view raw or flat)
Thread:
Lists: pgsql-general
** High Priority **

Hello everyone,

I have a restore file created by pg_dumpall.  The restore file has two
users associated with ownership of tables.  The postgres user and a user
called nsadmin.  

When I attempt to restore this it won't create my call_handlers because
it's not the postgres user.  If I attempt to restore under the nsadmin
user the language handlers fail. 

How can I restore this file without changing everything to postgress
user?  

Thanks.

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2004-05-25 14:41:15
Subject: Re: FW: Majordomo results: subscribe pgsql-general
Previous:From: Bruce MomjianDate: 2004-05-25 14:00:41
Subject: Re: md5 function available since ...?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group