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

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.

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

Saturday, November 27, 2010

PostgreSql Backup Script - Bash

If you are one who is using PostgreSql as your Back-end Database Server for your work, then obviously you need a backup solution, so here this is my try for a small solution for Automated Backup Job in  Bash Shell Script.
Read more »
Posted by at 7 comments:
Labels: ,

Sunday, November 21, 2010

Read Only User In Postgresql

Read only users in databases servers are frequently required, and generally  the method to create such user in different Database servers are very well known, such like in Mysql, Oracle, MSSQL etc...
Read more »
Posted by at No comments:
Labels:

Saturday, November 20, 2010

Comparing MySQL and Postgres 9.0 Replication

Hi,

As this post is not mine... but i am glad to share this post with every one.
This one is amazing about mysql vs postgresql replication way.

Click below Link:
Comparing MySQL and Postgres 9.0 Replication
Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)