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

Groups > comp.databases.postgresql > #706

Re: backup all databases

Show all headers | 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 | Next — Previous 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