X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9A2B3D1B392 for ; Tue, 13 Jul 2004 07:42:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50082-10 for ; Tue, 13 Jul 2004 10:42:31 +0000 (GMT) Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id D78F7D1B381 for ; Tue, 13 Jul 2004 07:42:20 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by ucsns.ucs.co.za (Postfix) with ESMTP id 68CE92BD82 for ; Tue, 13 Jul 2004 12:42:22 +0200 (SAST) Received: from ucsns.ucs.co.za ([127.0.0.1]) by localhost (ucsns.ucs.co.za [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10929-03 for ; Tue, 13 Jul 2004 12:41:59 +0200 (SAST) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id C20172BD87 for ; Tue, 13 Jul 2004 12:40:08 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id 91381DACFF for ; Tue, 13 Jul 2004 12:40:08 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with SMTP id 7DEBC9768E for ; Tue, 13 Jul 2004 12:40:06 +0200 (SAST) Date: Tue, 13 Jul 2004 12:40:00 +0200 From: Stef To: pgsql-admin@postgresql.org Subject: Re: Bad dumps... Message-Id: <20040713124000.49a556a0@svb.ucs.co.za> In-Reply-To: <20040712095203.333c8aa2@svb.ucs.co.za> References: <5.1.0.14.0.20040709093611.05621ea0@mailserver.dmr.co.uk> <20040709095738.5738334f@svb.ucs.co.za> <5.1.0.14.0.20040709093611.05621ea0@mailserver.dmr.co.uk> <5.1.0.14.0.20040709122158.055ac630@mailserver.dmr.co.uk> <20040709161641.3e164d8f@svb.ucs.co.za> <1089429340.10763.10.camel@localhost.localdomain> <20040712095203.333c8aa2@svb.ucs.co.za> X-Mailer: Sylpheed-Claws 0.9.12 (GTK+ 1.2.10; i386-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: GFoC95e6r)_TTG>n~=uFLojP=O~4W@Ms]>:.DMm/')(z3\Mwj^XP@? Q:3";lD.OM1"^mDu}2NJ@US:)dO:U*iY5EM50&Tx. X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="pgp-sha1"; boundary="Signature=_Tue__13_Jul_2004_12_40_00_+0200_oSB5SB77jedT=VNQ" X-Virus-Scanned: by amavisd-new at ucs.co.za X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/140 X-Sequence-Number: 14208 --Signature=_Tue__13_Jul_2004_12_40_00_+0200_oSB5SB77jedT=VNQ Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable I found that it was actually a '\\N' value only that causes=20 dumps to dump successfully, but fail on import (When using COPY), because both '\N' and '\\N' are seen as null by the COPY statement. I just happened to have '\\N' values in my NOT NULL text field. I now manually use this dump command : pg_dump | sed 's:\\\\N:=AC:g' | gzip > dump.gz and do the reverse sed to restore. Stef mentioned : =3D> mike g mentioned : =3D> =3D> That could be a bug. How are you dumping the data? pg_dump? Se= lect =3D> =3D> query? How are you restoring the data? psql?=20=20 =3D>=20 =3D> Dumping: =3D> pg_dump -Ft | gzip > dump.tgz =3D>=20 =3D> Restoring: =3D> zcat dump.tgz | pg_restore -Ft |psql =3D> OR =3D> tar xvfz dump.tgz =3D> perl -pi -e 's/\$\$PATH\$\$/$ENV{PWD}/g' restore.sql =3D> psql -f restore.sql =3D>=20 =3D> Both these methods, produce the same result. =3D>=20 --Signature=_Tue__13_Jul_2004_12_40_00_+0200_oSB5SB77jedT=VNQ Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iQCVAwUBQPO8BroLc+HYd7LFAQL9AgQAn/ij9J4FpeTVm+l6V0uquF7nSIsDcdZC jT+MlIR+LR6Ivjn3D0c0b/soJW351kxBZPailzXcwo1NnWPvuArOHADII8c+76A7 SMpOpKVlt8SyXVaYyyzSXZJB8eG0ELFkjLo5RktoZnCt5DRte9TJyTWA3g7EnyoT QQyx7uB31hs= =1CJH -----END PGP SIGNATURE----- --Signature=_Tue__13_Jul_2004_12_40_00_+0200_oSB5SB77jedT=VNQ--