Postgres Pro
Downloads
Home   >   mailing lists

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

From Patrick B
Subject PGPASSWORD - More than one in a bash script
Date
Msg-id CAJNY3ivdmRhka38C75wfq2ga6kchDZs2HDVBaru8EuO7Q-=C1g@mail.gmail.com
Whole thread Raw
Responses Re: PGPASSWORD - More than one in a bash script  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: PGPASSWORD - More than one in a bash script  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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?

I'm using PostgreSQL 9.5

cheers

pgsql-general by date:

Previous
From: James Sewell
Date:
Subject: Re: Critical failure of standby
Next
From: Adrian Klaver
Date:
Subject: Re: PGPASSWORD - More than one in a bash script