From: | Wei Shan <weishan(dot)ang(at)gmail(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Moving pg_xlog folder |
Date: | 2015-06-27 18:49:38 |
Message-ID: | CAFe9ZTrzpNkHn14nk9roN3K+Znjdct+Nb_M5c8hLa8khS4JVyw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Venkata Balaji N | 2015-06-28 03:04:48 | Re: Moving pg_xlog folder |
Previous Message | litu16 | 2015-06-27 17:43:19 | SELECT column WHERE time_type = 'Break' but only the rows that are after(below) time_type = 'Start' |