Postgres Pro
Downloads
Home   >   mailing lists

Re: Putting Transaction Logs and Data in separate directories - Mailing list pgsql-admin

From Tom Lane
Subject Re: Putting Transaction Logs and Data in separate directories
Date
Msg-id 4702.1117808570@sss.pgh.pa.us
Whole thread Raw
In response to Putting Transaction Logs and Data in separate directories  (Tim.Shenton@corp.terralycos.com)
List pgsql-admin
Tree view 
Tim.Shenton@corp.terralycos.com writes:
> We are in the process of upgrading our 7.4.6 instance of PG to 8.0.3 which
> includes putting the new instance on new hardware.  The new hardware has
> two Raid 5 disks and one system disk and we were going to play around with
> putting the data directory and the transaction logs on separate disks, but
> short of symlinks, I'm not sure how to do this.

A symlink for the pg_xlog directory is exactly how you should do it.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tim.Shenton@corp.terralycos.com
Date:
Subject: Putting Transaction Logs and Data in separate directories
Next
From: mery lee
Date:
Subject: unsuscribe