Re: [GENERAL] Changing WAL Directory in Postgres

2010-12-15 Thread Filip RembiaƂkowski
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 > Hi all, > > From the last 2 days I am researching on Performance Tuning in Postgres. > > For this , I have to change my WAL directory t

Re: [GENERAL] Changing WAL Directory in Postgres

2010-12-14 Thread John R Pierce
On 12/14/10 10:49 PM, Adarsh Sharma wrote: 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. instead, I would create the d

[GENERAL] Changing WAL Directory in Postgres

2010-12-14 Thread Adarsh Sharma
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 p