Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #763
| From | Mladen Gogala <gogala.mladen@gmail.com> |
|---|---|
| Newsgroups | comp.databases.postgresql |
| Subject | Re: Issues with backing up Postgres by copying folder |
| Date | 2017-05-08 02:41 +0000 |
| Organization | A noiseless patient Spider |
| Message-ID | <oeoltn$v2k$2@dont-email.me> (permalink) |
| References | (2 earlier) <%KzMA.146910$3c5.37564@fx34.iad> <8737csyd5l.fsf@doppelsaurus.mobileactivedefense.com> <a0JMA.8507$4a5.1000@fx01.iad> <87wpa4sfn4.fsf@doppelsaurus.mobileactivedefense.com> <87shkssfbo.fsf@doppelsaurus.mobileactivedefense.com> |
On Fri, 28 Apr 2017 16:48:59 +0100, Rainer Weikusat wrote: > 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 There is a much simpler solution: buy Commvault and it will take care of all of that for you. PS: --- I am an employee of Commvault Systems. -- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.com
Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar
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