Re: client_encoding error on load

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew Goodnough" <agoodno(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: client_encoding error on load
Date: 2008-08-04 02:38:14
Message-ID: 19201.1217817494@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Andrew Goodnough" <agoodno(at)gmail(dot)com> writes:
> I'm using these commands to perform a dump and load.
> pg_dump -c lakevie_typo | gzip > $HOME/backups/typo_$DATE.sql.gz
> gzip < $HOME/backups/typo_$DATE.sql.gz |psql -d lakevie_typobak -f -

Surely the second step must start with gunzip?

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Praveen 2008-08-04 04:23:45 Re: client_encoding error on load
Previous Message Andrew Goodnough 2008-08-04 01:59:27 client_encoding error on load