Обсуждение: 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