0

I have a .backup dump from a single table, but it didn't work restore like a normal backup from an entire db. I'm creating this backup file with the following batch script bin\pg_dump -h localhost -p 5432 -U postgres -F c -b -v -f %BACKUP_FILE% --table <schema.table-name> <db-name> And i'm restoring it with the pgadmin restore option, i didn't get any error message, the restore run normally, but the table don't show on my db/schema.

  • That you chose to name the file with a ".backup" extension doesn't tell us anything. How did you create it? What command did you use to restore it? What error did you get? – jjanes Oct 15 at 22:07
  • I edited the question putting the information that was missing on it. – lucazpinheiro Oct 16 at 16:58
  • I din't named the bakcup file ".backup", it was the extension that file was saved. – lucazpinheiro Oct 16 at 17:11
  • pgadmin3 or pgadmin4? – jjanes Oct 16 at 17:30
  • "pg_dump" follows the Linux philosophy, not Windows. It doesn't add suffixes, so .backup must have already been included in '%BACKUP_FILE%', however it got there. – jjanes Oct 16 at 17:32
0

I am not sure what you tried so far, please post error message for better understanding,

Try below and post a comment if this works for you or not.

you can use pg_restore to restore a single table :

pg_restore -t my_table -d database_name database.dump

If the dump is not too big, the easiest thing to do is restore the full backup to a temporary database (gzcat backup_file.gz | psql -h host -U user database_name) dump the one table (pg_dump -t my_table), then restore it.

  • I did run the first script, but it ask for a password when the db where i was tryingto restore the table dons't has a password. – lucazpinheiro Oct 16 at 17:33
0

The problem was that i was trying to restore a postgis table on a db which did not have the postgis extension. Was just a matter of running the command CREATE EXTENSION postgis; on the query tool.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.