Postgres Pro
Downloads
Home   >   mailing lists

Re: Changing WAL Directory in Postgres - Mailing list pgsql-general

From Filip Rembiałkowski
Subject Re: Changing WAL Directory in Postgres
Date
Msg-id AANLkTi=Z3qeoyOk178KT_ZQDmR2aGVEkmVoQJ93qnvHk@mail.gmail.com
Whole thread Raw
In response to Changing WAL Directory in Postgres  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List pgsql-general
Tree view

in short:

sudo su - postgres
pg_ctl stop -m fast
cd $PGDATA
mv pg_xlog /another/device
ln -s /another/device/pg_xlog .
pg_ctl start


2010/12/15 Adarsh Sharma <adarsh.sharma@orkash.com>
Hi all,

From the last 2 days I am researching on Performance Tuning in Postgres.

For this , I have to change my WAL directory to other disk than the data directory. But I am not able to find the correct way to do this.

Please be kind to advice.


Thanks & Regards

Adarsh Sharma

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Linux: PAE or x64
Next
From: Jacqui Caren-home
Date:
Subject: Re: Understanding Schema's