Re: [GENERAL] Postgres 9.0 Streaming Replication and Load Balancing?

Yes, that was the results of our tests ... It seems we'll have to do a lot of work on the application to separate the queries in order to achieve the load-balancing. Thanks anyway, Best regards, Paulo Correia On 17/05/12 09:32, Sumit Raja wrote: Unsure you can achieve this without a

Re: [GENERAL] Postgres 9.0 Streaming Replication and Load Balancing?

th no connection pool? Best regards, Paulo Correia On 15/05/12 09:01, Sumit Raja wrote: On 14 May 2012 17:28, Paulo Correia wrote: Hello all! Having a Postgres 9.0 with assynchronous streaming replication to a hot-standby slave, both with CentOs 5.6, how can I use both DB instances for query

Re: [GENERAL] Postgres 9.0 Streaming Replication and Load Balancing?

disruptive with the existing pool on the application servers. Has anyone had this issue before? Any suggestions? Best regards, Paulo Correia On 13/04/12 14:38, Paulo Correia wrote: Hi! I have a Postgres 9.0 on CentOs 5.6 with a functional asynchronous streaming replication to a hot-sta

[GENERAL] Postgres 9.0 Streaming Replication and Load Balancing?

or a Tomcat server, using the server connection pooling facilities and from that we would access the database, or the balancer. Has anyone managed to do this with pgPool-II? Any other options? Best regards, Paulo Correia -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

[GENERAL] Expanding a VARCHAR on a large table that has inherited subtables ...

1. set inheritance as before of sub-table to main table 2. drop the constraint on table and subtables, apply the alter table alter column and add the constraint again 3. any other way? Best regards, Paulo Correia