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"
from http://dev.mysql.com/doc/refman/4.1/en/blob.html
You can change the message buffer size by changing the value of the
max_allowed_packet variable, but you must do so for both the server and
your client program. For example, both mysql and mysqldump allow you to
change the client-side max_a
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
s
Andrew Dunstan wrote:
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 t
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",
