Обсуждение: unattened dump

Hi all I am a newbe in postgres and I'm trying to obtain an unattended
dump to pgsql. I mean, I've tryed to use pg_dump using the -U flag but I
havn't found a way to pass a password in a unattended way. So I have to
guess the only solution is to configure pg_hba.conf to use ident as
authentication method?

Thank you very much

Piviul

On Thu, Apr 13, 2006 at 10:35:55AM +0200, Paolo Sala wrote:
> Hi all I am a newbe in postgres and I'm trying to obtain an unattended
> dump to pgsql. I mean, I've tryed to use pg_dump using the -U flag but I
> havn't found a way to pass a password in a unattended way. So I have to
> guess the only solution is to configure pg_hba.conf to use ident as
> authentication method?

Well, there's the .pgpass file. However, I usually find the best method is
to connect using unix domain sockets using ident (which isn't really
ident, it uses the OS to verify the user) from the database user
(postgres). Set this up in a cronjob and you're all set.

Have a ncie day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Martijn van Oosterhout scrisse in data 04/13/06 10:47:

>On Thu, Apr 13, 2006 at 10:35:55AM +0200, Paolo Sala wrote:
>
>
>>Hi all I am a newbe in postgres and I'm trying to obtain an unattended
>>dump to pgsql. I mean, I've tryed to use pg_dump using the -U flag but I
>>havn't found a way to pass a password in a unattended way. So I have to
>>guess the only solution is to configure pg_hba.conf to use ident as
>>authentication method?
>>
>>
>
>Well, there's the .pgpass file. However, I usually find the best method is
>to connect using unix domain sockets using ident (which isn't really
>ident, it uses the OS to verify the user) from the database user
>(postgres). Set this up in a cronjob and you're all set.
>
>
Thank you very much Martjin I was in doubt using your procedure because
I have phppgadmin installed on the same server and configured to use
unix domain sockets. But now I have disabled the use of postgres user in
phppgadmin so I hope postgres is secure...

Thank you very much

Piviul