| From: | Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: WAL Queries |
| Date: | 2007-08-05 11:00:19 |
| Message-ID: | 46B5ADC3.2060206@autoledgers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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_xlog directory in pgdata, but
you can define the archive_command setting to archive the files off to
another directory.
Refer to the WAL section of the manual for details on what to set the
settings to.
http://www.postgresql.org/docs/8.2/interactive/wal-configuration.html
How much hard-disk space you need is largely dependant on the size of
your database and the size and frequency of updates coming through.
--
Paul Lambert
Database Administrator
AutoLedgers
| From | Date | Subject | |
|---|---|---|---|
| Next Message | RPK | 2007-08-05 11:03:10 | Tablespace |
| Previous Message | RPK | 2007-08-05 10:53:56 | Re: WAL Queries |