PostgreSQL backup restore

Question

I am using Postgresql 9.5.10 for developing vehicle tracking application and taking daily backups as pg_dump Custom format. But while restoring the same it shows.

$ pg_restore -h localhost -d dbname -U user  -a tracking_data.sql
pg_restore: [compress_io] could not uncompress data: (null)

That error sounds to me like the end of file is reached while it is expecting more data. — Eelke
– Eelke, Commented Jan 1, 2019 at 7:17

dgebert · Accepted Answer · 2019-01-01 12:45:37Z

1

Use psql to restore plain SQL (like in your example) script file generated by pg_dump and pg_dumpall tools.

psql -U username --set ON_ERROR_STOP=on -f backupfile.sql

The command above is restoring a database and stops if error occurs.

pg_restore is used to restore tar file and directory format created by the pg_dump tool.

answered Jan 1, 2019 at 12:45

dgebert

1,5341 gold badge19 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL backup restore

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related