PGSQL no IP-port assigned

From: Pablo Capeluto <capeluto(at)montevideo(dot)com(dot)uy>
To: pgsql-bugs(at)postgresql(dot)org
Subject: PGSQL no IP-port assigned
Date: 2003-02-13 10:06:11
Message-ID: 1045130790.7893.79.camel@abalon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Your name : Pablo Capeluto
Your email address : capeluto(at)montevideo(dot)com(dot)uy

System Configuration
---------------------
Architecture (example: Intel Pentium) :
AMD K6-2 400Mhz,
396Mb-RAM
800Mb Free Hdd (4.2Gb Total)

Operating System (example: Linux 2.0.26 ELF) :
SuSE Linux 8.0
Kernel 2.4.18-4GB

PostgreSQL version (example: PostgreSQL-7.1.1): Postgresql-7.2-70

Compiler used (example: gcc 2.95.2) : gcc-2.95.3-216

Please enter a FULL description of your problem:
------------------------------------------------
Mi comando para correr PostgreSQL es rcpostgresql start, funciona bien,
postgresql status me dice "runing" pero las aplicaciones que uso para
hacer consultas me dicen que no se puede conectar al servidor.
Un scaning con nmap me da el resultado debajo descripto, el supuesto
puerto 5432 no se encuentra abierto.

Por otra parte el comando rcpostgresql probe me dice:

abalon:~ # rcpostgresql probe missing
abalon:~ #

Acá figura todo bien...
abalon:~ # rcpostgresql status
Checking for PostgreSQL: running

Pero sigo sin acceder al servidor Postgresql

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

Este es el resultado de Nmap.

pablo(at)abalon:~> nmap localhost -p 1-65530

Starting nmap V. 2.54BETA30 ( www.insecure.org/nmap/ )
Interesting ports on localhost (127.0.0.1):
(The 65520 ports scanned but not shown below are in state: closed)
Port State Service
21/tcp open ftp
22/tcp open ssh
110/tcp open pop-3
111/tcp open sunrpc
901/tcp open samba-swat
3306/tcp open mysql
6000/tcp open X11
10000/tcp open snet-sensor-mgmt
32768/tcp open unknown
32769/tcp open unknown

Nmap run completed -- 1 IP address (1 host up) scanned in 19 seconds
pablo(at)abalon:~>

Este es el contenido del /var/log/postgresql

abalon:/var/log # cat postgresql
DEBUG: database system was shut down at 2003-02-13 06:58:54 ART
DEBUG: checkpoint record is at 0/11BC14
DEBUG: redo record is at 0/11BC14; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 262; next oid: 16557
DEBUG: database system is ready

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

--
-----------------------------------------------------
E-mail: capeluto(at)montevideo(dot)com(dot)uy
pcapeluto(at)hipatia(dot)info
ICQ: 124076168
Web: http://www.hipatia.info/~pcapeluto/
Montevideo - Uruguay

Powered by SuSE Linux
This message was sent by Ximian Evolution 1.08
-----------------------------------------------------

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Greger Burman 2003-02-13 14:09:01 postmaster missing
Previous Message Tom Lane 2003-02-13 05:27:54 Re: Constraints not check indexes existence on creation.