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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
