首页 > 解决方案 > 如何运行 pg_dump?它因“pg_dump: [archiver (db)] query failed: Р?РЁР?Р'”而失败

问题描述

如何获得新的转储?运行良好,但当前失败(DDL 是使用 Hibernate 生成的):

Password:
pg_dump: [archiver (db)] query failed: Р?РЁР?Р'Р?Р?:  Р?РчС' Р?Р?С?С'С?РїР° Рє С'Р°Р+Р>РёС┼Рч address
pg_dump: [archiver (db)] query was: LOCK TABLE public.address IN ACCESS SHARE MODE```
Failed on table:


CREATE TABLE public.address (
    id int8 NOT NULL,
    created_at timestamp NULL,
    updated_at timestamp NULL,
    first_line varchar(255) NULL,
    second_line varchar(255) NULL,
    created_by_id int8 NULL,
    updated_by_id int8 NULL,
    CONSTRAINT address_pkey PRIMARY KEY (id),
    CONSTRAINT uk_hc8oul9dk1w3eqvro4go5fktk UNIQUE (second_line),
    CONSTRAINT fk595v9ynufg5bhir8havm099tr FOREIGN KEY (updated_by_id) REFERENCES user_account(id),
    CONSTRAINT fke3g20g1qymd4kdkik3ub58eam FOREIGN KEY (created_by_id) REFERENCES user_account(id)
);

标签: postgresqldump

解决方案


推荐阅读