Path: csiph.com!news.swapon.de!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: Fri, 28 Apr 2017 16:42:07 +0100 Lines: 34 Message-ID: <87wpa4sfn4.fsf@doppelsaurus.mobileactivedefense.com> References: <87h91evna3.fsf@doppelsaurus.mobileactivedefense.com> <%KzMA.146910$3c5.37564@fx34.iad> <8737csyd5l.fsf@doppelsaurus.mobileactivedefense.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: individual.net WjAymBuxY4YA2LpE+xUZtQFdRA0nKBbeuS0CftUIb9kI+ZNMc= Cancel-Lock: sha1:KDr/SI47OlpPbbeR2CGifY5Vbeg= sha1:UHPmzIICBdEZsJ8UsuALm4IvBaM= User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux) Xref: csiph.com comp.databases.postgresql:749 DFS writes: > On 4/28/2017 7:39 AM, Rainer Weikusat wrote: >> DFS writes: >>> On 4/23/2017 5:15 PM, Rainer Weikusat wrote: >>>> 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? >>> >>> >>> 1) it seems very uncumbersome to just copy a folder to a backup drive >> >> Why do you want to hunt the system for "folders" based on some >> assumption about the disk usage of the DBMS instead of just using >> pg_dump? > > What 'hunting' are you talking about? A: Because I never read documentation! I already figured so.