CODEWITHSUNDEEP
herokuheroku-postgres
Alvin Lau
Alvin Lau

Reputation: 101

Heroku pg:copy not all rows copied?

I just upgraded my Postgres DB on Heroku and used pg:copy to copy everything. However in my original DB it shows there was ~32,000 rows and in the new one there are ~28,000 rows. Does this mean some rows weren't copied or is this common ?

Upvotes: 2

Views: 536

Answers (1)

RangerRanger
RangerRanger

Reputation: 2493

The variance in row counts can be attributed to stale data, table bloat, or both. pg:copy uses pg_dump and pg_restore under the hood. If pg:copy completed without errors you can rest assured that data was not lost in transit.

Upvotes: 4

Related Questions