Re: Postgres user password

From: chiru r <chirupg(at)gmail(dot)com>
To: Azimuddin Mohammed <azimeiu(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres user password
Date: 2018-02-22 02:35:27
Message-ID: CA+RSxMhnSSF7ofs=Q2wjwa6HDiudtui2KdkLzJS-AgAf61iw9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

can you check if you can use the pgpass file.

https://www.postgresql.org/docs/9.5/static/libpq-pgpass.html

Thanks,
Chiru

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Luis Marin 2018-02-22 03:01:14 PostgreSQL Backup Strategies
Previous Message Azimuddin Mohammed 2018-02-22 02:27:50 Postgres user password