PG dump and restore - Mailing list pgsql-general

From Dennis C
Subject PG dump and restore
Date
Msg-id AANLkTin3viErR9PLqTk0gIueJ7D0CXcfAhJ13mfkabc9@mail.gmail.com
Whole thread Raw
Responses Re: PG dump and restore
Re: PG dump and restore
List pgsql-general
Greetings;

As I've been doing for quite some time, backed up my database as such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access -Z 5 Trading-Access

But then when I tried restoring it my usual way as such: /opt/local/lib/postgresql84/bin/pg_restore -d Trading-Access ./Trading-Access
it causes the error: pg_restore: [archiver] input file does not appear to be a valid archive

So in trying: /opt/local/lib/postgresql84/bin/psql Trading-Access < ./Trading-Access
it causes the error: invalid byte sequence for encoding "UTF8": 0x8b

Thanks,

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Waarschuwing na pg_dumpall en restore
Next
From: Thom Brown
Date:
Subject: Re: PG dump and restore