News for hackers. Stuff that matters.
Re:Amazon RDS now supports PostgreSQL 9.4.1 by endymi0n on Thursday March 19, 2015 @07:13AM (#9231150)
So it's basically standstill? Create new instance, halt all processes, migrate the data, delete old one? Sounds sad, but if it's the only way to go, I'll go ahead. Anyone want to share experiences scriptingwise?
Re:Amazon RDS now supports PostgreSQL 9.4.1 by pyvpx on Thursday March 19, 2015 @07:24AM (#9231170)
I imagine you could use one of the various streaming replication solutions to avoid the "halt" part. pure speculation on my part, however.
Re:Amazon RDS now supports PostgreSQL 9.4.1 by jpgvm on Thursday March 19, 2015 @07:45AM (#9231236)
Alas you currently can't use RDS as either a target or source for Postgres streaming replication.

Right now the best you can do is a scheduled cutover. This isn't as bad as it sounds because you can provision the new instance, import the production data and test everything before final sync and cutover.

Re:Amazon RDS now supports PostgreSQL 9.4.1 by moe on Thursday March 19, 2015 @08:07AM (#9231312)
This isn't as bad as it sounds

As someone who has done this multiple times in the past I have to disagree.

Yes, it is very much as bad as it sounds and a big pain point with Postgresql in general and RDS in particular.

For small databases it may be considered a mere nuisance. But when your pg_dump takes an hour to complete then the whole "final sync and cutover" becomes a real problem.

Re:Amazon RDS now supports PostgreSQL 9.4.1 by pilif on Thursday March 19, 2015 @09:16AM (#9231630)
>Yes, it is very much as bad as it sounds and a big pain point with Postgresql in general and RDS in particular.

this is pretty much a problem with RDS only. Postgres itself offers pg_upgrade which can do even huge databases (2 TB here) in seconds.

Re:Amazon RDS now supports PostgreSQL 9.4.1 by moe on Thursday March 19, 2015 @10:25AM (#9232101)
pg_upgrade which can do even huge databases (2 TB here) in seconds.

That depends on various factors. Sometimes pg_upgrade has to copy all your data. In those cases and for 2T you'll be measuring the wait in hours, not seconds.

Re:Amazon RDS now supports PostgreSQL 9.4.1 by saurik on Thursday March 19, 2015 @11:32AM (#9232640)
I am under the impression that the only cases where this happens are when upgrading certain custom data types related to full-text search from 8.3 to 9.x, which seems like a very narrow complaint. This definitely used to be a serious general issue with PostgreSQL, however, but hasn't been in many years.
Re:Amazon RDS now supports PostgreSQL 9.4.1 by zwily on Thursday March 19, 2015 @09:15AM (#9231622)
You can use some of the trigger-based replication methods too, for a low-downtime migration. Read the second half of this post:

https://aws.amazon.com/blogs/aws/rds-postgres-read-replicas/