Timeline for How to configure replication from PostgreSQL (RDS) to vanilla PostgreSQL?
Current License: CC BY-SA 3.0
20 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 9, 2020 at 16:09 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 2, 2020 at 6:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 25, 2020 at 21:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 25, 2019 at 22:51 | answer | added | Neil McGuigan | timeline score: 1 | |
| Dec 25, 2019 at 10:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 14, 2019 at 10:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 15, 2019 at 18:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 15, 2018 at 10:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 24, 2018 at 16:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 16, 2018 at 13:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 12, 2018 at 8:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 12, 2018 at 6:50 | answer | added | TheDataGuy | timeline score: 0 | |
| Jul 12, 2018 at 5:56 | history | tweeted | twitter.com/StackDBAs/status/1017286538772779008 | ||
| Feb 5, 2014 at 16:23 | answer | added | Evan | timeline score: 0 | |
| Jan 29, 2014 at 13:04 | comment | added | Evan | Thanks Craig - I gave up on it and just spun up a real 9.3 Postgres EC2 instance. RDS is a nice idea but without the ability to spin up our my read-only replicas it's not an option for me right now. They have the Multi-AZ option but I don't see any way to connect to the backup instance. | |
| Jan 29, 2014 at 2:20 | comment | added | Craig Ringer | Good question - maybe they do support it and it's just woefully underdocumented. If they do I'm quite keen to hear about it, as it'll make it much easier to migrate customers out of RDS. If you get an answer, a comment here noting so would be greatly appreciated so I (and any other commenters) are notified. | |
| Jan 28, 2014 at 13:42 | comment | added | Evan |
@CraigRinger Hmm, that doesn't make any sense - why do they explicitly mention the replication privilege in the docs? From docs.aws.amazon.com/AmazonRDS/latest/UserGuide/…: "Grant and revoke the replication attribute onto all roles that are not the rds-superuser role"
|
|
| Jan 28, 2014 at 5:01 | review | First posts | |||
| Jan 28, 2014 at 10:04 | |||||
| Jan 28, 2014 at 4:44 | comment | added | Craig Ringer |
As far as I know RDS does not currently support streaming replication. You'd need a "replication" option in security groups, since that's what RDS generates pg_hba.conf from.
|
|
| Jan 28, 2014 at 4:42 | history | asked | Evan | CC BY-SA 3.0 |