Re: PGPASSWORD - More than one in a bash script - Mailing list pgsql-general

On 08/17/2016 09:01 PM, Patrick B wrote:
> Hi guys,
>
> I'm writing a bash script to dump and restore (pg_dump + pg_restore) a
> test database.
>
> However, the username to access the pg_dump server is different of the
> one to access pg_restore.
>
> I'm using the PGPASSWORD parameter on the script, but can I put two of that?
>
> like:
>
>     PGPASSWORD
>     PGPASSWORD2
>
> If not, do you guys have any idea how I could do this?

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

>
> I'm using PostgreSQL 9.5
>
> cheers
>


--
Adrian Klaver
adrian.klaver@aklaver.com