Re: Putting Transaction Logs and Data in separate directories

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tim(dot)Shenton(at)corp(dot)terralycos(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Putting Transaction Logs and Data in separate directories
Date: 2005-06-03 14:22:50
Message-ID: 4702.1117808570@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tim(dot)Shenton(at)corp(dot)terralycos(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message woody 2005-06-03 16:26:29 Re: unable to GRANT on sequence
Previous Message Tim.Shenton 2005-06-03 13:26:46 Putting Transaction Logs and Data in separate directories