Re: Suppress checking of chmod 700 on data-dir? - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Suppress checking of chmod 700 on data-dir?
Date
Msg-id 46686F16.3060401@commandprompt.com
Whole thread Raw
In response to Re: Suppress checking of chmod 700 on data-dir?  (Johannes Konert <jkonert@t3go.de>)
Responses Re: Suppress checking of chmod 700 on data-dir?  (Johannes Konert <jkonert@t3go.de>)
List pgsql-general
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/


pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Suppress checking of chmod 700 on data-dir?
Next
From: Jonathan Vanasco
Date:
Subject: list all columns in db