From: Nick Fankhauser <nickf@ontko.com>
To: David Olbersen <DOlbersen@stbernard.com>
To: pgsql-admin@postgresql.org
Subject: Re: pg_restore problem!!!
Date: Tue, 22 Jul 2003 16:04:31 -0500
Message-ID: <NEBBLAAHGLEEPCGOBHDGAEPEHMAA.nickf@ontko.com> (raw)
In-Reply-To: <E7E213858379814A9AE48CA6754F5ECB0D7005@mail01.stbernard.com>
> To nit-pick, this is a "useless use of cat".
>
> In UNIX-land, simple input redirection will work much better:
>
> psql [dbname and various options] < [filename]
Good point... to elaborate further, the reason I was in a piping mindset is
that with a large database, it also makes sense to compress on the fly to
avoid filesystem size limits, so I usually use this pair of commands for
backup/restore:
pg_dump dbname | gzip > dbdumpfile.gz
gunzip -c dbdumpfile | psql dbname
-Nick
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: nickf@ontko.com, DOlbersen@stbernard.com
Subject: Re: pg_restore problem!!!
In-Reply-To: <NEBBLAAHGLEEPCGOBHDGAEPEHMAA.nickf@ontko.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox