Re: Postgres does not start, gives no error

From: "Akhtar Yasmin-B05532" <B05532(at)freescale(dot)com>
To: "Adrian Klaver" <aklaver(at)comcast(dot)net>, <pgsql-general(at)postgresql(dot)org>
Cc: "Christophe" <xof(at)thebuild(dot)com>
Subject: Re: Postgres does not start, gives no error
Date: 2008-09-05 04:13:28
Message-ID: C0F75310EB29C743AAB5403624E7B103022D3831@az33exm25.fsl.freescale.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I 've finally been able to solve my problem.
There were two errors,
1) The postgres in the data directory had gotten overwritten, so none of the scripts were running.
I found out this, when I tried making another instance of data.
The initdb was not working. As well asa other scipts.
Had to fix this.
2) Also,the user which I was using had insufficient permissions.

Thanks a lot for all you suggestions.

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Adrian Klaver
Sent: Thursday, September 04, 2008 6:51 PM
To: pgsql-general(at)postgresql(dot)org
Cc: Christophe
Subject: Re: [GENERAL] Postgres does not start, gives no error

On Thursday 04 September 2008 3:32:55 pm Christophe wrote:
> On Sep 4, 2008, at 11:34 AM, Akhtar Yasmin-B05532 wrote:
> > I am really stuck here. And need to get a way thru all of this.
> > Any suggestions will be really appreciated.
>
> Have you confirmed that the user that you are logged in as when you
> attempt to start Postgres has write access to /home/data/www/pg7/data?

In these sort of situations I do a one step at a time approach.
1) Verify you have only one installation of Postgres.
a) For instance use find to determine if there is more than one pg_ctl
b) Look for multiple copies of postgresql.conf and pg_hba.conf
2) Verify that there is actually data in /home/data/www/pg7/data
3) Go through postgresql.conf and pg_hba.conf to check they are valid.
a)If possible post the contents here to help with the troubleshooting.
b) As was suggested turn on logging in postgresql.conf.
4) When you do this:
pg_ctl start /home/data/www/pg7/data
        Does not start postgres but gives a msg that "Poatgres is started successfully"
Check for a Postgres process running. I have not used Solaris, but I am thinking the equivalent of ps ax|grep post.
5) In your original post you started with:
"I am facing this peciliar problem.I am using postgres 7.2.2 installed on solaris.
It has been running very well since all the time, until somebody tried to stop it. Using the command "
In the version I got the stop command was not shown. What was used to stop Postgres?
6) If there is a startup script what does it contain?

Hope this helps,
--
Adrian Klaver
aklaver(at)comcast(dot)net

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2008-09-05 04:15:04 Re: You need to rebuild PostgreSQL using --with-libxml.
Previous Message Artacus 2008-09-05 03:52:13 Re: Getting affected rows in pgplsql