I am new to this.
I have php server and postgres db on a local machine. After taking a backup of localdb via pgAdmin, i tried restoring it on heroku instance with the command
heroku pg:backups restore 'GOOGLE DRIVE LINK OF DUMP FILE' HEROKU_POSTGRESQL_RED
It says restore completed and backup successful on heroku pg:backups info r024
But on the heorku instance it shows me 0 tables and also the php project does not get connected to db.