Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.postgresql > #706

Re: backup all databases

Path csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From Robert Klemme <shortcutter@googlemail.com>
Newsgroups comp.databases.postgresql
Subject Re: backup all databases
Date Wed, 2 Mar 2016 19:53:24 +0100
Lines 24
Message-ID <djor55F3flnU2@mid.individual.net> (permalink)
References <nb7ade$i41$1@news.m-online.net>
Mime-Version 1.0
Content-Type text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding 7bit
X-Trace individual.net FSWZtwaAq/PD6OQrrLqN4ABJvdLlaviEgfXu0qNxD31MFRQm0=
Cancel-Lock sha1:zpt+I8WgPvpM7f5tC+5+/Jf3ssI=
User-Agent Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.5.1
In-Reply-To <nb7ade$i41$1@news.m-online.net>
Xref csiph.com comp.databases.postgresql:706

Show key headers only | View raw


On 02.03.2016 19:11, Magnus Warker wrote:

> I regularly backup a system using rsync.
> There is a postgresql server running on that system.
>
> How can I include all postgresql databases in that backup?
>
> - should I include a folder in my backup where postgresql stores its
> databases?
> - should I make a dump and then backup that dump?
>
> What would be the quickest or most simple method?

This is a good starting place to read:
http://www.postgresql.org/docs/9.5/static/backup.html

Cheers

	robert


-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

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


Thread

backup all databases Magnus Warker <magnux@mailinator.com> - 2016-03-02 19:11 +0100
  Re: backup all databases Robert Klemme <shortcutter@googlemail.com> - 2016-03-02 19:53 +0100

csiph-web