Reg Incremental Backup and Restore In Postgres 8.1

varathasiva · #1 January 16th, 2008, 10:12 AM

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 · #2 January 16th, 2008, 11:19 AM

Quote:

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)

ravithapliyal · #3 April 29th, 2009, 12:18 PM

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?

rski · #4 April 29th, 2009, 05:52 PM

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.

Reg Incremental Backup and Restore In Postgres 8.1

re: Reg Incremental Backup and Restore In Postgres 8.1

re: Reg Incremental Backup and Restore In Postgres 8.1

re: Reg Incremental Backup and Restore In Postgres 8.1

/bytes/development

/bytes/it

/bytes/about