Automating pg_Dump on Windows 2016 Server - Mailing list pgsql-admin

From Simon White
Subject Automating pg_Dump on Windows 2016 Server
Date
Msg-id c2e04be9-3bbb-a575-190b-c8733efaaad1@dciphercomputing.com
Whole thread Raw
Responses Re: Automating pg_Dump on Windows 2016 Server  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device"
Next
From: Thomas Kellerer
Date:
Subject: Re: Automating pg_Dump on Windows 2016 Server