QingdaoU / OnlineJudgeDeploy

529 stars 364 forks source link

重新恢復sql 資料時遇到問題 #114

Closed tiruhsu closed 2 months ago

tiruhsu commented 3 months ago

螢幕快照 2024-06-28 18-28-51 執行完docker cp db_backup_xxxxxxx.sql onlinejudgedeploy_oj-postgres_1:/root docker exec -it onlinejudgedeploy_oj-postgres_1 bash 之後,遇到psql: FATAL: role "postgres" does not exis 的問題 我不知道是不是我不熟悉bash或是container拉錯了 因為原本的onlinejudgedeploy_oj-postgres_1 是寫oj-postgres

mikucat0309 commented 3 months ago

PostgreSQL 的 user 一直都是 onlinejudge,所以會是 psql -U onlinejudge

tiruhsu commented 2 months ago

感謝,原來是這樣,我會再試試看的,謝謝你