From: | Willy Wonka <lunchtime(at)onethirty(dot)org> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: old db on a new system |
Date: | 2002-09-27 23:51:25 |
Message-ID: | p05111704b9ba9e42bc46@[192.168.1.129] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
after some playing, we finally got postgres 7.0.3 running, now on
pg_dump, i get an error:
> ./bin/pg_dumpall > dumped
ERROR: Cannot insert a duplicate key into unique index pg_type_typname_index
ERROR: Relation 'tmp_pg_shadow' does not exist
ERROR: Relation 'tmp_pg_shadow' does not exist
if i try just one database, i get this:
> pg_dump immedia > immediadb
Connection to database 'immedia' failed.
FATAL 1: Database 'immedia', OID 18784, has disappeared from pg_database
but the database is in pg_database.
if i sound a bit lost, it's because i am. up until this point, all i
had to do was install postgres, and somebody else used/maintained it.
>ok, so i've got a pretty bad problem.
>my system go borked last week, and i had to back everything up and reinstall.
>i was running postgresql 7.0.* on openbsd2.8.
>i switched to gentoo 1.2, and it emerged postgresql 7.2.2.
>
>now i've got some old databases on a new system that can't use them.
>my brother tried installing postgresql 7.0.3 on his openbsd 3.1
>system [so i could do what the docs say, pg_dumpall], but can't get
>it started because of some nasty shmget errors.
>specifically:
>IpcMemoryCreate: shmget failed (Permission denied) key=5432010,
>size=144, permission=700
>
>i really need to get these databases back online. is there anything i can do?
>--
>=-=--------------------------------------------=-=
> -.c.-
>
> My mistress when she walks treads on the ground.
From | Date | Subject | |
---|---|---|---|
Next Message | Willy Wonka | 2002-09-28 00:13:41 | pg_dumpall fails |
Previous Message | Willy Wonka | 2002-09-27 23:13:26 | old db on a new system |