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? -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
