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