--=-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 <services.major [at] gmail.com>
To: Paul Anderson <paul.a [at] pnlassociates.com>
Cc: pgsql-admin [at] 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 [at] 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 [at] 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 [at] 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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.28.1">
</HEAD>
<BODY>
Let's see.<BR>
Could you provide us again pgstartup.log?<BR>
<BR>
First problem was you had a problem with postgresql.conf syntax.<BR>
Then, you had a problem with lock files, probably because a bad shutdown (perhaps a kill?)<BR>
<BR>
Anyway, how long have you worked with Unix environments? I think you are new to this world, don't you? ;-)<BR>
<BR>
In order to start postgres you have several ways to do it.<BR>
<BR>
- as root user: "service postgresql start" or "/etc/init.d/postgresql start"<BR>
- as postgres user "su - postgres", run "pg_ctl start -D /var/lib/pgsql"<BR>
<BR>
<BR>
-----Original Message-----<BR>
<B>From</B>: Major Services <<A HREF="mailto:Major%20Services%20%3cservices.major [at] gmail.com%3e">services.major [at] gmail.com</A>><BR>
<B>To</B>: Paul Anderson <<A HREF="mailto:Paul%20Anderson%20%3cpaul.a [at] pnlassociates.com%3e">paul.a [at] pnlassociates.com</A>><BR>
<B>Cc</B>: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A><BR>
<B>Subject</B>: Re: [ADMIN] Restart failed with 'service postgresql restart'<BR>
<B>Date</B>: Wed, 3 Mar 2010 12:51:09 +0530<BR>
<BR>
<PRE>
'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 <<A HREF="mailto:services.major [at] gmail.com">services.major [at] gmail.com</A>> 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 <<A HREF="mailto:paul.a [at] pnlassociates.com">paul.a [at] pnlassociates.com</A>> 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 (<A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A>)
>> To make changes to your subscription:
>> <A HREF="http://www.postgresql.org/mailpref/pgsql-admin">http://www.postgresql.org/mailpref/pgsql-admin</A>
>>
>
</PRE>
<BR>
</BODY>
</HTML>
--=-M5Q1hdtxV9x5y8HZmCth--
