A lot of "invalid command \N" when I try to restore PostgreSQL dump
18,160
My problem was solved by setting postgresql-contrib package
sudo apt-get install postgresql-contrib
and creating extension uuid-ossp in my db
CREATE EXTENSION "uuid-ossp";
My db haven't this extension by default and psql could not execute uuid_generate_v1() function from my dump file. In most cases install postgresql-contrib is enough, but sometimes problem may be in some missed extensions too.
Author by
Andrey
Updated on June 04, 2022Comments
-
Andrey almost 2 years
I made a backup of a database on my mac and tried to restore it on a computer with ubuntu. When I execute
psql -U uname -d dbname -f ~/dump_from_mac
I have a lot of error messages like "invalid command \N" and "relation 'SomeTable' does not exist". My question is very similar with Can't copy table to another database with pg_dump but I don't know how to fix my dump file. I wipe my mac and can't make new dump.
-
Afonso Lage almost 8 yearsI had same problem. Since my backup had some extensions, solved installing postgresql-contrib
-
Linus Oleander almost 7 yearsJust running
apt-get install postgresql-contrib
solved the problem for me after loading a database dumped withpg_dumpall -c -f out
. Thanks! -
jason m almost 4 yearsThis was very annoying. Thank you, kind soul.
-
batero about 2 yearsFor all those working with containers like Docker, using
apk --update add postgresql-contrib
worked for me.