Is there a way to backup and restore schema + data + user defined enums in postgresql?
有没有办法在postgresql中备份和恢复架构+数据+用户定义的枚举?
I use pgAdmin which uses pg_dump and pg_restore, i select pre data, data, post data to back up, i also select all tables. But when i restore again in an empty database with pgAdmin i get error saying the user defined enums not find. In fact the user defined enums are originally used as column types for some of my tables
我使用pgAdmin,它使用pg_dump和pg_restore,我选择预备数据,数据,发布数据备份,我也选择所有表。但是当我使用pgAdmin在空数据库中再次恢复时,我得到错误,说用户定义的枚举不能找到。事实上,用户定义的枚举最初用作我的一些表的列类型
1 个解决方案
#1
pg_dump and pg_restore should be adequate.
pg_dump和pg_restore应该足够了。