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>
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

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/