From: | Joan Luc Labòrda <laborde(at)crpp-bordeaux(dot)cnrs(dot)fr> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Postgres user password |
Date: | 2018-02-22 08:06:52 |
Message-ID: | 6021714b-df77-09e4-b6a8-883f304e440d@crpp-bordeaux.cnrs.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)crpp-bordeaux(dot)cnrs(dot)fr
jean-luc(dot)laborde(at)u-bordeaux(dot)fr
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2018-02-22 11:59:40 | Re: PostgreSQL Backup Strategies |
Previous Message | Alvaro Aguayo Garcia-Rada | 2018-02-22 03:08:19 | RE: PostgreSQL Backup Strategies |