Re: postgresql.conf archive_command example - Mailing list pgsql-hackers

From Robert Haas
Subject Re: postgresql.conf archive_command example
Date
Msg-id CA+Tgmobjv9BsJaMWZKyOb0gpaR99cBj4m6rU32_K9VAH+DPikg@mail.gmail.com
Whole thread Raw
In response to Re: postgresql.conf archive_command example  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: postgresql.conf archive_command example
List pgsql-hackers
2011/9/1 Dimitri Fontaine <dimitri@2ndquadrant.fr>:
> Peter Eisentraut <peter_e@gmx.net> writes:
>> Well, we could make initdb patch it up, but that might seem excessive.
>
> I sometime wonder if archive_mode shouldn't default to "on" with the
> archive_command set to either '/bin/true' or 'rem' for windows.
>
> That allows to install proper archiving without restart, but the
> tradeoff is of course that you need to restart to enable some
> optimisation cases by turning archive_mode off.

Seems like it would be better to fix archive_mode so that it can be
changed without a restart.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: WIP: Fast GiST index build
Next
From: Oleg Bartunov
Date:
Subject: Re: WIP: SP-GiST, Space-Partitioned GiST