안녕하세요. 계속해서 좋은 사이트가 되기를 바라구요.
1대의 서버(a서버)에서 다른 서버(b서버)로 백업파일을 옮기는 도중에 에러가 납니다.
a서버에서 pg_dump를 이용해서 백업을 했구요.
postgres $> pg_dump kric > kric.db
백업파일(kric.db)를 b서버에 옮긴후에 복구를 했어요.
postgres $> createdb kric
postgres $> psql /d kric.db /e < kric.db
그런데, 일부만 복구가 되고, 아래와 같은 에러가 연속적으로 나옵니다.
=================================에러 메시지==================================
\! [<cmd>] // shell escape or command
\9 2000/07/27 19:06:56 10421 플라스틱 토목건자재 배수로관 >
\? // help
\a // toggle field/alignment (currently on)
\C [<captn>] // set html3 caption (currently '')
\connect <dbname|/> <user> // connect to new database (currently 'kric')
\copy table {from | to} <fname>
\d [<table>] // list tables and indices, columns in <table>, or * for all
\da // list aggregates
\dd [<object>]/ list comment for table, field, type, function, or operator.
\df // list functions
\di // list only indices
\do // list operators
\ds // list only sequences
\dS // list system tables and indexes
\dt // list only tables
\dT // list types
\e [<fname>] // edit the current query buffer or <fname>
\E [<fname>] // edit the current query buffer or <fname>, and execute
\f [<sep>] // change field separater (currently '|')
\g [<fname>] [|<cmd>] // send query to backend [and results in <fname> or pipe]
\h [<cmd>] // help on syntax of sql commands, * for all commands
\H // toggle html3 output (currently off)
\i <fname> // read and execute queries from filename
\l // list all databases
\m // toggle monitor/like table display (currently off)
\o [<fname>] [|<cmd>] // send all query results to stdout, <fname>, or pipe
\p // print the current query buffer
\q // quit
\r // reset(clear) the query buffer
\s [<fname>] // print history or save it in <fname>
\t // toggle table headings and row count (currently on)
\T [<html>] // set html3.0 <table ...> options (currently '')
\x // toggle expanded output (currently off)
\w <fname> // output current buffer to a file
\z // list current grant/revoke permissions
\! [<cmd>] // shell escape or command
Segmentation fault
==============================================================================
왜, 일부만 복구가 되고, 나머진 복구가 되지 않는 거죠?
|