database export / import issue from synology to raspberry pi

[duduf]

I made a new install for VWsFriend on a raspberry pi with docker compose. everything is working but I have an issue. I'll try to export the database from the postgres on my synology NAS to the postgres on my raspberry pi. It doens't work. I've got the error : psql: error: connection to server at "192.168.10.233", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? I know that this issue is on my raspberry pi but may be you can help me out. New vwsfriend on the raspberry work fine. I made today a trip with my car and I can see it in the database. If I do a netstat to see if docker postgres is listening on port 5432 then I'll see nothing for 5432.

Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 127.0.0.1:39369 0.0.0.0:* LISTEN 800/containerd tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 834/sshd: /usr/sbin tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN 784/cupsd tcp 0 0 0.0.0.0:4000 0.0.0.0:* LISTEN 1880/docker-proxy tcp 0 0 0.0.0.0:3000 0.0.0.0:* LISTEN 1945/docker-proxy

Any idea?

[thgau]

Where do you run the psql and where the database? If the database is in a container then it is not reachable from outside. you might want to run the psql within the container e.g. via docker compose exec postgresql psql

[duduf]

Thanks for you reply. I'll give the try. I was trying from docker on my synology to my raspberry pi docker (compose)