On Thursday, August 18, 2016, Patrick B <patrickbake...@gmail.com> 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.
