← Back to team overview

sslug-teknik team mailing list archive

Postgresql server: pgaccces fejler, port 5432 mangler

 

Pgaccess kan ikke connecte fordi port 5432 mangler.
Postmaster er startet med option -p 5432.
Output fra ps:
postgres  2062  0.0  0.3  7156 1852 ?        S    19:18   0:00
      /usr/bin/postmaster -p 5432
Men nmap siger:
     Interesting ports on localhost (127.0.0.1):
(The 1596 ports scanned but not shown below are in state: closed)
Port       State       Service
80/tcp     open        http
111/tcp    open        sunrpc
443/tcp    open        https
3306/tcp   open        mysql
6000/tcp   open        X11

altså ingen port 5432.

Fejl udskrift fra pgaccess på stdout:

Error trying to connect to database 'katalog' on host localhost

PostgreSQL error message:Connection to database failed
could not connect to server: Connection refused
        Is the server running on host localhost and accepting
        TCP/IP connections on port 5432?
"

Der er ingen problemer med kommandoen 'psql katalog'.

Hvordan får jeg åbnet port 5432?

--
Med venlig hilsen

Jørgen Heesche
mailto:heesche@xxxxxxxxxxx



Follow ups