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

Groups > comp.databases.postgresql > #705 > unrolled thread

backup all databases

Back to article view | Back to comp.databases.postgresql

Contents

  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

#705 — backup all databases

Hello,

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?

Thanks
Magnus

[toc] | [next] | [standalone]

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

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.postgresql

csiph-web