Re: Backups and restores. - Mailing list pgsql-general

From Doug McNaught
Subject Re: Backups and restores.
Date
Msg-id m3k7bykkd6.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Backups and restores.  (Brian Avis <brian.avis@searhc.org>)
List pgsql-general
Brian Avis <brian.avis@searhc.org> writes:

> I am upgrading my workstation to 7.3.3.   I have some database backups
> that were created with this command.
>
> /usr/local/pgsql/bin/pg_dump $db | gzip > /usr/local/pgsql/backups/$filename
>
> Which generates this sort of file.
>
> pgdump_2003-6-5-csp.gz

For dumps in SQL format (the default), feed them to 'psql' rather than
using 'pg_restore', which is for "tar" and "custom" format dumps.

-Doug

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: timestamp
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Optimizer failure on integer column?