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
-----------------------------------------------------
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. |