Moving pg_xlog folder - Mailing list pgsql-admin

From Wei Shan
Subject Moving pg_xlog folder
Date
Msg-id CAFe9ZTrzpNkHn14nk9roN3K+Znjdct+Nb_M5c8hLa8khS4JVyw@mail.gmail.com
Whole thread Raw
Responses Re: Moving pg_xlog folder  (Venkata Balaji N <nag1010@gmail.com>)
Re: Moving pg_xlog folder  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-admin
Hi all,

OS: CentOS
PG version: 9.3

I'm testing the scenario of moving the xlog folder to a fast pair of disk. This was the steps I followed;

1. create new mountpoint with the correct permissions
2. Shutdown DB
3. Create softlink from new mountpoint to $PG_DATA/pg_xlog
4. Startup DB

However, after I start the DB, I hit the following error;

-bash-4.1$ psql

psql: could not connect to server: No such file or directory

Is the server running locally and accepting

connections on Unix domain socket "/tmp/.s.PGSQL.5432"?


This issue resolves by itself once I reboot the server after I move the XLOG. Any ideas what I did wrongly?

Thanks!
--
Regards,
Ang Wei Shan

pgsql-admin by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Does VACUUM FULL need ANALYZE ?
Next
From: litu16
Date:
Subject: SELECT column WHERE (type = 'S' OR type = 'B') but perform different actions depending on whether type = 'S' or 'B'