From: | basti <mailinglist(at)unix-solution(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump and insert json with copy |
Date: | 2017-07-21 12:31:36 |
Message-ID: | 196a9cae-b25c-b78f-2b5f-f7a13aa981b3@unix-solution.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
i had backup my database with the following command
# schema
PGCLIENTENCODING=utf-8 pg_dump -p 5432 -s -E UTF-8 database | gzip -c
> database_schema.sql.gz
# data
PGCLIENTENCODING=utf-8 pg_dump -p 5432 -a -E UTF-8 database | gzip -c
> database_data.sql.gz
and try to restore it with
# create db
PGCLIENTENCODING=utf-8 psql -p 5432 -c "CREATE DATABASE database WITH
ENCODING 'UTF8'"
# schema
PGCLIENTENCODING=utf-8 zcat database_schema.sql.gz | psql -p 5432
database
# data
PGCLIENTENCODING=utf-8 zcat database_data.sql.gz | psql -p 5432 database
some tables has json type and show the following error at restore time:
ERROR: syntax error at or near "a"
LINE 1: a:1:{i:0;
^
ERROR: syntax error at or near "s"
LINE 1: s:1:"1";
^
ERROR: syntax error at or near "}"
LINE 1: }s:2:"x4";
^
ERROR: syntax error at or near "a"
LINE 1: a:1:{^CCancel request sent
ERROR: syntax error at or near "s"
LINE 1: s:4:"4508";
^
Is there a way to do a clean backup and restore with this json data?
best regards,
basti
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2017-07-21 12:33:27 | Re: ~/.psqlrc file is ignored |
Previous Message | Jordan Gigov | 2017-07-21 11:47:05 | pg_restore misuse or bug? |