On Wed, 28 Feb 2007, Joshua D. Drake wrote:
psql -h localhost -U postgres databasename
Joshua,
Well, something's wrong:
[EMAIL PROTECTED] ~]$ 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
[EMAIL PROTECTED] ~]$ 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
