From: | Wayne Pierce <shalofin(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: [despammed] Connection problems with "psql -h localhost <dbName> postgres" |
Date: | 2005-05-02 14:03:33 |
Message-ID: | 4617fd6d050502070317855c0b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 5/2/05, Andreas Kretschmer <akretschmer(at)despammed(dot)com> wrote:
> am 02.05.2005, um 9:03:50 -0400 mailte Wayne Pierce folgendes:
> > I have PostgreSQL setup and everything is working fine when I use
> > "psql -d <dbName>" on the command line or when I use mod_python to
> > connect. However I when I use "psql -h localhost <dbName> postgres" I
> > get the following error:
> >
> > psql: could not connect to server: Connection refused
> > Is the server running on host "localhost" and accepting
> > TCP/IP connections on port 5432?
> >
> > I have the following lines in my pg_ident.conf and pg_hba.conf files:
>
> PG does not listen on TCP.
>
> Set in /etc/postgresql/postgresql.conf
>
> tcpip_socket = true
I did have that setting. After restarting the server I typed "ps
-deaf | grep postgres" and the -i option was not showing up for the
postmaster startup command. I couldn't figure out why so I added '-i'
to the line in /etc/init.d/postgresql and that part now works.
Thank you for the response,
Wayne
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-05-02 15:17:24 | Re: Connection problems with "psql -h localhost <dbName> postgres" |
Previous Message | Bruno Wolff III | 2005-05-02 13:59:02 | Re: how to make collation work |