Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres user password - Mailing list pgsql-admin

From chiru r
Subject Re: Postgres user password
Date
Msg-id CA+RSxMhnSSF7ofs=Q2wjwa6HDiudtui2KdkLzJS-AgAf61iw9w@mail.gmail.com
Whole thread Raw
In response to Postgres user password  (Azimuddin Mohammed <azimeiu@gmail.com>)
List pgsql-admin
Tree view
Hi,

can you check if you can use the pgpass file.



Thanks,
Chiru

On Wed, Feb 21, 2018 at 9:27 PM, Azimuddin Mohammed <azimeiu@gmail.com> 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 ?

pgsql-admin by date:

Previous
From: Azimuddin Mohammed
Date:
Subject: Postgres user password
Next
From: Luis Marin
Date:
Subject: PostgreSQL Backup Strategies