Re: PostgreSQL Backup Script

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



> 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
> 'postgres'.

That means 

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
host    <mydb>  <myuser>         localhost     255.255.255.255    
ident sameuser

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,
Vishal Kashyap.
Lead Software Developer,
http://saihertz.com,
http://vishalkashyap.tk


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux