Re: PGPASSWORD - More than one in a bash script

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Patrick B <patrickbakerbr(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: PGPASSWORD - More than one in a bash script
Date: 2016-08-18 04:09:35
Message-ID: f8e6ce47-ea7c-0c83-02eb-3ce18c7a0943@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Silk Parrot 2016-08-18 06:02:53 Unique constraint on field inside composite type.
Previous Message Patrick B 2016-08-18 04:01:59 PGPASSWORD - More than one in a bash script