Re: client_encoding error on load

From: "Andrew Goodnough" <agoodno(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: client_encoding error on load
Date: 2008-08-04 04:25:24
Message-ID: f93eaa100808032125g4658db32q6dad6f00f5693f66@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Aug 3, 2008 at 9:38 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "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

Yeah, that's gotta be it. Dumb error, thanks.

Andy

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Lennin Caro 2008-08-04 13:33:25 Re: functions
Previous Message Praveen 2008-08-04 04:23:45 Re: client_encoding error on load