Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1AB9763393C for ; Tue, 2 Mar 2010 14:03:23 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 14482-06-2 for ; Tue, 2 Mar 2010 18:03:12 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f226.google.com (mail-ew0-f226.google.com [209.85.219.226]) by mail.postgresql.org (Postfix) with ESMTP id 5C23E63368B for ; Tue, 2 Mar 2010 14:03:12 -0400 (AST) Received: by ewy26 with SMTP id 26so378225ewy.3 for ; Tue, 02 Mar 2010 10:03:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:references :in-reply-to:subject:date:message-id:mime-version:content-type :content-transfer-encoding:x-mailer:thread-index:content-language; bh=n6QB84sb0eunAKXfKkYthZQHwHvhn1RyjVpTgB8qCZo=; b=GtdtkGoZTJrQX/I7sLiqCrj+rI6NtWpu6C5aWWZZQP1Ve/CmlHcBy9fexEvFEYofip vVhKirFQGkHg4nsC1etyqRxP2u2d579fgql2RP7Bmd011X1DWRMPUGf8Rk1HMeA8l74d dIbfd+l1jkDrEhaoLE5FNZGJ6eLuleF8MulL8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:references:in-reply-to:subject:date:message-id:mime-version :content-type:content-transfer-encoding:x-mailer:thread-index :content-language; b=llRcxjACaZ6ORmOLSy1TLC9Ha4uiXmXUFJFeC+/ss4lU1d7xROzGiUmWwhZG+iEcmQ 4rlaMGPye06xJnA1EqK5Tt3hU4jqpl2lZYd9wteXWrdtj6dnAD0ZuTtUWEac6e1KerZz sUz3HIYfaLvNP6PWNjJ2/DWuZfGc0dktzIfQs= Received: by 10.102.161.7 with SMTP id j7mr5119418mue.111.1267552988594; Tue, 02 Mar 2010 10:03:08 -0800 (PST) Received: from holzmobil (d86-32-54-40.cust.tele2.at [86.32.54.40]) by mx.google.com with ESMTPS id 25sm25366091mul.16.2010.03.02.10.03.02 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 02 Mar 2010 10:03:04 -0800 (PST) From: "Newsticker" To: References: <375c2da1003020843w6c46d204n6582926726b1fd50@mail.gmail.com> <4B8D42DA.7010801@pnlassociates.com> In-Reply-To: <4B8D42DA.7010801@pnlassociates.com> Subject: Re: Restart failed with 'service postgresql restart' Date: Tue, 2 Mar 2010 19:02:52 +0100 Message-ID: <024a01caba32$9b454620$d1cfd260$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 12.0 thread-index: Acq6MXTY0ABMrIduTx+MJ1uS+4SPEgAAM+ew Content-Language: de-at X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/16 X-Sequence-Number: 33815 Hi There is a nice entry at the Postgres archive. http://archives.postgresql.org/pgsql-general/2004-08/msg01624.php did you remove the /tmp/.s.PGSQL.5432.lock files??=20 Maybee it helps Greets ho -----Urspr=FCngliche Nachricht----- Von: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] Im Auftrag von Paul Anderson Gesendet: Dienstag, 02. M=E4rz 2010 17:55 An: pgsql-admin@postgresql.org Betreff: Re: [ADMIN] Restart failed with 'service postgresql restart' After verifying that the postmaster was not running you did remove the=20 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 > > =20 --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin