From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Error when starting postgres database!!
Date: Tue, 9 Oct 2018 17:33:41 +1300
Message-ID: <3787fa24-6a81-e227-9922-86558280590d@catalyst.net.nz> (raw)
In-Reply-To: <1539058967018-0.post@n3.nabble.com>
References: <1539058967018-0.post@n3.nabble.com>
On 09/10/18 17:22, pavan95 wrote:
> 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"?
The default client config expects the server's socket in
/var/run/postgresql. Yours is not there. Try this:
$ psql -h localhost
>
> 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!
>
>
>
Looks like a non standard setup (data directory
/home/new_data/9.1/data). What is unix_socket_directories set to in your
postgresql.conf? (If not set then it is probably using /tmp)
regards
Mark
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: mark.kirkwood@catalyst.net.nz, pgsql-admin@lists.postgresql.org
Subject: Re: Error when starting postgres database!!
In-Reply-To: <3787fa24-6a81-e227-9922-86558280590d@catalyst.net.nz>
* 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