Groups > comp.databases.postgresql > #750

Re: Issues with backing up Postgres by copying folder

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 <rweikusat@talktalk.net>
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> (permalink)
References	<smBIA.407$xR7.221@fx28.iad> <87h91evna3.fsf@doppelsaurus.mobileactivedefense.com> <%KzMA.146910$3c5.37564@fx34.iad> <8737csyd5l.fsf@doppelsaurus.mobileactivedefense.com> <a0JMA.8507$4a5.1000@fx01.iad> <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

Show key headers only | View raw

Rainer Weikusat <rweikusat@talktalk.net> writes:
> DFS <nospam@dfs.com> writes:
>> On 4/28/2017 7:39 AM, Rainer Weikusat wrote:
>>> DFS <nospam@dfs.com> writes:
>>>> On 4/23/2017 5:15 PM, Rainer Weikusat wrote:
>>>>> DFS <nospam@dfs.com> 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 <p

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-04-15 23:17 -0400
  Re: Issues with backing up Postgres by copying folder Terry Shanks <deep@shallow.house> - 2017-04-19 20:11 +0100
    Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-04-28 00:45 -0400
      Re: Issues with backing up Postgres by copying folder Terry Shanks <deep@shallow.house> - 2017-05-02 00:07 +0100
        Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-02 11:48 -0400
          Re: Issues with backing up Postgres by copying folder Dimitri Fontaine <dimitri.fontaine@schibsted.com> - 2017-05-03 09:16 +0200
            Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-03 16:07 -0400
            Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-20 20:01 -0400
              Re: Issues with backing up Postgres by copying folder Dimitri Fontaine <dimitri.fontaine@schibsted.com> - 2017-05-21 13:46 +0200
                Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-21 08:48 -0400
                Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-31 07:29 -0400
                Re: Issues with backing up Postgres by copying folder Dimitri Fontaine <dimitri.fontaine@schibsted.com> - 2017-05-31 14:26 +0200
                Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-31 09:52 -0400
                Re: Issues with backing up Postgres by copying folder Dimitri Fontaine <dimitri.fontaine@schibsted.com> - 2017-05-31 16:27 +0200
          Re: Issues with backing up Postgres by copying folder Terry Shanks <deep@shallow.house> - 2017-05-03 13:57 +0100
            Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-11 11:11 -0400
              Re: Issues with backing up Postgres by copying folder Robert Klemme <shortcutter@googlemail.com> - 2017-05-11 23:08 +0200
    Re: Issues with backing up Postgres by copying folder Gordon Gekko <greed@is.good.invalid> - 2017-05-08 02:39 +0000
  Re: Issues with backing up Postgres by copying folder Rainer Weikusat <rweikusat@talktalk.net> - 2017-04-23 22:15 +0100
    Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-04-28 00:42 -0400
      Re: Issues with backing up Postgres by copying folder Rainer Weikusat <rweikusat@talktalk.net> - 2017-04-28 12:39 +0100
        Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-04-28 11:16 -0400
          Re: Issues with backing up Postgres by copying folder Rainer Weikusat <rweikusat@talktalk.net> - 2017-04-28 16:42 +0100
            Re: Issues with backing up Postgres by copying folder Rainer Weikusat <rweikusat@talktalk.net> - 2017-04-28 16:48 +0100
              Re: Issues with backing up Postgres by copying folder Terry Shanks <deep@shallow.house> - 2017-05-02 00:00 +0100
              Re: Issues with backing up Postgres by copying folder Mladen Gogala <gogala.mladen@gmail.com> - 2017-05-08 02:41 +0000

csiph-web