> I suggest allowing the 'postgres' user to connect with 'ident sameuser'
> in pg_hba.conf from the localhost only, then always just run pg_dump as
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
host <mydb> <myuser> localhost 255.255.255.255
only <myuser> will NOT be asked for password when it does
pg_dump -U <myuser>
when logged in to its shell account with <myuser>
and If I run a crontab with user <myuser> the above lines again stands true.
What you say ?
With Best Regards,
Lead Software Developer,
In response to
pgsql-php by date
|Next:||From: enzo venegas palacios||Date: 2005-04-01 12:47:35|
|Subject: migrate data|
|Previous:||From: Christopher Browne||Date: 2005-04-01 05:04:48|
|Subject: Re: PostgreSQL Backup Script|