주기적으로 DB백업을 할 수 있게 프로그램 중인데
pg_restore명령어를 사용하면 계속 에러가 나는군요
C:\Program Files\PostgreSQL\8.0\bin>pg_restore -U iceman -Ft
-d -v mydb mydb.back
pg_restore: [tar archiver] could not open TOC file for input: No
such file or directory
C:\Program Files\PostgreSQL\8.0\bin>pg_restore -U iceman -Ft
-d mydb -v mydb.back
pg_restore: connecting to database for restore
Password:
pg_restore: [archiver (db)] connection to database "mydb" failed:
FATAL: passwo
rd authentication failed for user "iceman"
pg_restore: *** aborted because of error
이렇게 password에러가 납니다.
그런데...
C:\Program Files\PostgreSQL\8.0\bin>psql -U iceman mydb
Password:
Welcome to psql 8.0.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
mydb=>
psql은 접속이 잘되는군요...
물론 backup도 잘됐었습니다.
C:\Program Files\PostgreSQL\8.0\bin>pg_dump -U iceman -Fc -f
mydb.back DDK1
Password:
이유가 뭘까요.
빨리 해결해야하는데 걱정입니다.
|