Problem while pg_xlog directory
От | Adarsh Sharma |
---|---|
Тема | Problem while pg_xlog directory |
Дата | |
Msg-id | 4D0623D7.8040007@orkash.com обсуждение исходный текст |
Ответы |
Re: Problem while pg_xlog directory
Re: Problem while pg_xlog directory |
Список | pgsql-general |
Dear all, I am doing some Performance tuning in Pgsql. I have changed several Parameters in postgresql.conf file. Now I want to change my pg_xlog directory to another disk. I followed the below steps : cd /hrd2-p/postgres_data > /etc/init.d/postgresql-8.4 stop > mkdir -p /opt/pg_xlog > chown -R postgres.postgres /opt/pg_xlog > chmod 700 /opt/pg_xlog > cp -rf pg_xlog/* /opt/pg_xlog > mv pg_xlog pg_xlog_old > ln -s /opt/pg_xlog pg_xlog > /etc/init.d/postgresql-8.4 start But me server fail to start and there is empty log in startup.log. I also checked my permissions and directories are ownedby postgres user. Is I am failing something and there is some simple way. Also, i want to know after Performance tuning following the below link : http://wiki.postgresql.org/wiki/Performance_Optimization. How much our performance increases. I am selecting data from 5Gb file and it takes 229477 ms. Still i execute same query in 226977 ms after some tuning. Please help. Best Regards Adarsh Sharma
В списке pgsql-general по дате отправления: