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

From Guido Barosio
Subject Re: Problems using PostgreSQL command line tools
Date
Msg-id f7f6b4c70603231018r43227eb5w11fb1783a5bf8824@mail.gmail.com
Whole thread Raw
In response to Re: Problems using PostgreSQL command line tools  (Andrea <andrea.b73@email.it>)
List pgsql-novice
 Prolly just something down in the windows universe md5 related? :-)
Not a winguru :)

-Dunno about windows, but what if you set the trust to 'password' and
reload. If it works, there is something wrong with the method, or
that's what I'd rather tho.

-any $ENV var affecting?

g.-

On 3/23/06, Andrea <andrea.b73@email.it> wrote:
> Ok!!! Setting 'trust' instead of 'md5' works well!!
> Now psql doesn't ask me the password while pgAdmin III works too and ask
> me the password (why this difference???).
>
> <confused on>
> I continue to wonder why I got 2 different behaviours on my 2 PCs. At
> home I have 'md5' and it works! ;)
> <confused off>
>
> Regards.
> Andrea
>
> > replace the md5 with trust, and try again.
> >
> >
> > # IPv4 local connections:
> > host    all         all         127.0.0.1/32          trust
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>


--
Guido Barosio
-----------------------

pgsql-novice by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: kill-9 postmaster
Next
From: Murat Tasan
Date:
Subject: foreign key data type dereferencing