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.