Re: Unable to connect to a dabase

>> LOG:  database system was shut down at 2006-01-13 18:04:05 EST
>> LOG:  checkpoint record is at 505/C80F1010
>> LOG:  redo record is at 505/C80F1010; undo record is at 0/0;
>> shutdown TRUE
>> LOG:  next transaction ID: 1341794294; next OID: 1358710904
>> LOG:  database system is ready
>
> Well, that looks like a clean startup. I'm not sure if anyone else on the list has any ideas. Maybe getting a stack
traceof psql trying to connect would shed some light... 
>
> Does a backend get spawned when you try running psql? (Look at ps aux|grep postgres before and after running psql).

If you telnet to localhost 5432 is it listening or does it hang? If it
hangs I would guess a firewall but I would think you would pick up on
the unix socket.

J



>
>>> From: "Jim C. Nasby" <jnasby@pervasive.com>
>>> To: Sally Sally <dedeb17@hotmail.com>
>>> CC: pgsql-general@postgresql.org
>>> Subject: Re: [GENERAL] Unable to connect to a dabase
>>> Date: Fri, 13 Jan 2006 16:55:16 -0600
>>>
>>> Please don't hijack threads fo new questions.
>>>
>>> On Fri, Jan 13, 2006 at 10:45:51PM +0000, Sally Sally wrote:
>>>> I had to kill a vacuum in the middle with -9. I shut down
>> and restarted
>>> the
>>>> postgres server several times after that but I am unable
>> to connect to
>>> the
>>>> db that I was initially running vacuum on
>>>> I'm doing "psql dbname" and it hangs for a while. I'm
>> still waiting. Any
>>>> ideas?
>>> What's the logfile say about it?
> --
> Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
> Pervasive Software      http://pervasive.com    work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster


--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/