Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres listening on Port 5433 #37

Open
michimussato opened this issue Feb 27, 2025 · 0 comments
Open

Postgres listening on Port 5433 #37

michimussato opened this issue Feb 27, 2025 · 0 comments

Comments

@michimussato
Copy link

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant