DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=DmmfC2Yc4sxoIwcyAuMDQHo1kNn/TVEviF2mBeXDXrh+3F6dv0tzCnjFgUYGNTMXZD
	lB7UrfbBQ+T2qcMjZifUcCfXdzdCbgyCsIPNWHXBr4AO3FOHl7CWuqiu/KT0p3WSirfN
	b1QtnMSWto49xvT4KMX276zMaJe4Y3kIe5qKk=
MIME-Version: 1.0
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>
Date: Wed, 3 Mar 2010 18:02:15 +0530
Message-ID: <375c2da1003030432t1b60a71ay3fac059c4caf094d@mail.gmail.com>
Subject: Re: Restart failed with 'service postgresql restart'
From: Major Services <services.major@gmail.com>
To: =?ISO-8859-1?Q?I=F1igo_Martinez_Lasala?= <imartinez@vectorsf.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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=F1igo 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 sta=
rt"
> - 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 =A0*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
>>>
>>
>
>
>