![]() Is it some setting in /path/pgsql/data? (I cannot access this at the moment, but I can ask.) Does this mean that PostgreSQL is not listening to any port? How can I make it listen? Within PostgreSQL I typed SHOW port, but it returned nothing. ![]() Not shown: 4868 closed ports, 130 filtered portsĬould port 5025 be PostgreSQL? Other tries $ ps aux | grep postgres | grep -v 'postgres:' When I make the port range higher, I get different results: $ nmap -p 1000-6000 -sT servera.my.url.de Nmap scan report for servera.my.url.de (141.X.YZ.AB) Portscan $ nmap -p 5000-6000 -sT servera.my.url.de Is the server running on host "servera.my.url.de" (141.X.YZ.AB) and acceptingĪnd psql -h servera.my.url.de -p 5932 -U myusername -W -c "select 1" Psql: could not connect to server: Connection refused Is my Python script the problem? psql -h servera.my.url.de -p 5930 -c "select 1" servera.my.url.de ping statistics -ģ packets transmitted, 3 received, 0% packet loss, time 2001ms Is the server there? ping servera.my.url.de Is the server running on host "servera.my.url.de" (141.X.YZ.AB) andĪccepting TCP/IP connections on port 5432? I've tried adding host=servera.my.url.de but that gave me could not connect to server: Connection refused So my Python script needs to access the PostgreSQL-database from server B connecting to server A. The PostgreSQL database will remain at server A. It currently works fine, but I have to move the script to another server B. I currently have a Python script that needs to fetch some data from a PostgreSQL database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |