Re: problem with pg_restore? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: problem with pg_restore?
Date
Msg-id dcc563d10907230640h582a82ddv3d1d3aeebca73bb1@mail.gmail.com
Whole thread Raw
In response to problem with pg_restore?  (Jim Michaels <jmichae3@yahoo.com>)
Responses Re: problem with pg_restore?
List pgsql-general
On Tue, Jul 14, 2009 at 5:47 PM, Jim Michaels<jmichae3@yahoo.com> wrote:
> I am having problems with pg_restore.  pg_restore
> --file=c:\pg-jmichae3-7-13-2009.sql --verbose --host=localhost --port=5432
> --username=postgres
>
> this just hangs.
> I am restoring from 8.3.7 to 8.4 - what did I do wrong?
>
> could somebody rewrite pg_dumpall and pg_dump so that it makes editable
> dumps?
> most programmer's text editors can't handle more than 2000 characters per
> line.
> and I want to be able to edit my dumps.

When I need to make changes to large dumps I use tools like sed, awk
and diff, not a text editor.

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: A question on PSQL 8.3 setup
Next
From: Sam Mason
Date:
Subject: Re: comparing NEW and OLD (any good this way?)