Disaster Database recovery
От | Teri Holmes |
---|---|
Тема | Disaster Database recovery |
Дата | |
Msg-id | 4C223DEF.A312.004D.0@co.benton.wa.us обсуждение исходный текст |
Ответы |
Re: Disaster Database recovery
|
Список | pgsql-novice |
We have a Postgres database that is so huge(images are stored inside the database) that any Pg_dump configuration I triedwouldn't finish. After taking with the software vendor it was decided that nightly a pg_dump would be done excludingthe table with the images in it. Then once a week the images would be backed up by stopping the server, tar & zippingthe whole folder where the database resided. The database and the backup lived on different volumes but all on thesame SAN. The SAN failed one afternoon and completely died the next AM. We were left with nothing. The drives werecollected and sent to a data recovery specialist. I am fairly certain that the tar/zip that was created of the databasefolder is corrupt because during that couple hour window between the first drive failure the ultimate third drivefailure. I checked out the backup and it had some issues. We purchased and configured a new SAN unit and have volumes created for the Postgres Database that duplicate what the oldSAN looked like. So when(I have to think when and not IF) I get the data back, can I just copy the old postgres databasefolder contents to the new location and start the service back up? I've contacted the software vendor and they said...."We don't have a postgres expert on staff, so you are sort of on yourown with that" Any advice? Teri L. Holmes Benton County Central Services 509 786 5603 --------------------------------------------------- Chaos reigns within Reflect, repent, and reboot. Order shall return. ---------------------------------------------------
В списке pgsql-novice по дате отправления: