Re: migration from postgresql-7.2. to 7.4.1 : invalid command - Mailing list pgsql-admin

From Frederic Medery
Subject Re: migration from postgresql-7.2. to 7.4.1 : invalid command
Date
Msg-id 404F5B49.7040407@lexum.umontreal.ca
Whole thread Raw
In response to Re: migration from postgresql-7.2. to 7.4.1 : invalid command \n  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
I had to you use pg_dump -d -D. now the import works fine !

F


Tom Lane wrote:

>Frederic Medery <dist-list@LEXUM.UMontreal.CA> writes:
>
>
>>I did a pg_dump with the -d option during the extract.
>>Inside the dump I have a lot of \012. i replace those with \n (carriage
>>return).
>>
>>
>
>Huh?  \012 *is* \n.  Carriage return (a/k/a \r or \015) is something
>else, and it is not what you want.
>
>            regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>

pgsql-admin by date:

Previous
From: Greg Spiegelberg
Date:
Subject: Re: Hardware for a database server
Next
From: Bruno Wolff III
Date:
Subject: Re: [PERFORM] syslog slowing the database?