4 ms·

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 heav

by lsc 11y ago

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.

tacotuesday 11y ago
Postgres has built in replication since 9.1
- jeltz 11y ago
  Actually since 9.0, but the addition of pg_basebackup in 9.1 made creating the slave easier.
deleted 11y ago
[deleted]
simoncion 11y ago
> 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.html http://www.postgresql.org/docs/9.1/static/high-availability.... [1] http://www.postgresql.org/docs/9.4/static/high-availability.html http://www.postgresql.org/docs/9.4/static/high-availability....
- billhathaway 11y ago
  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.
- lsc 11y ago
  Sweet! thank you. that's just what I wanted.
  - simoncion 11y ago
    No problem! Good luck with your projects! :D

by lsc 11y ago

tacotuesday 11y ago

Postgres has built in replication since 9.1

jeltz 11y ago
Actually since 9.0, but the addition of pg_basebackup in 9.1 made creating the slave easier.

deleted 11y ago

[deleted]

simoncion 11y ago

> 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.html http://www.postgresql.org/docs/9.1/static/high-availability.... [1] http://www.postgresql.org/docs/9.4/static/high-availability.html http://www.postgresql.org/docs/9.4/static/high-availability....

billhathaway 11y ago
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.
lsc 11y ago
Sweet! thank you. that's just what I wanted.
- simoncion 11y ago
  No problem! Good luck with your projects! :D