Thread: old db on a new system
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.
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.
Willy Wonka <lunchtime@onethirty.org> writes: > after some playing, we finally got postgres 7.0.3 running, now on > pg_dump, i get an error: >> pg_dump immedia > immediadb > Connection to database 'immedia' failed. > FATAL 1: Database 'immedia', OID 18784, has disappeared from pg_database Try "vacuum pg_database". regards, tom lane
On Fri, Sep 27, 2002 at 07:13:26PM -0400, Willy Wonka wrote: > 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 This is a kernel problem. You should read the administrator's guide section about kernel resources. A ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <andrew@libertyrms.info> M2P 2A8 +1 416 646 3304 x110