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@xxxxxxxxxxxxxxxxxxxxx
jean-luc.laborde@xxxxxxxxxxxxx
