restore from a pg_dumpall file - Mailing list pgsql-general

From Bob Powell
Subject restore from a pg_dumpall file
Date
Msg-id s0b31e13.077@grpwise.hotchkiss.org
Whole thread Raw
Responses Re: restore from a pg_dumpall file  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: md5 function available since ...?
Next
From: Tom Lane
Date:
Subject: Re: FW: Majordomo results: subscribe pgsql-general