Skip to content

wont start - fails to find socket of source postgres #65

@ITJamie

Description

@ITJamie
docker run --rm \
    -v /srv/appname/data/postgres:/var/lib/postgresql/10 \
    -v /srv/appname/data/postgres12:/var/lib/postgresql/12 \
    tianon/postgres-upgrade:10-to-12 

Performing Consistency Checks
-----------------------------
Checking cluster versions                                   ok

*failure*
Consult the last few lines of "pg_upgrade_server.log" for
the probable cause of the failure.

connection to database failed: connection to server on socket "/var/lib/postgresql/.s.PGSQL.50432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?

could not connect to source postmaster started with the command:
"/usr/lib/postgresql/10/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/postgresql/10/data" -o "-p 50432 -b  -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/var/lib/postgresql'" start
Failure, exiting

Any ideas of next troubleshooting step?
Ive confirmed all the files in /srv/appname/data/postgres are owned by uid 1001. ive tried the 10-14 image and it was the same error
Ive also tried adding "data" to the volume mounts but the same issue occurs, if i put in an incorrect path it warns that it cant find the PG_VERSION file, so its definitely seeing the data:

docker run --rm \
    -v /srv/appname/data/postgres/data:/var/lib/postgresql/10/data \
    -v /srv/appname/data/postgres12/data:/var/lib/postgresql/12/data \
    tianon/postgres-upgrade:10-to-12 

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions