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