0

Am backing up daily my DB with pg_dump. The strange issue is that when I try to restore it with psql, errors are thrown. After opening the dump file with vim and analyzing the line that is causing the error, it is clear that there is some C source code being written to the file. Not only one, but chunks of them.

How could this happen? Any way to avoid it?

The dump is done through the postgresql webmin module.

I'm using PostgreSQL 9.3.

Craig Ringer
57.9k6 gold badges162 silver badges193 bronze badges
asked Jan 28, 2014 at 6:45
3
  • "errors are thrown". Those errors are ....? If it's too big to paste here, include it in a pastebin link. Also show the pg_dump command line you use, exactly. If you run pg_dump directly instead of via webmin, what happens? Commented Jan 28, 2014 at 7:06
  • Just tried to dump and restore from the command line and it worked perfectly! I think it is some sort of issue with the webmin module. Commented Jan 28, 2014 at 7:20
  • Probably best post a self-answer to that effect. LMK when you do, I'll +1. Commented Jan 28, 2014 at 7:30

1 Answer 1

1

Problem solved. Apparently there is some sort of issue with the PostgreSQL webmin module.

Dumping and restoring the DB with pg_dump in command line solved the issue. Will now backup with scripts rather that using webmin.

answered Jan 28, 2014 at 7:51

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.