Excuse me for my mediocre knowledge in Ubuntu and Postgresql.
I have a VPS with Ubuntu 14.04.5 LTS (GNU/Linux 2.6.32-042stab127.2 x86_64) and also have Postgresql installed. I'm using Postgresql in a ruby on rails application. As soon as I rebooted the ubuntu with
$sudo reboot
Suddenly my application and Postgresql Database stopped running throwing the error
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"?
$ sudo -i -u postgres
$ 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"?
$psql -V
psql (PostgreSQL) 11.0 (Ubuntu 11.0-1.pgdg14.04+2)
$pg_config --version
PostgreSQL 11.0 (Ubuntu 11.0-1.pgdg14.04+2)
$postgres -V
The program 'postgres' is currently not installed. You can install it by typing:
apt-get install postgres-xc
$locate bin/postgres
/usr/lib/postgresql/11/bin/postgres
/usr/lib/postgresql/9.3/bin/postgres
/usr/lib/postgresql/9.4/bin/postgres
/usr/lib/postgresql/9.5/bin/postgres
$/usr/lib/postgresql/11/bin/postgres -V
postgres (PostgreSQL) 11.0 (Ubuntu 11.0-1.pgdg14.04+2)
$pg_lsclusters
9.3 main 5432 down postgres /var/lib/postgresql/9.3/main /var/log/postgresql/postgresql-9.3-main.log
11 main 5433 down postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log
The postgres status is down
$service postgresql status
9.3/main (port 5432): down
11/main (port 5433): down
$systemctl status postgresql.service
postgresql.service
Loaded: error (Reason: No such file or directory)
Active: inactive (dead)
$systemctl status postgresql@9.3-main.service
postgresql@9.3-main.service
Loaded: error (Reason: No such file or directory)
Active: inactive (dead)
$grep -H '^port' /etc/postgresql/*/main/postgresql.conf
/etc/postgresql/11/main/postgresql.conf:port = 5433
/etc/postgresql/9.3/main/postgresql.conf:port = 5432
I am trying to start Postgresql 9.3 with
$service postgresql start 9.3
* Starting PostgreSQL 9.3 database server
* Failed to issue method call: Unit postgresql@9.3-main.service failed
to load: No such file or directory. See system logs and 'systemctl
status postgresql@9.3-main.service' for details.
$sudo systemctl start postgresql
Failed to issue method call: Unit postgresql.service failed to load: No
such file or directory. See system logs and 'systemctl status
postgresql.service' for details.
$/etc/init.d/postgresql start
* Starting PostgreSQL 11 database server
* Failed to issue method call: Unit postgresql@11-main.service failed to
load: No such file or directory. See system logs and 'systemctl status
postgresql@11-main.service' for details.
[fail]
* Starting PostgreSQL 9.3 database server
* Failed to issue method call: Unit postgresql@9.3-main.service failed to
load: No such file or directory. See system logs and 'systemctl status
postgresql@9.3-main.service' for details.
[fail]
I'm unable to start PostgreSQL.I don't understand why it went down suddenly, it was working fine till yesterday.Any help is highly Appreciated. Thanks in Advance!
Best Answer
Look like your postgresql 11 is running on PORT=5433 so you need to change the PGPORT env variable.
export PGPORT=5433
or
add PGPORT=5433 to /etc/environment
sudo vim /etc/environment
PGPORT=5433