Re: pg_dump/pg_restore

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump/pg_restore
Date: 2008-04-09 13:14:48
Message-ID: 20080409131448.GC12469@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Apr 08, 2008 at 04:52:23PM -0300, Sergio Gabriel Rodriguez wrote:
> needs of others which can't be found because the script will generate
> them later. How can I make an orderer sql dump???

Use the custom format, use pg_restore to get the catalogue, and then edit
that catalogue to re-order the restore..

A

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mikko Partio 2008-04-09 13:47:28 FATAL: could not open relation xxx: No such file or directory
Previous Message Ken Ebling 2008-04-09 10:55:11 Recovering records after running out of disk space