Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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?


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          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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group