Re: Problems using PostgreSQL command line tools - Mailing list pgsql-novice

From Andrea
Subject Re: Problems using PostgreSQL command line tools
Date
Msg-id 4422CECE.3010409@email.it
Whole thread Raw
In response to Re: Problems using PostgreSQL command line tools  ("Guido Barosio" <gbarosio@gmail.com>)
List pgsql-novice
Hi, thank you for the answer. However it's not very useful to me:

C:\>psql -h 127.0.0.1 -U postgres -d postgres
psql: FATAL:  password authentication failed for user "postgres"

My main question is: given the command line

   psql -h localhost -U postgres -d postgres

why at home is ok (and works without problems) and at office doesn't
work at all???

pg_hba.conf contains:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
# IPv6 local connections:
#host    all         all         ::1/128               md5

on both computers.

Regards.
Andrea

> Hi Andrea,
>
>    You should try to connect to 127.0.0.1 (or your hostname)  instead
> of localhost.
>
> why?
>
> - localhost means that you will connect using a socket (psql -h localhost)
> - ip/hostname will use tcp/ip (psql -h 127.0.0.1)
>
> Both have separate auth lines in your pg_hba.conf, therefore, you are
> prolly facing a problem with the localhost line, where pgadmin is
> connecting using the tcp/ip connection for sure.
>
> Check that, but I am almost sure.
>
> Regards,
> Guido Barosio
>
> On 3/23/06, Andrea <andrea.b73@email.it> wrote:
>
>>Hi to all in the mailing-list! I am new and I have problems with command
>>line tools of PostgreSQL.
>>
>>I have 2 computers, one at home and one at office. Both computers are
>>equipped with Windows 2000 Professional SP4. On both computers I have
>>installed PostgreSQL 8.1.3-1 (the latest at this moment).
>>Both installations are "clean", I have NOT modified any PostgreSQL
>>configuration file!
>>
>>At home (where I have no problems), I can do:
>>-----------from console-----------
>>C:\>psql -h localhost -U postgres -d postgres
>>Password for user postgres:
>>Welcome to psql 8.1.3, the PostgreSQL interactive terminal.
>>
>>   [....]
>>
>>postgres=#
>>----------------------------------
>>
>>At office, if I try to do the same thing, I get:
>>-----------from console-----------
>>C:\>psql -h localhost -U postgres -d postgres
>>psql: FATAL:  password authentication failed for user "postgres"
>>----------------------------------
>>
>>In practice, psql doesn't ask me the password and fails immediately!
>>But note this (the first strange thing), I have NO problems connecting
>>to PostgreSQL server using pgAdmin III tool and also from PHP4/PHP5
>>scripts (I develop on web with Apache and PHP4/5).
>>
>>For example I have tried the following PHP script:
>>-----------code-----------
>><h1>PostgreSQL connection test</h1>
>><?php
>>$dbconn = pg_connect ("host=localhost dbname=postgres user=postgres
>>password=pgpw")
>>    or die ('Connect error: ' . pg_last_error ());
>>
>>pg_close ($dbconn);
>>?>
>><h3>Connected!</h3>
>>--------------------------
>>And in the web browser I see "Connected!", so connection to PostgreSQL
>>is ok!
>>
>>I am NOT able to connect to server using all command line tools like
>>psql, createuser, createdb, etc...
>>
>>Can someone help me?? What could be wrong on my computer at office???
>>Thanks in advance and sorry if my english is not perfect!
>>
>>Andrea
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Have you searched our list archives?
>>
>>               http://archives.postgresql.org
>>
>
>
>
> --
> Guido Barosio
> -----------------------

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems using PostgreSQL command line tools
Next
From: Andrea
Date:
Subject: Re: Problems using PostgreSQL command line tools