1С ошибка pg_dump: unknown alignment
Пример текста ошибки:
pg_dump: ошибка: ошибка при выполнении запроса: ОШИБКА: unknown alignment
pg_dump: подробности: Выполнялся запрос: SELECT t.tableoid,
t.oid,
i.indrelid,
t.relname AS indexname,
pg_catalog.Pg_get_indexdef(i.indexrelid) AS indexdef,
i.indkey,
t.reltype AS indtype,
i.indisclustered,
c.contype,
c.conname,
c.condeferrable,
c.condeferred,
c.tableoid AS contableoid,
c.oid AS conoid,
pg_catalog.Pg_get_constraintdef(c.oid, false) AS condef,
(
SELECT spcname
FROM pg_catalog.pg_tablespace s
WHERE s.oid = t.reltablespace) AS tablespace,
t.reloptions AS indreloptions,
i.indisreplident,
inh.inhparent AS parentidx,
i.indnkeyatts AS indnkeyatts,
i.indnatts AS indnatts,
(
SELECT pg_catalog.array_agg(attnum order BY attnum)
FROM pg_catalog.pg_attribute
WHERE attrelid = i.indexrelid
AND attstattarget >= 0) AS indstatcols,
(
SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum)
FROM pg_catalog.pg_attribute
WHERE attrelid = i.indexrelid
AND attstattarget >= 0) AS indstatvals,
i.indnullsnotdistinct
FROM unnest('{15632749,15632754,15632759,15632764,15632769,15632774,15632779,15632784,15632789,15632794,15632799,15632804,15632809,15632814,15632819,15632824,15632829,15632834,15632839,15632844,15632849...}'::pg_catalog.oid[]) AS src(tbloid)
JOIN pg_catalog.pg_index i
ON (
src.tbloid = i.indrelid)
JOIN pg_catalog.pg_class t
ON (
t.oid = i.indexrelid)
JOIN pg_catalog.pg_class t2
ON (
t2.oid = i.indrelid)
LEFT JOIN pg_catalog.pg_constraint c
ON (
i.indrelid = c.conrelid
AND i.indexrelid = c.conindid
AND c.contype IN ('p',
'u',
'x'))
LEFT JOIN pg_catalog.pg_inherits inh
ON (
inh.inhrelid = indexrelid)
WHERE (
i.indisvalid
OR t2.relkind = 'p')
AND i.indisready
ORDER BY i.indrelid,
indexname
CODE
Решением данной проблемы является выключение параметра JIT:
psql -c "ALTER SYSTEM SET jit = off;"
psql -c "SELECT pg_reload_conf();"
CODE