News for hackers. Stuff that matters.

A comment on What PostgreSQL has over other open source SQL databases: Part II. Parent comment

Re:What PostgreSQL has over other open source SQL databases:... by lsc on Saturday October 24, 2015 @08:26PM (#10445418)
yeah. So I haven't set up a postgres or mysql server in more than five years, but I was seriously into both before that. In the early to mid-aughts, I was heavily into PostgreSQL when I had a choice, but spent a lot of time on MySQL when other people did the deciding.

So last week I was setting up a sql server for a side project I was doing with a friend, and went with MySQL just because I knew it would take me ten minutes to setup async replication, whereas with PostgreSQL, I'd have to spend a bunch of time figuring out what third party thing to use now.

Even just having simple master/slave asynchronous replication functionality built in would help a lot.

[ Parent | on HN ]
Re:What PostgreSQL has over other open source SQL databases:... by simoncion on Saturday October 24, 2015 @09:27PM (#10445577)
> Even just having simple master/slave asynchronous replication functionality built in would help a lot.

Check out [0], or the docs on the same topic for the latest version at [1]. It looks like built-in async master/slave replication has been available since at least 2010-09-20, in Postgres 9.0.

[0] http://www.postgresql.org/docs/9.1/static/high-availability....

[1] http://www.postgresql.org/docs/9.4/static/high-availability....

[ Parent | on HN ]
Re:What PostgreSQL has over other open source SQL databases:... by billhathaway on Saturday October 24, 2015 @09:38PM (#10445606)
I've recently gotten into deploying postgres with replication and the support for async or mostly async with one "floating" synchronous replica on the current release is pretty solid.

There are some parts I'd like to see smoother like checking replication status without DB superuser creds, but the general built-in replication seems fine.

[ Parent | on HN ]
Re:What PostgreSQL has over other open source SQL databases:... by lsc on Sunday October 25, 2015 @12:37AM (#10445991)
Sweet! thank you. that's just what I wanted.
[ Parent | on HN ]
Re:What PostgreSQL has over other open source SQL databases:... by simoncion on Sunday October 25, 2015 @12:43AM (#10445996)
No problem! Good luck with your projects! :D
[ Parent | on HN ]
Re:What PostgreSQL has over other open source SQL databases:... by tacotuesday on Saturday October 24, 2015 @08:47PM (#10445473)
Postgres has built in replication since 9.1
[ Parent | on HN ]
Re:What PostgreSQL has over other open source SQL databases:... by jeltz on Saturday October 24, 2015 @09:34PM (#10445596)
Actually since 9.0, but the addition of pg_basebackup in 9.1 made creating the slave easier.
[ Parent | on HN ]