Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 1F0FE6333B2 for ; Wed, 3 Mar 2010 08:04:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 87144-05 for ; Wed, 3 Mar 2010 12:04:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62]) by mail.postgresql.org (Postfix) with ESMTP id 2ABEE63259B for ; Wed, 3 Mar 2010 08:04:42 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by hermes.vectorsf.com (Postfix) with ESMTP id 8542511C023E; Wed, 3 Mar 2010 13:04:37 +0100 (CET) X-Virus-Scanned: amavisd-new at hermes.vectorsf.com Received: from hermes.vectorsf.com ([127.0.0.1]) by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id BGxaEuW3jhMm; Wed, 3 Mar 2010 13:04:32 +0100 (CET) Received: from [10.70.4.200] (unknown [10.70.4.200]) (Authenticated sender: imartinez) by hermes.vectorsf.com (Postfix) with ESMTP id B262E11C0012; Wed, 3 Mar 2010 13:04:32 +0100 (CET) Subject: Re: Restart failed with 'service postgresql restart' From: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala To: Major Services Cc: pgsql-admin In-Reply-To: <375c2da1003022321n32d9bc09vac2466ff63f8b428@mail.gmail.com> References: <375c2da1003020843w6c46d204n6582926726b1fd50@mail.gmail.com> <4B8D42DA.7010801@pnlassociates.com> <375c2da1003022028t7a6949f6pa881ff03ce0bb585@mail.gmail.com> <375c2da1003022321n32d9bc09vac2466ff63f8b428@mail.gmail.com> Content-Type: multipart/alternative; boundary="=-M5Q1hdtxV9x5y8HZmCth" Date: Wed, 03 Mar 2010 13:04:33 +0100 Message-ID: <1267617873.17535.145.camel@deimos> Mime-Version: 1.0 X-Mailer: Evolution 2.28.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.058 tagged_above=-10 required=5 tests=AWL=0.540, BAYES_00=-2.599, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/23 X-Sequence-Number: 33822 --=-M5Q1hdtxV9x5y8HZmCth Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit 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 To: Paul Anderson 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 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 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 >> > --=-M5Q1hdtxV9x5y8HZmCth Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 7bit 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
>>
>

--=-M5Q1hdtxV9x5y8HZmCth--