Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 13 May 2008 10:50:40 -0400
- Message-id: <2A5288FC-B727-4A6D-A371-24CC12817E6E(at)khera(dot)org>
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
- Follow-Ups:
- multicolumn index join
- From: Stephen Ince
- multicolumn index join
- References:
- Stripping out slony after / before / during pg_restore?
- From: Glyn Astill
- Re: Stripping out slony after / before / during pg_restore?
- From: Gurjeet Singh
- Stripping out slony after / before / during pg_restore?
- Prev by Date: Question on warm standby log shipping
- Next by Date: Affected # of Rows After TRIGGER/RULE Return
- Previous by thread: Re: Stripping out slony after / before / during pg_restore?
- Next by thread: multicolumn index join
- Indexes: