Re: [HACKERS] password is no required, authentication is overridden

> -Original Message- > From: Andrew Dunstan [mailto:[EMAIL PROTECTED] > Sent: 19 July 2006 15:20 > To: Dave Page > Cc: Hiroshi Saito; Thomas Bley; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] password is no required, > authentication is overri

Re: [HACKERS] password is no required, authentication is overridden

Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Dunstan Sent: 19 July 2006 13:55 To: Hiroshi Saito Cc: Thomas Bley; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] password is no required, authentication is

Re: [HACKERS] password is no required, authentication is overridden

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Andrew Dunstan > Sent: 19 July 2006 13:55 > To: Hiroshi Saito > Cc: Thomas Bley; pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] password is no required, > a

Re: [HACKERS] password is no required, authentication is overridden

Hiroshi Saito wrote: From: "Andrew Dunstan" Thomas Bley wrote: + The .pgpass file will be automatically created if you're using pgAdmin III with "store password" being enabled in the connection settings. It strikes me that this is actually a bad thing for pgadmin3 to be doing. It

Re: [HACKERS] password is no required, authentication is overridden

Andrew Dunstan wrote: It strikes me that this is actually a bad thing for pgadmin3 to be doing. It should use its own file, not the deafult location, at least if the libpq version is >= 8.1. We provided the PGPASSFILE environment setting just so programs like this could use alternative loca

Re: [HACKERS] password is no required, authentication is overridden

From: "Andrew Dunstan" Thomas Bley wrote: + The .pgpass file will be automatically created if you're using pgAdmin III with "store password" being enabled in the connection settings. It strikes me that this is actually a bad thing for pgadmin3 to be doing. It should use its own file,

Re: [HACKERS] password is no required, authentication is overridden

or maybe split the file up into sections like this example: [pgadmin3] localhost:5432:*:postgres:post [pg_dump] [psql] bye Thomas Andrew Dunstan wrote: Thomas Bley wrote: + The .pgpass file will be automatically created if you're using pgAdmin III with "store password" being enabled i

Re: [HACKERS] password is no required, authentication is overridden

Thomas Bley wrote: + The .pgpass file will be automatically created if you're using pgAdmin III with "store password" being enabled in the connection settings. It strikes me that this is actually a bad thing for pgadmin3 to be doing. It should use its own file, not the deafult location,

Re: [HACKERS] password is no required, authentication is overridden

Andrew Hammond wrote: Looking into the documentation delivered with pg ("PostgreSQL and pgAdmin Help") there is a page about the pgpass file, but there is not hint to environment variable pgpassword or the pgpass-file on the page of pg_dump, maybe you can add it ? In the documentation page of psq

Re: [HACKERS] password is no required, authentication is overridden

> There is a pgpass file and it contians the password: > D:\Documents and Settings\admin\Application Data\postgresql\pgpass.conf > > My installation is on: D:\Program Files\PostgreSQL\8.1\ > > Maybe it got automatically created by pgadmin3 ? I'll bet you're right. > Looking into the documentation

Re: [HACKERS] password is no required, authentication is overridden

Hello Andrew, Thanks a lot! There is a pgpass file and it contians the password: D:\Documents and Settings\admin\Application Data\postgresql\pgpass.conf My installation is on: D:\Program Files\PostgreSQL\8.1\ Maybe it got automatically created by pgadmin3 ? Looking into the documentation deliv

Re: [HACKERS] password is no required, authentication is overridden

Andrew Hammond wrote: I'm not sure what the default behaviour for local socket connections is. Perhaps you should add a line to your pg_hba.conf to define a rule for local socket connections. For example local all all md5 He's on Windows - no local lines there. cheers andrew ---

Re: [HACKERS] password is no required, authentication is overridden

Thomas Bley wrote: > I type: pg_dump -h localhost -U postgres database_name and there is no > question for the password. Have you created a .pgpass (or whatever the equivilant in the Windows world is)? That could be supplying the password. > I haven't made changes to pg_hba.conf. I'm logged in a

Re: [HACKERS] password is no required, authentication is overridden

Are you sure you don't have a pgpass file, or the environment variable PGPASSWORD set? cheers andrew Thomas Bley wrote: Hi, I already tried to mail [EMAIL PROTECTED] but my message was stalled. Version: 8.1.4 (binary for win32) OS: Windows XP SP2 I type: pg_dump -h localhost -U postgr

[HACKERS] password is no required, authentication is overridden

Hi, I already tried to mail [EMAIL PROTECTED] but my message was stalled. Version: 8.1.4 (binary for win32) OS: Windows XP SP2 I type: pg_dump -h localhost -U postgres database_name and there is no question for the password. I haven't made changes to pg_hba.conf. I'm logged in as user "admin",