Re: Postgres user password

If you can use SSH to transfer your backup maybe you could authenticate 
with ssh keys.

you should have to generate postgres ssh keys being login as 'postgres' 
with ssh-keygen program, then you copy you public key on your backup 
server and the authentication will hapend between the 2 servers by 
comparing the keys ...


Le 22/02/2018 à 03:27, Azimuddin Mohammed a écrit :
> 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 ?

-- 
Joan Luc Labòrda 05.5684.3013
laborde@crpp-bordeaux.cnrs.fr
jean-luc.laborde@u-bordeaux.fr