Re: [GENERAL] unable to build postgres-9.4 in os x 10.9 with python

Hi all, Thanks for all the responses. It looks like Edoardo was on the right track, I hadn’t upgraded the Command Line Developer Tools. after downloading them from apple and installing them, i was able to build postgres with '--with-python' reiner On 30 maj 2014, at 19:56, Edoardo Panfili wr

[GENERAL] PosgtresSQL master-slave synchronous replication to multiple slaves

PostgresSQL has support for master-slave replication, but the synchronous streaming replication only supports a single synchronous slaves. You can have multiple slaves, but only one will be synchronously updat

Re: [GENERAL] PosgtresSQL master-slave synchronous replication to multiple slaves

On Sat, May 31, 2014 at 5:30 PM, Vlad Mihalcea wrote: > If you run a large enterprise system in a master-slave replication scheme on > top of PostgreSQL, what options do I have for enabling multiple synchronous > slaves? As of now, none. Only a single synchronous slave is possible. There have been

[GENERAL] Upgrading from PG 8.3.3 to 9.3.4 - FATAL: invalid value for parameter "TimeZone": "PST"

I am posting to both PG and the JDBC group since I am using JDBC to connect, so I'm not sure if this is a PG issue or a PG JDBC issue. I am upgrading from 8.3.3 to 9.3.4. I ran pg_dump on my 8.3.3 databases (which ran on CentOS 5.2, Java 6) and ran pg_restore on my 9.3.4 databases (which runs

Re: [GENERAL] Upgrading from PG 8.3.3 to 9.3.4 - FATAL: invalid value for parameter "TimeZone": "PST"

On 5/31/2014 11:41 PM, David Wall wrote: FATAL: invalid value for parameter "TimeZone": "PST" I'd be using "America/Los_Angeles" as the timezone rather than PST, as the TLA timezones are ambiguous (CST is both Central Standard Time in the USA, and China Standard Time). but thats probabl