NFS version for replication

2020-05-17 Thread Weatherby,Gerard
When setting up an NFS mount for archive WAL logs as described in https://www.postgresql.org/docs/12/continuous-archiving.html, is NFS v3 or NFS v4 preferred? -- Gerard Weatherby | Application Architect NMRbox | Department of Molecular Biology and Biophysics | UConn Health 263 Farmington Avenue,

Re: How to run a task continuously in the background

2019-07-17 Thread Weatherby,Gerard
We used a python process running continually on a linux client for the LISTEN piece. Reading the documentation, it seems that a background worker ( https://www.postgresql.org/docs/11/bgworker.html) might be a solution to your requirements. I don’t have personal experience with them. -- Gerard W

Re: execute_values

2019-07-10 Thread Weatherby,Gerard
9 8484 uchc.edu From: Adrian Klaver Sent: Tuesday, July 9, 2019 4:25 PM To: Weatherby,Gerard; pgsql-general@lists.postgresql.org Subject: Re: execute_values On 7/9/19 11:04 AM, Weatherby,Gerard wrote: > ​Can I use pyscopy2.extras.execute_values with a prepared statement? I don

execute_values

2019-07-09 Thread Weatherby,Gerard
?Can I use pyscopy2.extras.execute_values with a prepared statement? -- Gerard Weatherby| Application Architect NMRbox | Department of Molecular Biology and Biophysics | UConn Health 263 Farmington Avenue, Farmington, CT 06030-6406 Phone: 860 679 8484 uchc.edu