# PG database migration from Heroku not working

**URL:** <https://community.fly.io/t/pg-database-migration-from-heroku-not-working/6881>\
**Category:** Questions / Help\
**Tags:** postgres\
**Created:** [September 3, 2022, 9:18pm UTC](https://community.fly.io/t/pg-database-migration-from-heroku-not-working/6881 "2022-09-03T21:18:01Z")\
**Posts on this page:** 1\
**Showing post:** 21

<div class="post-metadata">

**Author:** ![belgoros](https://sea1.discourse-cdn.com/fly1/user_avatar/community.fly.io/belgoros/32/45321_2.png) [@belgoros](https://community.fly.io/u/belgoros)\
**Post date:** [January 13, 2023, 3:59pm UTC](https://community.fly.io/t/pg-database-migration-from-heroku-not-working/6881/21 "2023-01-13T15:59:46Z")

</div>

> [@Transferring Postgres from Heroku](https://community.fly.io/t/transferring-postgres-from-heroku/6611/14):
>
> `pg_restore -U postgres -h localhost -p 15432 -d foobar < latest.dump`

Thanks a lot for sharing!  
I followed step-by-step but the last command `pg_restore -U postgres -h localhost -p 15432 -d foobar < latest.dump` (no `;` at the end) had no effects. After checking the database tables, no data was restored at all. I ran the same dump recently on a local DB and it worked. Any clues? Thank you.

---

_[View the full topic](https://community.fly.io/t/pg-database-migration-from-heroku-not-working/6881)._