Обсуждение: Error after typing "psql"

Поиск
Список
Период
Сортировка

Error after typing "psql"

От
Maya
Дата:
Hi!!
I just installed PostgreSQL in a MSW98 using cygwin. When I type 'psql' I get a message saying
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432
What can I do to solve this problem?
-- 
* The media's the most powerful entity on earth. They have the  power to make the innocent guilty and to make the guilty  innocent, and that's power.                                - Malcom X

* You cannot exercise your power to a point of humiliation.                              - Jean Chretien

* It's amazing how the small seeds of distrust and misunderstanding can yield a crop of hate and death...

From WE to YOU, with love:
* E-Mail Policy    http://www.vif.com/users/escalante/Email_Policy.html

Re: Error after typing "psql"

От
Bruce Momjian
Дата:
Maya wrote:
> Hi!!
> I just installed PostgreSQL in a MSW98 using cygwin. When I type 'psql'
> I get a message saying
> psql: could not connect to server: No such file or directory
>         Is the server running locally and accepting connections on Unix
> domain socket "/tmp/.s.PGSQL.5432
> What can I do to solve this problem?
>

You have to start the postmaster with -i, or enable tcp sockets in
postgresql.conf, then use -h localhost in psql.  This will be fixed in
7.5.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073