PgSQL question

Anon

I've been unable to find a satisfactory answer elsewhere, so I thought I'd ask here. PostgreSQL undoubtably has lots of advantages over MySQL (subselects, proper foreign key support, etc). But does it support replication?

[deleted]

Yes.

http://gborg.postgresql.org/project/pgreplication/projdisplay.php

Note: PostgreSQL is vastly superior to MYSQL in high-concurrency situations, which means you'll probably need a lot less computing power to do the same with PostgreSQL, making replication unneccesary.

BTW, that link is the first result when you search for 'postgresql replication' on www.google.com. Something to remember for future reference? :-)

Anon

Thanks, I'll have a read.

I didn't search google, I searched (mad of me I know) the postgres website. Which came back with only http://www.postgresql.org/idocs/index.php?release.html

Anon

So.. no built-in replication then? Hmm..

--Mike

[deleted]

Hmm what? 🙂

bfranco

ok... you can download the Replication Server from http://www.pgsql.com/download/rserv-0.1-pg7.0.tar.gz
and you can read the press release from http://www.pgsql.com

there are many projects for postgresql replication, but this one seems to be the "official" one.

May be you like mysql, maybe you like pgsql. Maybe you like linux, maybe you like *bsd.
I personaly love FreeBSD+pgsql, but it's just me.

I think that the cool thing is that we can choose what we like.