Re: Performance tuning in Pgsql - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Performance tuning in Pgsql
Date
Msg-id AANLkTinFBX1VfT=2dDbJn+xe3c1soGe23ErO9ytNyeeK@mail.gmail.com
Whole thread Raw
In response to Re: Performance tuning in Pgsql  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List pgsql-general
On Sun, Dec 12, 2010 at 9:57 PM, Adarsh Sharma <adarsh.sharma@orkash.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?

pgsql-general by date:

Previous
From: Jan Kesten
Date:
Subject: Re: pg_dump order of rows
Next
From: Hampus Wessman
Date:
Subject: Re: pg_dump order of rows