could not create Unix-domain socket in directory "/var/run/postgresql"

Question

I try to uncomment 'unix_socket_directories = '/var/run/postgresql' in postgresql.conf.

But after doing that, when I try to restart postgresql, I receive

  Job for postgresql.service failed because the control process exited with error code. See 
  "systemctl status postgresql.service" and "journalctl -xe" for details.

Looking for journalctl, I see:

LOG:  could not bind Unix socket: Address already in use
HINT:  Is another postmaster already running on port 5432? If not, remove socket file 
"/var/run/postgresql/.s.PGSQL...and retry.
: WARNING:  could not create Unix-domain socket in directory "/var/run/postgresql"

Full stack:

 Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; 
 vendor preset: disabled)
  Active: failed (Result: exit-code) since Ср 2020-01-29 13:39:52 MSK; 
 27s ago
  Process: 2937 ExecStop=/usr/bin/pg_ctl stop -D ${PGDATA} -s -m fast 
 (code=exited, status=1/FAILURE)
  Process: 2550 ExecStart=/usr/bin/pg_ctl start -D ${PGDATA} -s -o -p 
 ${PGPORT} -w -t 300 (code=exited, status=0/SUCCESS)
  Process: 2544 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} 
 (code=exited, status=0/SUCCESS)
 Main PID: 2554 (code=killed, signal=KILL)

   plesk.iline.pro systemd[1]: Starting PostgreSQL database server...
   plesk.iline.pro pg_ctl[2550]: LOG:  could not bind Unix socket: 
   Address already in use
   plesk.iline.pro pg_ctl[2550]: HINT:  Is another postmaster already 
   running on port 5432? If not, remove socket file 
   "/var/run/postgresql/.s.PGSQL...and retry.
    plesk.iline.pro pg_ctl[2550]: WARNING:  could not create Unix- 
    domain socket in directory "/var/run/postgresql"
    plesk.iline.pro systemd[1]: Started PostgreSQL database server.
    2 plesk.iline.pro systemd[1]: postgresql.service: main process 
    exited, code=killed, status=9/KILL
    plesk.iline.pro pg_ctl[2937]: pg_ctl: could not send stop signal 
    (PID: 2554): No such process
    plesk.iline.pro systemd[1]: postgresql.service: control process 
    exited, code=exited status=1
    plesk.iline.pro systemd[1]: Unit postgresql.service entered failed 
    state.
    plesk.iline.pro systemd[1]: postgresql.service failed.
    Hint: Some lines were ellipsized, use -l to show in full.

Which PostgreSQL version is that?

Laurenz Albe
– Laurenz Albe

2020-01-29 11:27:44 +00:00
Commented Jan 29, 2020 at 11:27 — Laurenz Albe
– Laurenz Albe, Commented Jan 29, 2020 at 11:27
version PostgreSQL is 9.2

Jelly
– Jelly

2020-01-29 11:37:45 +00:00
Commented Jan 29, 2020 at 11:37 — Jelly
– Jelly, Commented Jan 29, 2020 at 11:37

Laurenz Albe · Accepted Answer · 2020-01-29 11:49:41Z

2

Likely there is another PostgreSQL server running on the same port.

You should do what PostgreSQL recommends:

ls -l /var/run/postgresql/.s.PGSQL.5432

There should be a socket file present.

Then, as user root, see if there is a PostgreSQL process listening on the port:

sudo fuser /var/run/postgresql/.s.PGSQL.5432

If there is a result, there is really another PostgreSQL server running on port 5432. Either stop that server or choose a different port for your cluster.

If there is no result, the socket may be left over. Remove it and try again.

answered Jan 29, 2020 at 11:49

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Jelly Over a year ago

I have no result after running this commands. And how can I remove socket. I have tried 'rm .s.PGSQL.5432', but receive 'failed to remove .s.PGSQL.5432 as its a directory

Laurenz Albe Over a year ago

What does "no result" mean? An error "no such file or directory"? Something else? Details, please.

Jelly Over a year ago

After ls -l /var/run/postgresql/.s.PGSQL.5432 next line retrieve 0.

Laurenz Albe Over a year ago

"retrieve 0" doesn't make much sense to me. Kill all PostgreSQL processes on the machine, remove /var/run/postgresql/.s.PGSQL.5432 and try again.

Laurenz Albe Over a year ago

There is a command called rm for that: sudo rm -f /var/run/postgresql/.s.PGSQL.5432

|

Collectives™ on Stack Overflow

could not create Unix-domain socket in directory "/var/run/postgresql"

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related