Re: pg_dumpall pg_restore

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Rob Sell <lists(at)facnd(dot)com>
Cc: 'NOVICE PSQL' <pgsql-novice(at)postgresql(dot)org>
Subject: Re: pg_dumpall pg_restore
Date: 2003-11-19 16:39:28
Message-ID: 20031119083811.X85482@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Wed, 19 Nov 2003, Rob Sell wrote:

> Ok this should be simple but I am missing something here.
>
> Yesterday I upgrade to 7.4 before I do that I run
>
> $pg_dumpall > /tmp/pg_keep

IIRC, dumpall uses the text output options of pg_dump which you restore
by passing to psql rather than using pg_restore (which is for the
custom/tar outputs I think).

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Martin Hampl 2003-11-19 17:18:22 index info v7.4
Previous Message Oliver Elphick 2003-11-19 16:22:29 Re: pg_dumpall pg_restore