Moving pg_xlog folder

Поиск
Список
Период
Сортировка
От Wei Shan
Тема Moving pg_xlog folder
Дата
Msg-id CAFe9ZTrzpNkHn14nk9roN3K+Znjdct+Nb_M5c8hLa8khS4JVyw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Moving pg_xlog folder
Re: Moving pg_xlog folder
Список 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 по дате отправления: