Re: database problem..

Поиск
Список
Период
Сортировка
Искать
От
Jean-Michel POURE
Тема
Re: database problem..
Дата
Msg-id
200203051735.g25HZeLx001856@www1.translationforge
Ответ на
Re: database problem.. (tony)
Список
Дерево обсуждения
pg_dumpall storing multiple copies of DB's? Bill McGonigle <mcgonigle@medicalmedia.com>
Re: pg_dumpall storing multiple copies of DB's? Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dumpall storing multiple copies of DB's? Bill McGonigle <mcgonigle@medicalmedia.com>
Re: pg_dumpall storing multiple copies of DB's? Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dumpall storing multiple copies of DB's? Bill McGonigle <mcgonigle@medicalmedia.com>
Re: pg_dumpall storing multiple copies of DB's? Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dumpall storing multiple copies of DB's? Bill McGonigle <mcgonigle@medicalmedia.com>
Re: pg_dumpall storing multiple copies of DB's? Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dumpall storing multiple copies of DB's? Bill McGonigle <mcgonigle@medicalmedia.com>
database problem.. Petre Daniel <dani@cyber.ro>
Re: database problem.. tony <tony@animaproductions.com>
Re: database problem.. Jean-Michel POURE <jm.poure@freesurf.fr> 
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
В списке pgsql-general по дате отправления
Предыдущее
От: Jeff Boes
Дата:
Следующее
От: Tom Lane
Дата:
FAQ