Re: [GENERAL] Postgres 9.6 fails to start on VMWare

2017-10-24 Thread Martin Moore
On 23/10/2017, 17:17, "George Neuner" wrote: >Doesn't GCloud provide a way to export drive images? [He asks naively, never having used it.] Nope – just the dd method (although this doesn’t work on VMWare, so you need to use a VWM utility on a Win pc to get it). I’m

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

2017-10-23 Thread Martin Moore
OK, cheers. How can I remove the db so I can restore it properly? From: Scott Mead <sco...@openscg.com> Date: Monday, 23 October 2017 at 16:35 To: Martin Moore <martin.mo...@avbrief.com> Cc: Michael Nolan <htf...@gmail.com>, "pgsql-general@postgresql.org" &

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

2017-10-23 Thread Martin Moore
It was running – not sure how dd handles this. Maybe badly… ☺ From: Michael Nolan <htf...@gmail.com> Date: Monday, 23 October 2017 at 15:52 To: Martin Moore <martin.mo...@avbrief.com> Cc: rob stone <floripa...@gmail.com>, "pgsql-general@postgresql.org" <pgsql-

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

2017-10-23 Thread Martin Moore
and restore, in which case how do I ‘drop’ the DB without postgres running? Ta, Martin. On 23/10/2017, 00:51, "rob stone" <floripa...@gmail.com> wrote: On Sun, 2017-10-22 at 15:13 +0100, Martin Moore wrote: > 2017-10-22 14:08:28 UTC [2479-1] LOG: 000

[GENERAL] Postgres 9.6 fails to start on VMWare

2017-10-22 Thread Martin Moore
I’ve migrated a running Debian Jessie system from a Google Compute instance to a VMWare ESXi 6.5 system. Postgres won’t start, although returns [ok] : /etc/init.d/postgresql start 9.6 [ ok ] Starting postgresql (via systemctl): postgresql.service. 2017-10-22 14:08:28 UTC [2479-1] LOG:  0:

[GENERAL] Deadlocks

2017-08-22 Thread Martin Moore
Hi, I’m having issues with deadlocks. v9.6 on Debian Jessie. I have a number of ‘select’ functions which for logging purposes also call another fn that inserts a record into a ‘logging’ table. However, even with only 1 or 2 users making very infrequent calls to the parent fn, deadlocks are

[GENERAL] Segmentation fault calling shared object file

2017-01-24 Thread Martin Moore
Hi, I have a ‘C’ shared object that has been running on postgres since 8.3 and maybe before – on 32 bit Debian. Currently on 9.3. I’m trying to migrate to Google cloud (64 bit Debian) and get a seg fault when calling one of the functions which have been recompiled on the Google instance. This