Silvio Brandani <silvio.brandani@xxxxxxxxxxx> wrote: > we already have the Point In Time Recovery but we need a solution > where the standby is always open in readonly , but the data is > replicated continuosly from primary. What's your time frame? The Hot Standby and Streaming Replication features in PostgreSQL 9.0 will do exactly that. 9.0 is currently in beta testing and expected to be released next month. These new features are based on PITR techniques, but SR allows the WAL data to flow across a connection in near real-time, and HS allows the standby to be used for read-only queries. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin