기존 데이터 화일을 pg_dump로 itamdb.pgdump라는 화일을 생성했습니다.
그리고 아래와 같이 리스토어를 했는데..
같은... 에러 메세지들이.... ^^;
테이블 생성은 제대로 된것 같은데..
왜 같은 일을 2/3번씩 반복하면서... 에러를 내는지..
통 모르겠습니다.
고수님들의 답변을 ^^
감사합니다.
$ cat itamdb.pgdump | psql itamdb
You are now connected as new user postgres.
ERROR: Relation 'pgadmin_desc' already exists
ERROR: Relation 'pgadmin_desc' already exists
CHANGE
CHANGE
CHANGE
ERROR: Relation 'pgadmin_param' already exists
ERROR: Relation 'pgadmin_param' already exists
CHANGE
CHANGE
CHANGE
ERROR: Relation 'pgadmin_rev_log' already exists
ERROR: Relation 'pgadmin_rev_log' already exists
CHANGE
CHANGE
CHANGE
ERROR: Relation 'pgadmin_seq_cache' already exists
ERROR: Relation 'pgadmin_seq_cache' already exists
CHANGE
CHANGE
CHANGE
ERROR: Relation 'pgadmin_table_cache' already exists
ERROR: Relation 'pgadmin_table_cache' already exists
CHANGE
CHANGE
CHANGE
ERROR: Relation 'pgadmin_databases' already exists
ERROR: Relation 'pgadmin_databases' already exists
CHANGE
CHANGE
CHANGE
ERROR: Relation 'pgadmin_checks' already exists
ERROR: Relation 'pgadmin_checks' already exists
CHANGE
CHANGE
CHANGE
ERROR: Relation 'pgadmin_functions' already exists
ERROR: Relation 'pgadmin_functions' already exists
CHANGE
CHANGE
CHANGE
ERROR: Relation 'pgadmin_groups' already exists
ERROR: Relation 'pgadmin_groups' already exists
CHANGE
CHANGE
CHANGE
ERROR: Relation 'pgadmin_indexes' already exists
ERROR: Relation 'pgadmin_indexes' already exists
CHANGE
CHANGE
CHANGE
ERROR: Relation 'pgadmin_languages' already exists
ERROR: Relation 'pgadmin_languages' already exists
CHANGE
CHANGE
CHANGE
ERROR: Relation 'pgadmin_users' already exists
ERROR: Relation 'pgadmin_users' already exists
CHANGE
CHANGE
CHANGE
ERROR: Relation 'pgadmin_triggers' already exists
ERROR: Relation 'pgadmin_triggers' already exists
CHANGE
CHANGE
CHANGE
ERROR: Relation 'pgadmin_views' already exists
ERROR: Relation 'pgadmin_views' already exists
CHANGE
CHANGE
CHANGE
ERROR: ProcedureCreate: procedure pgadmin_get_desc already exists with same arguments
ERROR: ProcedureCreate: procedure pgadmin_get_desc already exists with same arguments
ERROR: ProcedureCreate: procedure pgadmin_get_pgdesc already exists with same arguments
ERROR: ProcedureCreate: procedure pgadmin_get_pgdesc already exists with same arguments
ERROR: ProcedureCreate: procedure pgadmin_get_col_def already exists with same arguments
ERROR: ProcedureCreate: procedure pgadmin_get_col_def already exists with same arguments
ERROR: ProcedureCreate: procedure pgadmin_get_handler already exists with same arguments
ERROR: ProcedureCreate: procedure pgadmin_get_handler already exists with same arguments
ERROR: ProcedureCreate: procedure pgadmin_get_type already exists with same arguments
ERROR: ProcedureCreate: procedure pgadmin_get_type already exists with same arguments
ERROR: ProcedureCreate: procedure pgadmin_get_rows already exists with same arguments
|