Re: Performance tuning in Pgsql

On Sun, Dec 12, 2010 at 9:57 PM, Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com> wrote:
>
> Sorry Sir, but I simply followed your steps. I think those are sufficient.
> But my server didn't start after these changes. Here are my 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
>
> Starting PostgreSQL 8.4:
> waiting for server to
> start...............................................................could
> not start server
> PostgreSQL 8.4 did not start in a timely fashion, please see
> /hrd2-p/postgres_data/pg_log/startup.log for details
>
> uima-server:/hrd2-p/postgres_data # vim
> /hrd2-p/postgres_data/pg_log/startup.log
>
> At this time this log is empty. Also I didn/t make any changes in
> postgresql.conf
>
> I'm using Linux ( Linux uima-server 2.6.16.46-0.12-smp #1 SMP Thu May 17
> 14:00:09 UTC 2007 x86_64 x86_64 x86_64 GNU/Linux )
> and postgres ( Postgres 8.4 )

Without that log file it's pretty much impossible to guess what went
wrong. Does your system have SELinux installed? Can it be disabled
for testing? Are the files in /hrd2-p/postgres_data owned by the
postgres user or someone else?