Reg Incremental Backup and Restore In Postgres 8.1

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

rski

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

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

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

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about