From: Major Services <services.major@gmail.com>
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Restart failed with 'service postgresql restart'
Date: Wed, 3 Mar 2010 18:02:15 +0530
Message-ID: <375c2da1003030432t1b60a71ay3fac059c4caf094d@mail.gmail.com> (raw)
In-Reply-To: <1267617873.17535.145.camel@deimos>
References: <375c2da1003020843w6c46d204n6582926726b1fd50@mail.gmail.com>
<4B8D42DA.7010801@pnlassociates.com>
<375c2da1003022028t7a6949f6pa881ff03ce0bb585@mail.gmail.com>
<375c2da1003022321n32d9bc09vac2466ff63f8b428@mail.gmail.com>
<1267617873.17535.145.camel@deimos>
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
>>>
>>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: services.major@gmail.com, imartinez@vectorsf.com
Subject: Re: Restart failed with 'service postgresql restart'
In-Reply-To: <375c2da1003030432t1b60a71ay3fac059c4caf094d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox