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?
