> -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
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
> -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
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
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
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,
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
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,
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
> 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
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
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
---
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
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
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",
15 matches
Mail list logo