X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 31A06D1B534 for ; Wed, 10 Mar 2004 18:08:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 85851-08 for ; Wed, 10 Mar 2004 14:08:51 -0400 (AST) Received: from cougar.DIT.UMontreal.CA (chene.DIT.UMontreal.CA [132.204.246.20]) by svr1.postgresql.org (Postfix) with ESMTP id 2E6DFD1B467 for ; Wed, 10 Mar 2004 14:08:49 -0400 (AST) Received: from chene.DIT.UMontreal.CA(132.204.246.20) by cougar.DIT.UMontreal.CA via csmap id 327ab61e_72be_11d8_905c_0002b39fa8dc_16048; Wed, 10 Mar 2004 13:10:23 -0500 (EST) Received: from cougar.DIT.UMontreal.CA (ravenna.LEXUM.UMontreal.CA [132.204.136.56]) by chene.DIT.UMontreal.CA (8.12.10/8.12.10) with ESMTP id i2AI8kOg020064 for ; Wed, 10 Mar 2004 13:08:46 -0500 Received: from ravenna.LEXUM.UMontreal.CA(132.204.136.56) by cougar.DIT.UMontreal.CA via csmap id 304d5252_72be_11d8_94ae_0002b39fa8dc_16040; Wed, 10 Mar 2004 13:10:18 -0500 (EST) Received: from lexum.umontreal.ca ([::ffff:192.168.4.171]) (AUTH: PLAIN mederyf, TLS: TLSv1/SSLv3,128bits,RC4-MD5) by mail.lexum.umontreal.ca with esmtp; Wed, 10 Mar 2004 13:01:52 -0500 Message-ID: <404F5B49.7040407@lexum.umontreal.ca> Date: Wed, 10 Mar 2004 13:15:37 -0500 From: Frederic Medery User-Agent: Mozilla Thunderbird 0.5 (X11/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: pgsql-admin@postgresql.org Subject: Re: migration from postgresql-7.2. to 7.4.1 : invalid command References: <404E3E4D.6060102@lexum.umontreal.ca> <460.1078878330@sss.pgh.pa.us> In-Reply-To: <460.1078878330@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-NAI-Spam-Score: -1.0 X-NAI-Spam-Rules: 1 Rules triggered EMAIL_ATTRIBUTION=-0.977 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/193 X-Sequence-Number: 12762 I had to you use pg_dump -d -D. now the import works fine ! F Tom Lane wrote: >Frederic Medery 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 > >