Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: PraveenDate: 2008-08-04 04:23:45
Subject: Re: client_encoding error on load
Previous:From: Andrew GoodnoughDate: 2008-08-04 01:59:27
Subject: client_encoding error on load

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group