Re: Db backup

On 6/8/2017 12:29 PM, John R Pierce wrote:
> On 6/8/2017 12:10 PM, Jimmy Lunceford wrote:
>> A windows 7 computer went bad but the hdd is still operable. Is there
>> a way to transfer the db data directories to another computer or does
>> it require a dump and restore?
>
>
> the data directories should work as-is on another Windows computer
> with the same major version and 'build' of postgresql and same 32 vs
> 64 bitness. By 'build' I mean like enterpriseDB installer vs BigSQL
> vs custom-built. if custom built, the build options will need to be
> pretty much the same (visualC vs gcc/mingw vs cygwin, and the same
> general ./configure options, etc etc).

to restore said file system level backup, I would...

A) install the compatible postgresql build (if the original was 9.3.5,
its fine to use 9.3.17)

B) stop the postgresql database service

C) replace the 'data' directory with a copy of the data directory from
the disk of said dead box

D) restart the postgresql database service

E) verify your databases are intact and complete.

if you used custom tablespaces, be sure to restore all those at step C,
too, qirh the same paths as the originala.

--
john r pierce, recycling bits in santa cruz