From: Simon White <simonwhite@dciphercomputing.com>
To: pgsql-admin@lists.postgresql.org
Subject: Automating pg_Dump on Windows 2016 Server
Date: Wed, 14 Nov 2018 14:49:18 -0500
Message-ID: <c2e04be9-3bbb-a575-190b-c8733efaaad1@dciphercomputing.com> (raw)
Hi
Automating pg_dump seems to be unnecessarily difficult from Windows
Server 2016. I have tried using the PGPASSWORD environment variable and
the PGPASSFILE environment variable all to no avail. The result is that
I am always prompted for a password. Could you not create a option to
pass the password on the command line or the location of a password file
to be used. That certainly would make things simpler.
Since I was using the "postgres" user I tried setting the password under
the "postgres" user in pgAdmin4 but that did not help either.
--
Regards,
Simon White
dCipher Computing
705-500-0191
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: simonwhite@dciphercomputing.com, pgsql-admin@lists.postgresql.org
Subject: Re: Automating pg_Dump on Windows 2016 Server
In-Reply-To: <c2e04be9-3bbb-a575-190b-c8733efaaad1@dciphercomputing.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox