Re: Cannot Start Postgres After System Boot

From: "Reid Thompson" <Reid(dot)Thompson(at)ateb(dot)com>
To: <rshepard(at)appl-ecosys(dot)com>
Cc: "Reid Thompson" <Reid(dot)Thompson(at)ateb(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cannot Start Postgres After System Boot
Date: 2010-10-21 18:09:03
Message-ID: 7C0800F63CCF4149AC0FC5EE2A041226D5231E@sr002-2k3exc.ateb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2010-10-21 at 10:35 -0700, Rich Shepard wrote:
> On Thu, 21 Oct 2010, Scott Marlowe wrote:
>
> > So, what do
> >
> > telnet localhost 5432
>
> Scott,
>
> That port's clear:
>
> [rshepard(at)salmo ~]$ telnet localhost 5432
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
>
> > AND
> > psql -h localhost -l
>
> Huh!
>
> [rshepard(at)salmo ~]$ psql -h localhost -l
> List of databases
> Name | Owner | Encoding
> -----------+------------+----------
> aesi | sql-ledger | LATIN1
> cms | rshepard | UTF8
> postgres | postgres | UTF8
> refdb | postgres | UTF8
> scirefs | rshepard | LATIN1
> template0 | postgres | UTF8
> template1 | postgres | UTF8
> (7 rows)
>
> So, why can't I connect to a database by entering, for example, 'psql
> aesi'?
>
> Thanks,
>
> Rich

what does
$ netstat -an |grep 5432
return?

something is running on tcp port 5432

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DM 2010-10-21 18:09:54 Re: Question on Explain : Index Scan
Previous Message DM 2010-10-21 18:07:57 Re: Composite Index question