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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general