Skip to content
Gallery
securelink_official_logo
SecureLink
Project
신입교육
Working Diary
TrubleShootingandTips
VMware and OS
VPN Server
RK TEST
SPK TEST
FileBridge
Untitled sync page
Share
Explore
01002024

01102024

김준성
Last edited 251 days ago by 김준성
psql 9.2.14 CLI에서 pg_dump로 db 백업하기
기존의 리눅스 버젼까지 통합해서 스크립트 만들기

고객지원

오성

결제가 변경



백업
// CMD에서
pg_dump.exe --file "C:\\backup\\0110jeantest-5.backup" --username "postgres" --password --verbose --format=c --encoding "UTF8" "alpha_smart_spk"

복원
// CMD에서
pg_restore.exe --dbname="alpha_smart_spk" --username="postgres" --password "C:\\backup\\0110jeantest-5.backup"

에러메세지
복원
2024-01-10 04:34:28 GMT ERROR: constraint "FK_USER_NOTICE_MEMBER_MEMBER" for relation "user_notice_member" already exists 2024-01-10 04:34:28 GMT STATEMENT: ALTER TABLE ONLY user_notice_member ADD CONSTRAINT "FK_USER_NOTICE_MEMBER_MEMBER" FOREIGN KEY (companyid, deptcode, userid) REFERENCES member(companyid, deptcode, userid) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE;
고객지원
오성
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.