Dump tables with pg_dump - no or different Owner

Поиск
Список
Период
Сортировка
Искать
От
Victor Spång Arthursson
Тема
Dump tables with pg_dump - no or different Owner
Дата
Msg-id
DECAB774-44F2-11D8-A7EB-00039344A3C4@home.se
Список
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 по дате отправления
От: Cláudia Morgado
Дата:
От: Christopher Browne
Дата:
FAQ