Pg_restore input file does

Have you selected it when doing the restore? Add a comment. Active Oldest Votes. Improve this answer. Amjad Shahzad Amjad Shahzad 3 3 silver badges 12 12 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Ricky Sixx. Ricky Sixx Ricky Sixx 1 1 silver badge 8 8 bronze badges.

How is this backup taken? Maybe that. What do you see with head postgresql-dump I've found some invalid characters in that file, but I don't know if it means that the file is corrupted or that it's not a plain-text format Add a comment.

Active Oldest Votes. I'll post an answer because it might be useful to someone else. Improve this answer. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Asked 11 years, 7 months ago. Active 5 months ago. Viewed k times. Improve this question. Try importing the dump on the same machine that generated it. Also, check the Postgres versions.

I can't try importing it on the same machine, because it's a production machine. Any idea, what else I can do? This solution may also be relevant to some people: stackoverflow.

Add a comment. Active Oldest Votes. Improve this answer. Yuri 6 6 bronze badges. Peter Tillemans Peter Tillemans 1, 1 1 gold badge 9 9 silver badges 7 7 bronze badges. But "most flexible" does not necessarily means "most recommended". Would whoever modded this down like to explain why? The accepted answer explains that this will work :- — psmears. Maybe your file is corrupt somehow?

Or you have hit a particular bug?