Re: Post-Reboot Issue: Postmaster Not Accessible

On Wed, 28 Feb 2007, Joshua D. Drake wrote:

> psql -h localhost -U postgres databasename

Joshua,

Well, something's wrong:

[rshepard(at)salmo ~]$ psql -h localhost -U postgres aesi
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

aesi=# \q
[rshepard(at)salmo ~]$ psql aesi
psql: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

I used to be able to connect to an existing database just by typing it's
name after the command.

Rich

--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc. | Accelerator(TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863