Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g9jXr-00089y-69 for pgsql-admin@arkaria.postgresql.org; Tue, 09 Oct 2018 04:22:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g9jXn-0000aY-Gu for pgsql-admin@arkaria.postgresql.org; Tue, 09 Oct 2018 04:22:51 +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.89) (envelope-from ) id 1g9jXn-0000aR-5q for pgsql-admin@lists.postgresql.org; Tue, 09 Oct 2018 04:22:51 +0000 Received: from n3.nabble.com ([162.255.23.22]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g9jXk-0001t8-9Z for pgsql-admin@postgresql.org; Tue, 09 Oct 2018 04:22:49 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id 1335DF9D67FA for ; Mon, 8 Oct 2018 21:22:47 -0700 (MST) Date: Mon, 8 Oct 2018 21:22:47 -0700 (MST) From: pavan95 To: pgsql-admin@postgresql.org Message-ID: <1539058967018-0.post@n3.nabble.com> Subject: Re: Error when starting postgres database!! MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, I'm facing an error in starting my postgresql database. The error is as shown below: bash-4.1$ psql psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? But surprisingly the port was open at 5432, I got it confirmed as below: top -u postgres PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 6180 postgres 20 0 164m 2296 1824 S 0.9 0.0 0:00.36 /usr/pgsql-9.1/bin/pg_statsinfod 6171 6861 postgres 20 0 17176 1324 952 R 0.9 0.0 0:00.01 top -u postgres 6171 postgres 20 0 234m 20m 19m S 0.0 0.3 0:00.47 /usr/pgsql-9.1/bin/postmaster -p 5432 -D /home/new_data/9.1/data 6173 postgres 20 0 179m 1444 636 S 0.0 0.0 0:00.24 postgres: pg_statsinfo launcher process 6174 postgres 20 0 181m 1368 520 S 0.0 0.0 0:00.03 postgres: logger process 6176 postgres 20 0 234m 1792 920 S 0.0 0.0 0:00.17 postgres: writer process 6177 postgres 20 0 234m 1520 648 S 0.0 0.0 0:00.14 postgres: wal writer process 6178 postgres 20 0 235m 3300 1344 S 0.0 0.0 0:00.14 postgres: autovacuum launcher process 6179 postgres 20 0 184m 1936 604 S 0.0 0.0 0:00.26 postgres: stats collector process 6826 postgres 20 0 107m 1740 1304 S 0.0 0.0 0:00.00 bash Is there any issue with my configuration?? Kindly suggest! Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html