On Thursday, August 18, 2016, Patrick B <patrickbakerbr@xxxxxxxxx> 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?
I'm using PostgreSQL 9.5
You cannot. Instead, create your own variables and then, in the script, assign their values to pgpassword when appropriate.
David J.
