From: | "Ganesan Kanavathy" <ganesh(at)magnusquest(dot)com> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Rudi Starcevic'" <rudi(at)oasis(dot)net(dot)au> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_dump.. auto backup |
Date: | 2003-10-16 04:08:11 |
Message-ID: | 000e01c3939b$22aad1e0$1300a8c0@headquarters.mq.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks for the reply,
I don't really understand this. How to put password in ~/.pgpass. What
changes do I need to do on the script? How do I access to the password
to authenticate?
I'm still new Linux. Hope to get more explanation and guidance.
Thanks.
Regards,
ganesh
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Thursday, October 16, 2003 11:37 AM
To: Rudi Starcevic
Cc: Ganesan Kanavathy; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] pg_dump.. auto backup
Rudi Starcevic <rudi(at)oasis(dot)net(dot)au> writes:
> Ganesan Kanavathy wrote:
>> The problem I am facing is the when running the cronjob it is asking
>> for password.
> Just add:
> export PGPASSWORD=mypassword
> to your script.
A much better solution (assuming you are using a reasonably recent PG
release) is to put the needed password in ~/.pgpass, which can be set to
0600 permissions. PGPASSWORD is insecure on many platforms because
other people can see your environment variables.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | shyamperi | 2003-10-16 04:34:11 | [none] |
Previous Message | Tom Lane | 2003-10-16 03:36:35 | Re: pg_dump.. auto backup |