From: Iñigo Martinez Lasala <imartinez@vectorsf.com>
To: Major Services <services.major@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Restart failed with 'service postgresql restart'
Date: Wed, 03 Mar 2010 13:04:33 +0100
Message-ID: <1267617873.17535.145.camel@deimos> (raw)
In-Reply-To: <375c2da1003022321n32d9bc09vac2466ff63f8b428@mail.gmail.com>
References: <375c2da1003020843w6c46d204n6582926726b1fd50@mail.gmail.com>
<4B8D42DA.7010801@pnlassociates.com>
<375c2da1003022028t7a6949f6pa881ff03ce0bb585@mail.gmail.com>
<375c2da1003022321n32d9bc09vac2466ff63f8b428@mail.gmail.com>
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: imartinez@vectorsf.com, services.major@gmail.com
Subject: Re: Restart failed with 'service postgresql restart'
In-Reply-To: <1267617873.17535.145.camel@deimos>
* 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