pg_restore problem

Question

I want to restore a postgres database and i have a problem.

i do this line of code pg_restore -Fd -j 2 -d template1 /var/lib/postgresql/backup.dump -h postgres-17.postgres.database.azure.com -p 5432 -U habacookplok 2> ~/errors.log => i specify the document where i have the dump database.

After i press the enter buttom i have this error /var/lib/postgresql/backup.dump/toc.dat => but i didnt specify /toc.dat

Please tell me what to change to restore ?

Answer 1

Hi, @Andrei Haba Welcome to Microsoft Q&A thanks for posting your question.

It looks like you are specifying the wrong file path for the backup file. based on the documentation i tried below commends and was able to restore successfully.

https://learn.microsoft.com/en-us/azure/postgresql/migrate/how-to-migrate-using-dump-and-restore

Can you try as below?

pg_dump -Fc -v --host=postgrestest.postgres.database.azure.com --username=yourusername --dbname=testdb -f mytest.dump

pg_restore -v --no-owner --host=postgrestest2.postgres.database.azure.com --port=5432 --username=yourusername2 --dbname=test2db mytest.dump

Regards

Geetha