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 pretty sure Google use

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 system was running, then yo

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 Date: Monday, 23 October 2017 at 16:35 To: Martin Moore Cc: Michael Nolan , "pgsql-general@postgresql.org" Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare On Mon, Oct 2

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

2017-10-23 Thread Scott Mead
52 > *To: *Martin Moore > *Cc: *rob stone , "pgsql-general@postgresql.org" < > pgsql-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 > wrote:

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 Date: Monday, 23 October 2017 at 15:52 To: Martin Moore Cc: rob stone , "pgsql-general@postgresql.org" Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare On Mon, Oct 23, 2017

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 level disk structure the same,

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 resto

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 t

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 things correctly in this w