Reg Incremental Backup and Restore In Postgres 8.1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • varathasiva
    New Member
    • Sep 2006
    • 20

    Reg Incremental Backup and Restore In Postgres 8.1

    Dear All,
    I want take a incremental backup and restore in postgres sql throught command.If you have any ideas reply me.Advance thanks to all.

    Kindly Regards
    Siva
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    Originally posted by varathasiva
    Dear All,
    I want take a incremental backup and restore in postgres sql throught command.If you have any ideas reply me.Advance thanks to all.

    Kindly Regards
    Siva
    Probably you can do it in a few ways:
    1. using WAL see here http://www.postgresql.org/docs/8.2/i...archiving.html
    2. using replication (Slony-I for example)

    Comment

    • ravithapliyal
      New Member
      • Apr 2009
      • 4

      #3
      Hi Siva & Rski,

      Can this incremental backup be taken and restore in the postgres database on windows also? If yes then is WAL or SLONY are the tools?

      Comment

      • rski
        Recognized Expert Contributor
        • Dec 2006
        • 700

        #4
        WAL is not a standalone soft. It is a postgres feature. You only need to turn it on.
        Slony-I is a tool, which you need to download and install. It doesn't matter which OS you use.

        Comment

        Working...