Re: Restart failed with 'service postgresql restart'

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(at)vectorsf(dot)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(dot)major(at)gmail(dot)com>
> To: Paul Anderson <paul(dot)a(at)pnlassociates(dot)com>
> Cc: pgsql-admin(at)postgresql(dot)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(dot)major(at)gmail(dot)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(dot)a(at)pnlassociates(dot)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(at)postgresql(dot)org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-admin
>>>
>>
>
>
>