Posts|Comments

Tag Archives: Postgresql

New Bugzilla!

8/27/2007 – 1:36 am

So we finally wrapped up the big migration of bugzilla.redhat.com yesterday morning. We moved from an internal system (1 web, 1 db w hot spare) to one in the datacenter (multiple web and db) plus some basic code fixes. It was an epic effort with large amounts of data having to be copied [...]

By Matthew Schick | Posted in Work | Also tagged , , , | Comments (0)

Postgresql replication blows

7/17/2006 – 7:39 pm

Yup, that’s right. I said it. Postgresql replication options blow. Hardcore. To summarize the options:
pgreplication - Too old, based off PostgreSQL-6.4.2, did see a rumor on a mailing list about reviving it for 8.x
pgpool - Synchronous replication (good for data integrity, bad for performance), load balances select queries, very [...]

By Matthew Schick | Posted in Work | Also tagged , | Comments (0)