1. Forum
  2. Usenet
  3. COMP.DATABASES.POSTGRESQL

  • backup all databases

    From Magnus Warker@21:1/5 to All on Wed Mar 2 19:11:58 2016
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Robert Klemme@21:1/5 to Magnus Warker on Wed Mar 2 19:53:24 2016
    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/

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)