[GENERAL] pg_dump and insert json with copy
От | basti |
---|---|
Тема | [GENERAL] pg_dump and insert json with copy |
Дата | |
Msg-id | 196a9cae-b25c-b78f-2b5f-f7a13aa981b3@unix-solution.de обсуждение исходный текст |
Ответы |
Re: [GENERAL] pg_dump and insert json with copy
|
Список | 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
В списке pgsql-general по дате отправления: