Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1emlFZ-0005wN-Qj for pgsql-admin@arkaria.postgresql.org; Fri, 16 Feb 2018 19:00:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1emlFY-0002R6-Vv for pgsql-admin@arkaria.postgresql.org; Fri, 16 Feb 2018 19:00:48 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1emlFY-0002Qw-LI for pgsql-admin@lists.postgresql.org; Fri, 16 Feb 2018 19:00:48 +0000 Received: from mx1.mailbox.org ([80.241.60.212]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1emlFV-00008z-CE for pgsql-admin@postgresql.org; Fri, 16 Feb 2018 19:00:47 +0000 Received: from smtp1.mailbox.org (smtp1.mailbox.org [80.241.60.240]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mx1.mailbox.org (Postfix) with ESMTPS id 49B2B42AEE; Fri, 16 Feb 2018 20:00:41 +0100 (CET) X-Virus-Scanned: amavisd-new at heinlein-support.de Received: from smtp1.mailbox.org ([80.241.60.240]) by gerste.heinlein-support.de (gerste.heinlein-support.de [91.198.250.173]) (amavisd-new, port 10030) with ESMTP id 7UlZ5AfAnB6T; Fri, 16 Feb 2018 20:00:32 +0100 (CET) Message-ID: <1518807631.2490.3.camel@cybertec.at> Subject: Re: postgres not starting From: Laurenz Albe To: Azimuddin Mohammed Cc: Alan Hodgson , pgsql-admin@postgresql.org Date: Fri, 16 Feb 2018 20:00:31 +0100 In-Reply-To: References: <1518742460.11219.15.camel@lists.simkin.ca> <1518756706.2909.4.camel@cybertec.at> <1518757204.2909.7.camel@cybertec.at> Organization: Cybertec Content-Type: text/plain; charset="UTF-8" Mime-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Azimuddin Mohammed wrote: > > > > > I am unable to start postgres on one of the server > > > > > I am getting below error "HINT: is another postmaster already running on port 5432, if not wait a few seconds and retry" > > > > > I checked the processes nothing is running with postgres > > > > To find the process that is blocking the port, you can run the following: > > > > lsof -i TCP:5432 > > I do not see anything running Then the problem is something else. Try to start PostgreSQL directly as OS user "postgres" with postgres (This requires that the environment variable PGDATA is set to the data directory.) Then post all the messages you see. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com