On 8/5/07, Paul Lambert <[EMAIL PROTECTED]> wrote:
> RPK wrote:
> > Before modifying postgresql.conf, do I need to stop PGSQL service?
> >
> >
> >> Enable it in the "Write Ahead Log" section of postgresql.conf file in
> >> the PGDATA directory.
> >
>
> You need to restart PostgreSQL after the file
RPK wrote:
How to change the path of WAL? How much free space to leave on hard disk for
effective performance? Since it is disabled by default, is it insignificant
to ENABLE it?
Just change the settings under the WAL section of the config file. The
WAL files themselves will end up in the pg_x
How to change the path of WAL? How much free space to leave on hard disk for
effective performance? Since it is disabled by default, is it insignificant
to ENABLE it?
>You need to restart PostgreSQL after the file has been modified - it
>does not need to be shut down whilst the modification is
RPK wrote:
Before modifying postgresql.conf, do I need to stop PGSQL service?
Enable it in the "Write Ahead Log" section of postgresql.conf file in
the PGDATA directory.
You need to restart PostgreSQL after the file has been modified - it
does not need to be shut down whilst the modificat
Before modifying postgresql.conf, do I need to stop PGSQL service?
>Enable it in the "Write Ahead Log" section of postgresql.conf file in
>the PGDATA directory.
--
View this message in context:
http://www.nabble.com/WAL-Queries-tf4218911.html#a12003653
Sent from the PostgreSQL - general mail
RPK wrote:
I installed PGSQL on Windows XP. I ran:
Select pg_start_backup('label');
It responded: "Archive disabled"
Is WAL archiving disabled by default?
Can this feature be enabled while installing PGSQL?
Can I change the path of the logs to another partition on my hard disk?
Enable it i
I installed PGSQL on Windows XP. I ran:
Select pg_start_backup('label');
It responded: "Archive disabled"
Is WAL archiving disabled by default?
Can this feature be enabled while installing PGSQL?
Can I change the path of the logs to another partition on my hard disk?
--
View this message in c
