PGSQL no IP-port assigned

Поиск
Список
Период
Сортировка
От Pablo Capeluto
Тема PGSQL no IP-port assigned
Дата
Msg-id 1045130790.7893.79.camel@abalon
обсуждение исходный текст
Ответы Re: PGSQL no IP-port assigned  (Lamar Owen <lamar.owen@wgcr.org>)
Список pgsql-bugs
Your name               : Pablo Capeluto
Your email address      : capeluto@montevideo.com.uy


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

  Operating System (example: Linux 2.0.26 ELF)  :=20
    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:~ #=20

Ac=E1 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@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=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20
22/tcp     open        ssh=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20
110/tcp    open        pop-3=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20
111/tcp    open        sunrpc=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20
901/tcp    open        samba-swat=20=20=20=20=20=20=20=20=20=20=20=20=20=20
3306/tcp   open        mysql=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20
6000/tcp   open        X11=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20
10000/tcp  open        snet-sensor-mgmt=20=20=20=20=20=20=20=20
32768/tcp  open        unknown=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20
32769/tcp  open        unknown=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20


Nmap run completed -- 1 IP address (1 host up) scanned in 19 seconds
pablo@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:
---------------------------------------------------------------------

--=20
-----------------------------------------------------
E-mail:    capeluto@montevideo.com.uy
    pcapeluto@hipatia.info
ICQ:    124076168
Web:    http://www.hipatia.info/~pcapeluto/
Montevideo - Uruguay

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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug #896: Column Constraint Not Working in ALTER TABLE ADD COLUMN?
Следующее
От: Florian Wunderlich
Дата:
Сообщение: Re: Bug #866 related problem (ATTN Tom Lane)