Re: Stripping out slony after / before / during pg_restore?

From: Vivek Khera <vivek(at)khera(dot)org>
To: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
Cc: Slony List <slony1-general(at)lists(dot)slony(dot)info>, Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Stripping out slony after / before / during pg_restore?
Date: 2008-05-13 14:50:40
Message-ID: 2A5288FC-B727-4A6D-A371-24CC12817E6E@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Here's how you do it on restore step from a pg_dump in -Fc format.

pg_restore -l dumpfile > list
edit the file "list" to remove references to slony objects
pg_restore -L list <other options you want> dumpfile

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Volkan YAZICI 2008-05-13 14:59:27 Affected # of Rows After TRIGGER/RULE Return
Previous Message Alvaro Herrera 2008-05-13 14:47:40 Re: Making sure \timing is on