Re: Restart failed with 'service postgresql restart' - Mailing list pgsql-admin

From Major Services
Subject Re: Restart failed with 'service postgresql restart'
Date
Msg-id 375c2da1003030432t1b60a71ay3fac059c4caf094d@mail.gmail.com
Whole thread Raw
In response to Re: Restart failed with 'service postgresql restart'  (Iñigo Martinez Lasala <imartinez@vectorsf.com>)
List pgsql-admin
Hi,

There is no change in the pgstartup.log

Now I hope,  I can run the start command; either one of the two - by
root or postgres. Right?

Yes, I am new to both; as mentioned earlier also.
Look forward to mastering PostgreSQL with the help of the community!

Thanks a lot.

On Wed, Mar 3, 2010 at 5:34 PM, Iñigo Martinez Lasala
<imartinez@vectorsf.com> wrote:
> Let's see.
> Could you provide us again pgstartup.log?
>
> First problem was you had a problem with postgresql.conf syntax.
> Then, you had a problem with lock files, probably because a bad shutdown
> (perhaps a kill?)
>
> Anyway, how long have you worked with Unix environments? I think you are new
> to this world, don't you? ;-)
>
> In order to start postgres you have several ways to do it.
>
> - as root user: "service postgresql start" or "/etc/init.d/postgresql start"
> - as postgres user "su - postgres", run "pg_ctl start -D /var/lib/pgsql"
>
>
> -----Original Message-----
> From: Major Services <services.major@gmail.com>
> To: Paul Anderson <paul.a@pnlassociates.com>
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Restart failed with 'service postgresql restart'
> Date: Wed, 3 Mar 2010 12:51:09 +0530
>
> 'pg_ctl status' returns 'neither postmaster nor postgres running'.
>
> Looking for help restart postgres.
>
> Thanks
>
> On Wed, Mar 3, 2010 at 9:58 AM, Major Services <services.major@gmail.com>
> wrote:
>> Where to look for postmaster.pid?
>> It is not in the data directory. There is one file postmaster.opts there.
>>
>> Should I try running 'pg_ctl start -l logfile' ?
>>
>> On Tue, Mar 2, 2010 at 10:24 PM, Paul Anderson <paul.a@pnlassociates.com>
>> wrote:
>>> After verifying that the postmaster was not running you did remove the
>>> postmaster.pid file, right?
>>>
>>> FATAL: lock file "postmaster.pid"already exists
>>>
>>>
>>> On 3/2/10 11:43 AM, Major Services wrote:
>>>>
>>>> Help me start the server.
>>>> As I mentioned in an earlier post today (subject: password
>>>> authentication failed for user postgres), 'service postgresql restart'
>>>> had stopped the server but  *server
>>>> start failed*.
>>>>
>>>> Step wise list of commands to be given would be great!
>>>> Do I need to login as postgres?
>>>>
>>>> Being new to PostgreSQL, am looking for some hand-holding.
>>>>
>>>> Thanks
>>>> Viv
>>>>
>>>>
>>>
>>> --
>>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-admin
>>>
>>
>
>
>

pgsql-admin by date:

Previous
From: Paul Anderson
Date:
Subject: Re: Restart failed with 'service postgresql restart'
Next
From: P
Date:
Subject: Quirks in Sorting Pg_description