[GENERAL] If pg_ctl dies, can we attach a new pg_ctl process to postgres?

2016-10-31 Thread Daevor The Devoted
Hi On a Windows 10 system (using pg9.3), we have occasionally noted that the pg_ctl process is not running, but the main postgres.exe process is. Windows services then reports postgres as not running, when it is actually is. Is it thus possible to start up a new pg_ctl process, and "attach" it to

Re: [GENERAL] select date between - PostgreSQL 9.5

2016-09-13 Thread Daevor The Devoted
On Wed, Sep 14, 2016 at 4:49 AM, Patrick B wrote: > > > 2016-09-14 13:17 GMT+12:00 David Rowley : > >> On 14 September 2016 at 12:20, Patrick B >> wrote: >> > I want to select all rows that have been modified from now to 4 months >> ago. >> > >> > I've used these queries: >> > >> >> select >> >>

Re: [GENERAL] IDE for function/stored proc development.

2016-09-05 Thread Daevor The Devoted
On Mon, Sep 5, 2016 at 10:02 AM, Martijn Tonies (Upscene Productions) < m.ton...@upscene.com> wrote: > Hello Tim, > > We will be releasing Database Workbench with PostgreSQL support later this > week, it’s a Windows application but works fine on Linux/MacOS via Wine. > > Here’s the link to our web

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-12 Thread Daevor The Devoted
On Fri, Aug 12, 2016 at 10:58 AM, Andreas Joseph Krogh wrote: > På fredag 12. august 2016 kl. 10:33:19, skrev Chris Travers < > chris.trav...@gmail.com>: > > > > On Fri, Aug 12, 2016 at 9:59 AM, Andreas Joseph Krogh > wrote: >> >> På fredag 12. august 2016 kl. 05:27:42, skrev Chris Travers < >>