basti writes:
> 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;
> ^
Is that really the very first error reported by the restore run?
It seems much more likely to be a failure cascading from something else.
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
