pg_dumpall to psql -f NOT working

From: Ketema <ketema(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dumpall to psql -f NOT working
Date: 2007-08-12 16:03:34
Message-ID: 1186934614.439522.251080@19g2000hsx.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello. I performed a pg_dumpall of my 8.1 db cluster and upgraded to
8.2.4. the dump went fine and the script file appears to be fine. I
have a mixture of UTF8 and SQL_ASCII databases in the dump. However I
am not able to restore my data after the upgrade. I performed from
the command line
psql -f myfile -U postgres postgres

the process starts ok then it fails in the data resotration. What i
see onthe command line is a bunch of invalid commands because of psql
interpreting data as commands.

I had specifically not did insert statements because the documentation
said the copy commands were much faster, now I am regretting it. How
can I get psql to interpret the dumpfile correctly and restore my
data?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message dterrors 2007-08-12 16:11:53 Re: Are these two creation commands functionally identical?
Previous Message Martijn van Oosterhout 2007-08-12 13:39:39 Re: timestamp skew during 7.4 -> 8.2 upgrade