Re: database problem..

Le Mardi 5 Mars 2002 17:13, tony a écrit :
> If your postgresql version is older than 7.1 then say adieu to your data
> now...

I experienced a crash on a Linux station (power-failure) and noticed that
some row-level locking prevented PostgreSQL from starting up.

After backup, you may need to start the single-user version of postgreSQL.
This will unlock rows :

1) Copy /var/lib/pgsql/data/ to another computer. The other computer should
run the exact same version of PostgreSQL. Otherwize, wait for a more detailed
help from this forum.

2) postgresql DATABASE_NAME will start PostgreSQL in single-user mode.

Can anyone confirm, I am not  familiar with database recovery.

/Jean-Michel POURE