undefined | Better HN

0 pointsmrkurt3y ago0 comments

RDS will manage replicas for you. But you can't run your own non-rds replicas.

0 comments

correct. RDS does not even let you do a true, vanilla postgres backup to s3. the lock-in is complete

You can easily use pg_dump to do a "vanilla" backup to s3. Its a managed db service but if you wanted to run your own you can extract your data and move to a new db. The lock is not "complete" you are acting like you can't even extract your data.

0xCMP3y ago

i believe they're taking about being able to ship wal to s3 so the back up is close to real time.

mrkurtOP3y ago

"Only export your data with pg_dump" is one of those misfeatures that makes RDS mediocre. They don't really expose much of the power of the underlying DB.

sandGorgon3y ago

you cannot ssh to RDS machine. so u need to get another EC2 machine and pg_dump over the network. the connection breaks - yes has happened to us multiple times.

RDS makes it very inconvenient to do anything other than use their managed services.

because RDS backup data storage is VERY EXPENSIVE even compared to s3. this is very deliberate.

dikei3y ago

Using pg_dump for migration of large DB is very difficult due to the downtime it might involve.

1 more reply

j / k navigate · click thread line to collapse

0 comments

sandGorgon3y ago

correct. RDS does not even let you do a true, vanilla postgres backup to s3. the lock-in is complete

pech0rin3y ago

0xCMP3y ago

i believe they're taking about being able to ship wal to s3 so the back up is close to real time.

mrkurtOP3y ago

"Only export your data with pg_dump" is one of those misfeatures that makes RDS mediocre. They don't really expose much of the power of the underlying DB.

sandGorgon3y ago

you cannot ssh to RDS machine. so u need to get another EC2 machine and pg_dump over the network. the connection breaks - yes has happened to us multiple times.

RDS makes it very inconvenient to do anything other than use their managed services.

because RDS backup data storage is VERY EXPENSIVE even compared to s3. this is very deliberate.

dikei3y ago

Using pg_dump for migration of large DB is very difficult due to the downtime it might involve.

1 more reply

j / k navigate · click thread line to collapse