Question on database backup - Mailing list pgsql-hackers

From Michael Brusser
Subject Question on database backup
Date
Msg-id DEEIJKLFNJGBEMBLBAHCOEJFEDAA.michael@synchronicity.com
Whole thread Raw
In response to Re: array surprising behavior  (Joe Conway <mail@joeconway.com>)
Responses Re: Question on database backup
List pgsql-hackers
We have customers who prefer to use their backup facilities
instead of what we provide in the app (we use pg_dump)
I hear speed is at least one consideration.

The questions I need to answer are these:

1) Is this absolutely safe to do file copy (cpio, or 
smth. else, whatever the robust backup app. would use)
on the Postgres db, when it's completely shut down.

2) Same question, but the database is up and running in
read-only mode. We're making sure that no updates are 
taking place.

If it matters - this is on Solaris, HP, Linux.
We're using v.7.3.2 running on UDS and v.7.3.4 on TCP/IP
We provide no explicit settings for wal, fsync and the like.
And (yes, I know) they often install it on NFS.

Thank you much.
Mike.








pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: implemented missing bitSetBit() and bitGetBit()
Next
From: Josh Berkus
Date:
Subject: Re: Recursive queries?