Re: Problems using PostgreSQL command line tools

From: "Guido Barosio" <gbarosio(at)gmail(dot)com>
To: Andrea <andrea(dot)b73(at)email(dot)it>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problems using PostgreSQL command line tools
Date: 2006-03-23 18:18:24
Message-ID: f7f6b4c70603231018r43227eb5w11fb1783a5bf8824@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)b73(at)email(dot)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
-----------------------

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Murat Tasan 2006-03-23 20:51:17 foreign key data type dereferencing
Previous Message Devrim GUNDUZ 2006-03-23 17:20:34 Re: kill-9 postmaster