Backup question

From: A B <gentosaker(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Backup question
Date: 2011-03-01 09:50:55
Message-ID: AANLkTi=z9E+yeH=2Wf6xKB3-_67rjzbQNdmYFU2V-NOO@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello.

In the docs of 8.4 I read that one way of doing filesystem backup of
PostgreSQL is to
1. run rsync
2. stop the server
3. run second rsync
4. start server

But what would happen if you
1. run rsync
2. throw server through the window and buy new server
3. copy the rsynced data
4. start server

now, what would happen?
I guess the server would think: uh-oh, it has crashed, I'll try to fix it.

I understand that you will loose data, but will it be able to get
database in shape and running?
And to reduce the amount of lost data, is there any clever "sync"
command I can run before step 1 to write more stuff to disk?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vibhor Kumar 2011-03-01 10:13:22 Re: Backup question
Previous Message Gnanakumar 2011-03-01 09:01:44 Re: How to upgrade PostgreSQL minor releases without a dump/restore?