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

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

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 hot_standby. 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'