OK, cheers.
How can I remove the db so I can restore it properly? From: Scott Mead <[email protected]> Date: Monday, 23 October 2017 at 16:35 To: Martin Moore <[email protected]> Cc: Michael Nolan <[email protected]>, "[email protected]" <[email protected]> Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare On Mon, Oct 23, 2017 at 11:26 AM, Martin Moore <[email protected]> wrote: It was running – not sure how dd handles this. Maybe badly… ☺ it doesn't handle it at all. This would be the cause of your issue. --Scott From: Michael Nolan <[email protected]> Date: Monday, 23 October 2017 at 15:52 To: Martin Moore <[email protected]> Cc: rob stone <[email protected]>, "[email protected]" <[email protected]> Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare On Mon, Oct 23, 2017 at 3:14 AM, Martin Moore <[email protected]> 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, but if this has corrupted the files I can drop, dump and restore, in which case how do I ‘drop’ the DB without postgres running? Ta, Martin. Was the server you were backing up shut down or in backup mode when you did the 'dd' copy? -- Mike Nolan -- -- Scott Mead Sr. Architect OpenSCG http://openscg.com
