Re: Postgres user password

[chiru r <chirupg@xxxxxxxxx>]

Hi,

can you check if you can use the pgpass file.

https://www.postgresql.org/docs/9.5/static/libpq-pgpass.html

Thanks,

Chiru

On Wed, Feb 21, 2018 at 9:27 PM, Azimuddin Mohammed <azimeiu@xxxxxxxxx> wrote:

Hello,

I have setup my postgres server with postgres as a super user with password. Everytimg when i connect to postgress as super user i have to login with password. My question is how can I automate the scripts for back up and restore that will require password while taking backup or doing restore. We do not want to store the password in the script due to security concerns. Is there a way to do ?