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 George Neuner
On Mon, 23 Oct 2017 09:14:18 +0100, Martin Moore wrote: >Same server. I tried a few times. > >I didn’t move the db separately, but did a ‘dd’ to copy the disk >to an imagefile which was converted and loaded into VMWare. If you copied the boot device that way while the

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

2017-10-23 Thread Martin Moore
lt;pgsql-general@postgresql.org> Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare On Mon, Oct 23, 2017 at 11:26 AM, Martin Moore <martin.mo...@avbrief.com> wrote: It was running – not sure how dd handles this. Maybe badly… ☺ it doesn't handle it at all. This would

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

2017-10-23 Thread Scott Mead
om> > *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-general@postgresql.org> > *Subject: *Re: [GENERAL] Postgres 9.6 fails to s

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

2017-10-23 Thread Martin Moore
general@postgresql.org> Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare On Mon, Oct 23, 2017 at 3:14 AM, Martin Moore <martin.mo...@avbrief.com> wrote: Same server. I tried a few times. I didn’t move the db separately, but did a ‘dd’ to copy the disk to an

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

2017-10-23 Thread Michael Nolan
On Mon, Oct 23, 2017 at 3:14 AM, Martin Moore wrote: > Same server. I tried a few times. > > I didn’t move the db separately, but did a ‘dd’ to copy the disk to an > imagefile which was converted and loaded into VMWare. > > I ‘believed’ that this should keep the low

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

2017-10-23 Thread Martin Moore
Same server. I tried a few times. I didn’t move the db separately, but did a ‘dd’ to copy the disk to an imagefile which was converted and loaded into VMWare. I ‘believed’ that this should keep the low level disk structure the same, but if this has corrupted the files I can drop, dump and

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

2017-10-22 Thread rob stone
On Sun, 2017-10-22 at 15:13 +0100, Martin Moore wrote: > 2017-10-22 14:08:28 UTC [2479-1] LOG: 0: database system > shutdown was interrupted; last known up at 2017-10-22 14:07:20 UTC There is something missing here. Last shutdown at 2017-10-22 14:07:20 UTC on which server? Then attempting

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

2017-10-22 Thread Michael Paquier
On Sun, Oct 22, 2017 at 11:13 PM, Martin Moore wrote: > I’ve migrated a running Debian Jessie system from a Google Compute instance > to a VMWare ESXi 6.5 system. How did you actually do this migration? It is really easy to finish with a corrupted instance if not doing

[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: