Making postgres backups from heroku database followers

Question

Previously you used to be able to create database dumps of database followers on heroku.

heroku pgbackups:capture HEROKU_FOLLOWER_COLOR --expire

It has stopped working recently.

If I heroku logs --tail --ps pgbackups I get

2013-03-07T17:27:49+00:00 app[pgbackups]: dump_progress: start
2013-03-07T17:27:49+00:00 app[pgbackups]: pg_dump-9.2.1-64bit: [archiver (db)] query failed: ERROR:  cannot use serializable mode in a hot standby
2013-03-07T17:27:49+00:00 app[pgbackups]: HINT:  You can use REPEATABLE READ instead.
2013-03-07T17:27:49+00:00 app[pgbackups]: pg_dump-9.2.1-64bit: [archiver (db)] query was: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, READ ONLY, DEFERRABLE
2013-03-07T17:27:49+00:00 app[pgbackups]: dump_progress:    0B
2013-03-07T17:27:49+00:00 app[pgbackups]:
2013-03-07T17:27:49+00:00 app[pgbackups]: dump_progress: error

Dumping from the main DATABASE_URL seems to work fine though.

Is this a recent change in heroku platform or am I doing anything wrong? Also, is there a performance hit if I do a dump of the main database?

uhoh-itsmaciek · Accepted Answer · 2013-03-07 20:08:31Z

4

Backups from followers should be working again now. The failure was due to some changes we made to pgbackups (namely, adding the --serializable-deferrable flag for pg_dump). We missed that this wouldn't work on followers--sorry about that.

Thanks,

Maciek,

Heroku Postgres

answered Mar 7, 2013 at 20:08

uhoh-itsmaciek

1867 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Tadas T Over a year ago

What is the answer regarding performance when dumping the main database? Could you comment on that?

hgmnz Over a year ago

If you dump from the main database, it will definitely affect performance of it (more network and disk I/O, CPU, memory). Depending on your size and throughput, this may not matter at all, but it's something to keep in mind.

Ollie Bennett Over a year ago

See devcenter.heroku.com/articles/… for more details :)

Collectives™ on Stack Overflow

Making postgres backups from heroku database followers

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related