Thread: feature request in postgresql 9.0 release
Dear PostgreSQL community i m a active tester of postgresql 9.0 release i must say the new feature of streaming replication is wonderful i was looking for this feature since a long time i would like to request one more thing in this feature that is while the standby server accept read only connection make it like that this will also accept ddl queries for the local standby server only i mean server will accept read only queries for the tables that are in synchronization with primary server but accept all queries for local connection ( e.g. create table will issue in standby server where table is not in primary server ) Looking forward for the positive reply Thanks Jai Soni P Please consider the environment before printing this email. |
Jai Soni wrote: > Dear PostgreSQL community > > i m a active tester of postgresql 9.0 release i must say the new feature > of streaming replication is wonderful i was looking for this feature > since a long time i would like to request one more thing in this feature > that is while the standby server accept read only connection make it > like that this will also accept ddl queries for the local standby server > only i mean server will accept read only queries for the tables that > are in synchronization with primary? server but accept all queries for > local connection ( e.g. create table will issue in standby server where > table is not in primary server ) > > Looking forward for the positive reply We have no plans to implement this. It is too difficult to separate the master and slave data. Slony allows such partitioning. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +