Johannes Konert wrote:
Ragnar wrote:
are you planning a filesystem-level backup?
As war as I understood the docu of psql 8.2.4
(http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html
section 23.3.2) you can copy the files while postgres is running
(respecting pg_start_backup and pg_stop_backup)
But that is not my point. The question is where I can change the
enforced chmod 700 postgresql always wants me to set.
You can't.
You can however change the postgresql.conf to put look for files
somewhere besides $PGDATA and thus you would be able to back them up.
Anything else in there you should be grabbing via pg_dump anyway.
Joshua D. Drake
Regards Johannes :)
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
