Restoring from Postgres sql file

Question

I have a backup from PostgresSQL database created this way:

/usr/bin/pg_dump --no-owner --no-acl > dump.sql

When I try to restore on a different machine:

psql db < dump.sql it trows many errors: invalid command \N

When I try to use pg_restore:

pg_restore dump.sql -d db

Different error: pg_restore: [archiver] input file appears to be a text format dump. Please use psql.

According to documentation this should be a non issue.

Any way to tell psql that \N character is a null value?

You backup use pg_dump seems weird.. There are no db you backup or even role To specify schema in db? — dwir182
– dwir182, Commented Nov 14, 2018 at 3:37

Ruslan · Accepted Answer · 2018-11-15 03:42:31Z

8

Oh hi me, it's me

Make sure:

Also eat healthy and get good rest. k bye

answered Nov 15, 2018 at 3:42

Ruslan

2,02927 silver badges44 bronze badges

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

Comments

Alisherbek · Accepted Answer · 2022-09-23 19:29:10Z

2

this may be the case if the columns in the table and the columns in the file not match

answered Sep 23, 2022 at 19:29

Alisherbek

233 bronze badges