DataBase/PostgreSQL2 PostgreSql DataBase Backup and Restore Backup su - postgres pg_dump db이름 > 폴더/백업파일 백업파일 다운로드 Restore dropdb -U postgres db이름 createdb -U postgres -E 인코딩 db이름 psql -U postgres db이름 \i 백업파일명 2009. 11. 23. “FATAL: Ident authentication failed”, or how cool ideas get bad usage schemas /etc/postgresql/8.3/main/pg_hba.conf 설정 # "local" is for Unix domain socket connections only #local all all ident sameuser local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: #host all all ::1/128 md5 # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD host all all 192.168.123.102 255.255.255.0 trust ever seen one of those? i mean the “fatal: ident .. 2009. 5. 7. 이전 1 다음