DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=WO7EBRvd4Uh7W25yemfql/xi9bmhtaLlTDewaCM0EF+jac7l5fkVCseIr7WbThz+TD
	2i5XTUu/S0MQNGiIHbhHBH7/oLwWpU0Ep0Jj3TaEDsoUMkfKodxjMv1R870WXmoKIrXu
	SExHGmvJkvj6GOTvy44EdF7FTicrQMeypbd1U=
Message-ID: <1561aee60811170655h55a5a777kf6862d2a262ad3f@mail.gmail.com>
Date: Mon, 17 Nov 2008 07:55:27 -0700
From: "Anony Mous" <fyngyrz@gmail.com>
To: pgsql-admin@postgresql.org
Subject: restore failure
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_50370_13345640.1226933727354"

------=_Part_50370_13345640.1226933727354
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I have a moderate size database under RH9 / pgsql 7.3 (I think... that's the
PG_VERSION in the postgres user data directory.) Under 100 mb for the whole
thing.

I'm trying to move the DB to postgresql 8.3 under the current ubuntu in a
4-core, 4gb machine. postgresql appears to be installed and working; I added
a home directory and password so I could su - postgres and work as the
postgres user as I did under RH9; other than that, no fiddling. A small test
db acted perfectly normally as far as I coudl tell.

My database uses oids in a few places. I don't recall where or know how to
figure out where (it's been years since I worried about the DB structure -
it isn't broken); but I know it does use 'em.

I have tried pg_dump with -o and without. In both cases, under 7.3, the
command produces output without complaint.

With -o, 8.3 chokes on the restore in many places, as if it didn't know what
it was looking at. There are remarks about 'table "pgdump_oid" does not have
oids' and there are pointers to \; at the end of a line... then it says
'syntax error at or near "94513916" (an oid?) after a create table

Without -o, things proceed a bit better; during the restore there are errors
complaining about characters not in UTF-8 (but both 7.3 and 8.3 are using
UTF-8... I have NO idea what its problem is but I surely know I want what
was in the old table, in the new table too!), and in one case, an INDEX
fails, indicating there is no OID column. Doesn't indicate what it's trying
to index, though. After the restore, many tables are empty that should
contain a great deal of data. Others appear to have been restored.

I don't know where to turn. The docs for pg_dump seem clear, use -o (because
I use oids,) Use -c so that the database items are created. But restore
doesn't work, and the error messages are opaque, to be generous. without -o,
I'm not much better off. What now?

Thanks for any help. I'm beyond desperate. The HD is failing on the old
server, and RH9 won't install on the newer machines. I have backups (but
since I can't retrieve them.... !!!!!)

Is it possible to install the 7.3 postgresql version under ubuntu? If so,
where would I find it?

------=_Part_50370_13345640.1226933727354
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I have a moderate size database under RH9 / pgsql 7.3 (I think... that&#39;s the PG_VERSION in the postgres user data directory.) Under 100 mb for the whole thing.<br><br>I&#39;m trying to move the DB to postgresql 8.3 under the current ubuntu in a 4-core, 4gb machine. postgresql appears to be installed and working; I added a home directory and password so I could su - postgres and work as the postgres user as I did under RH9; other than that, no fiddling. A small test db acted perfectly normally as far as I coudl tell.<br>
<br>My database uses oids in a few places. I don&#39;t recall where or know how to figure out where (it&#39;s been years since I worried about the DB structure - it isn&#39;t broken); but I know it does use &#39;em.<br><br>
I have tried pg_dump with -o and without. In both cases, under 7.3, the command produces output without complaint.<br><br>With -o, 8.3 chokes on the restore in many places, as if it didn&#39;t know what it was looking at. There are remarks about &#39;table &quot;pgdump_oid&quot; does not have oids&#39; and there are pointers to \; at the end of a line... then it says &#39;syntax error at or near &quot;94513916&quot; (an oid?) after a create table<br>
<br>Without -o, things proceed a bit better; during the restore there are errors complaining about characters not in UTF-8 (but both 7.3 and 8.3 are using UTF-8... I have NO idea what its problem is but I surely know I want what was in the old table, in the new table too!), and in one case, an INDEX fails, indicating there is no OID column. Doesn&#39;t indicate what it&#39;s trying to index, though. After the restore, many tables are empty that should contain a great deal of data. Others appear to have been restored.<br>
<br>I don&#39;t know where to turn. The docs for pg_dump seem clear, use -o (because I use oids,) Use -c so that the database items are created. But restore doesn&#39;t work, and the error messages are opaque, to be generous. without -o, I&#39;m not much better off. What now?<br>
<br>Thanks for any help. I&#39;m beyond desperate. The HD is failing on the old server, and RH9 won&#39;t install on the newer machines. I have backups (but since I can&#39;t retrieve them.... !!!!!)<br><br>Is it possible to install the 7.3 postgresql version under ubuntu? If so, where would I find it?<br>
<br>

------=_Part_50370_13345640.1226933727354--