Dump tables with pg_dump - no or different Owner - Mailing list pgsql-general

From Victor Spång Arthursson
Subject Dump tables with pg_dump - no or different Owner
Date
Msg-id EECD1256-44F2-11D8-A7EB-00039344A3C4@tosti.dk
Whole thread Raw
Responses Re: Dump tables with pg_dump - no or different Owner  (Alex Satrapa <alex@lintelsys.com.au>)
List pgsql-general
Hi!

Have a problem, probably easy to solve... I want to dump a database
which resides on my local server with another, and not existing, owner
than the one who actually owns it locally.

The beginning of the dump file looks like:

########
\connect - postgres

SET search_path = public, pg_catalog;

--
-- TOC entry 2 (OID 16978)
-- Name: ingrediens; Type: TABLE; Schema: public; Owner: postgres
########

I want all instances of "postgres" to be changed in the dump (only) to
for example "anotheruser" (which will be the one on the remote server).

I'm having problem dumping from the first to the second server, and
suspects that the differing owners can be the key to solve the
problem...

In advance, lots of thanks,
sincerely:

Victor


pgsql-general by date:

Previous
From: Victor Spång Arthursson
Date:
Subject: Re: problems dumping from one server 2 another
Next
From: Sai Hertz And Control Systems
Date:
Subject: Re: insertion with trigger failed unexpectedly