Path: csiph.com!feeder.erje.net!1.eu.feeder.erje.net!news-1.dfn.de!news.dfn.de!news.informatik.hu-berlin.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:48:59 +0100 Lines: 45 Message-ID: <87shkssfbo.fsf@doppelsaurus.mobileactivedefense.com> References: <87h91evna3.fsf@doppelsaurus.mobileactivedefense.com> <%KzMA.146910$3c5.37564@fx34.iad> <8737csyd5l.fsf@doppelsaurus.mobileactivedefense.com> <87wpa4sfn4.fsf@doppelsaurus.mobileactivedefense.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: individual.net s7i69cnXSQ3aWVI1tmLlQAMdGostkbXABBbf0+nc36KVnMzD8= Cancel-Lock: sha1:/mJ4e2ygAqI9fgMHn4DyBQqIXdg= sha1:BXYok/ASMPhzs7xe+zgzMx9A9uU= User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux) Xref: csiph.com comp.databases.postgresql:750 Rainer Weikusat writes: > 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. Compare the following procedures: 1. Stop database server. 2. Copy data directory 3. Copy configuration directory 4. Start different version of database server and hope for the best 1. pg_dumpall >p 2. psql