Vanessa Lopez <v.lo...@open.ac.uk> writes: > What do you mean by we can't simply take a filesystem copy of a > running database? :-O ... How should we then do the backups (so next > time I will not have the same problem again) ?
Read the fine manual ... http://www.postgresql.org/docs/8.3/static/backup.html Section 24.2 explains the pitfalls of trying to use a filesystem-level backup. It is possible to do, but you have to be very very careful to get a consistent snapshot. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
