A lot of "invalid command \N" when I try to restore PostgreSQL dump

postgresql dump database-restore pg-dump
Andrey picture Andrey · Aug 3, 2015 · Viewed 14.9k times · Source

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.

Answer

Andrey picture Andrey · Aug 3, 2015

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.

Related questions

How to restore PostgreSQL dump file into Postgres databases?

I have a dump file with a .SQL extension (in fact it is a plain-text SQL file). I want to restore it into my created databases. I am using pgAdmin III, and when I use its "Restore Wizard" it does …

Read More
postgresql- restoring .dump file

I am new for psql. I got from my server data.dump file. I need to restore it in my local. I tried these commands. i) psql -U postgres dbname -f servicedb.dump Error: psql: warning: extra command-line argument "-f" …

Read More
psql invalid command \N while restore sql

I'm trying to restore my dump file, but it caused an error: psql:psit.sql:27485: invalid command \N Is there a solution? I searched, but I didn't get a clear answer.

Read More