PostgreSQL 9.0 Final Release Available Now

It's a free upgrade from warm standby, whereas SR requires a little more configuration. A good SR cluster also requires that log archiving (warm/hot standby) be set up in case the stream gets behind, otherwise you're at the mercy of whatever happens to be in the master's xlog.

Re: PostgreSQL 9.0 Final Release Available Now

#6

Post by ghotli » Mon, Sep 20, 2010, 3:16 PM UTC

Has anyone been using PostGIS with the RCs? Is it stable and ready for production?

Re: PostgreSQL 9.0 Final Release Available Now

#7

Post by crad » Mon, Sep 20, 2010, 3:19 PM UTC

epi0Bauqu wrote: post #4

Why use hot-standby over streaming replication or visa-versa?

Hot-Standby: Ability to query against what used to be Warm-Standby boxes which were for disaster recovery only. Streaming Replication: sending log data over sockets instead of relying on shell commands to send logfiles over.

They work together to make for happy master-slave replication.

It's worth noting this is database server level. Hot-standby copies 100% of a PostgreSQL instance. If you want to replicate individual databases on a server or individual tables in a database, Longdiste, Bucardo or Slony are still the way to go.

Re: PostgreSQL 9.0 Final Release Available Now

#8

Post by siglesias » Mon, Sep 20, 2010, 3:59 PM UTC

Can anybody point to a good discussion about the strengths and weaknesses of PostgreSQL relative to MySQL? Or can you weigh in briefly about the tradeoffs between the two?

EDIT: Okay, must've touched a few nerves there. Sorry. Question was asked in earnest.

Re: PostgreSQL 9.0 Final Release Available Now

#9

Post by jacquesm » Mon, Sep 20, 2010, 4:09 PM UTC

siglesias wrote: post #8

Can anybody point to a good discussion about the strengths and weaknesses of PostgreSQL relative to MySQL? Or can you weigh in briefly about the tradeoffs between the two? EDIT: Okay, must've touched a few nerves there. Sorry. Question was asked in earnest.

Of all the flamewar subjects, I think that one is just about the most tried and true one.

Re: PostgreSQL 9.0 Final Release Available Now

#10

Post by siglesias » Mon, Sep 20, 2010, 4:15 PM UTC

jacquesm wrote: post #9

siglesias wrote: post #8

Can anybody point to a good discussion about the strengths and weaknesses of PostgreSQL relative to MySQL? Or can you weigh in briefly about the tradeoffs between the two? EDIT: Okay, must've touched a few nerves there. Sorry. Question was asked in earnest.

Of all the flamewar subjects, I think that one is just about the most tried and true one.

I wasn't trying to start a flamewar! I'm just coding up my first major project and needed help deciding, specifically which one plays better with django.