Linux How - To's - Free Consultancy: pgsql PITR

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Both InnoDB and PostgreSQL - as well as many other databases - use a technique called multi-version concurrency control (MVCC) to provide transaction isolation: transactions should not see the work of other, uncommitted transactions. MVCC means that, when a row is updated, the database stores both the old and new versions of the row.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Showing posts with label pgsql PITR. Show all posts

Thursday, October 14, 2010

PostgreSql Server Migration Using PITR

Migrate PostgreSQL Server to New Server With Minimal Downtime using PITR (Point In Time Recovery)

Source Server

mkdir /archive; chown postgres.postgres /archive;
vi /usr/local/postgres/data/postgresql.conf
Add the following lines:
archive_mode = on
archive_command = 'cp -i %p /archive%f'