Path: csiph.com!news.mixmin.net!news.unit0.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Rainer Weikusat Newsgroups: comp.databases.postgresql Subject: Re: Issues with backing up Postgres by copying folder Date: Sun, 23 Apr 2017 22:15:16 +0100 Lines: 17 Message-ID: <87h91evna3.fsf@doppelsaurus.mobileactivedefense.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: individual.net ofazoRJvKOScSSFO0BVQOg8A1y5QaQrGR7IeRXfjUrIDQknsI= Cancel-Lock: sha1:ftUaGq5rFjsuWTz4Y0TouS6TBZM= sha1:DiEP+wvpCfQ6jei9qxPwG2VJxrI= User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux) Xref: csiph.com comp.databases.postgresql:741 DFS writes: > Windows > Postgres 9.6.2 > > On install I set the /data directory to a data drive (D:\) > > How much trouble will it cause if I: > > 1) backup that entire /data directory by copying it to a backup place > 2) reinstall Postgres (and set the /data directory to the same > location as before) > 3) copy over the new /data directory with my backup? > > No pgdump - just copy and replace files. Is there a reason why you want to follow such a cumbersome and fragile procedure?