Re: [GENERAL] PGPASSWORD - More than one in a bash script

2016-08-18 Thread David G. Johnston
On Thursday, August 18, 2016, 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

Re: [GENERAL] PGPASSWORD - More than one in a bash script

2016-08-17 Thread Adrian Klaver
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

[GENERAL] PGPASSWORD - More than one in a bash script

2016-08-17 Thread Patrick B
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 >