Postgres listening on Port 5433

[michimussato]

Hello!

It seems that zou expects Postgres to listen on port 5432. However, Postgres listens on port 5433. The following configuration worked just recently:

root@5a55e842b3ce:/opt/zou# ./init_zou.sh
[...]
sqlalchemy.exc.OperationalError: (psycopg.OperationalError) connection is bad: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
        Is the server running locally and accepting connections on that socket?
[...]

root@5a55e842b3ce:/opt/zou# ll /var/run/postgresql/
total 28
drwxrwsr-x 1 postgres postgres 4096 Feb 27 00:18 ./
drwxr-xr-x 1 root     root     4096 Feb 26 16:05 ../
srwxrwxrwx 1 postgres postgres    0 Feb 27 00:18 .s.PGSQL.5433=
-rw------- 1 postgres postgres   68 Feb 27 00:18 .s.PGSQL.5433.lock
drwxr-s--- 1 postgres postgres 4096 Feb 27 00:18 14-main.pg_stat_tmp/
-rw-r--r-- 1 postgres postgres    4 Feb 27 00:18 14-main.pid

root@5a55e842b3ce:/opt/zou# cat /etc/postgresql/14/main/postgresql.conf
[...]
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------

# - Connection Settings -

#listen_addresses = 'localhost'         # what IP address(es) to listen on;
                                        # comma-separated list of addresses;
                                        # defaults to 'localhost'; use '*' for all
                                        # (change requires restart)
port = 5433                             # (change requires restart)
max_connections = 100                   # (change requires restart)
#superuser_reserved_connections = 3     # (change requires restart)
unix_socket_directories = '/var/run/postgresql' # comma-separated list of directories
                                        # (change requires restart)
#unix_socket_group = ''                 # (change requires restart)
[...]

Is this expected?

[nledez]

Hi @michimussato , Can you explain how you got that?

When I check, everything seems correct with the official image:

docker pull cgwire/cgwire
docker container run -d --name cgwire cgwire/cgwire
docker container exec -it cgwire bash
grep '^port' /etc/postgresql/14/main/postgresql.conf

I have:

port = 5432				# (change requires restart)

Another question: why run init_zou.sh? It's already done in our image.

Did you follow the procedure described in the ‘Usage’ section on the page https://github.com/cgwire/kitsu-docker?

Thank you for your reply.