2019.08.20. 기준 문서

$ gitlab-rake gitlab:backup:create RAILS_ENV=production

pg_dump: aborting because of server version mismatch

[FAILED]

rake aborted!

/# postgres --version

postgres (PostgreSQL) 9.6.11

root@8256e59e3eae:/# /opt/gitlab/embedded/bin/pg_dump --version

pg_dump (PostgreSQL) 9.6.11

1. 서버에 가서 $find / -name pg_dump 명령어로 pg_dump 실행파일을 찾음

2. 해당 파일을 gitlab 서버에 복사, 위치는 대략 /opt/gitlab/embedded/postgresql/{version}/bin

3. 복사한 실행파일을 심볼릭 링크로 /opt/gitlab/embedded/bin 안에 넣어줌

Dumping PostgreSQL database gitlab

...

pg_dump: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

"We recommend that you first upgrade to the latest available minor version within your major version. By doing this, you can address any deprecation messages that could change behavior in the next major release."

"It is considered safe to jump between patch versions and minor versions within one major version."

from:https://stackoverflow.com/questions/54993966/do-i-have-to-update-gitlab-through-each-minor-version

==> /var/log/gitlab/gitlab-rails/production.log <==

Started GET "/hslee/test-k8s-cicd/-/settings/ci_cd" for 172.18.0.1 at 2019-08-20 02:18:16 +0000

Processing by Projects::Settings::CiCdController#show as HTML

Parameters: {"namespace_id"=>"hslee", "project_id"=>"test-k8s-cicd"}

Completed 500 Internal Server Error in 315ms (ActiveRecord: 58.6ms)

ActionView::Template::Error ():

25: project_clusters_path(@project),

26: class: 'btn btn-info'

27: %hr

28: = render partial: 'ci/runner/how_to_setup_runner',

29: locals: { registration_token: @project.runners_token,

30: type: 'specific',

31: reset_token_url: reset_registration_token_namespace_project_settings_ci_cd_ path }

lib/gitlab/crypto_helper.rb:27:in `aes256_gcm_decrypt'

app/models/concerns/token_authenticatable_strategies/encrypted.rb:45:in `get_token'

app/models/concerns/token_authenticatable_strategies/base.rb:33:in `ensure_token!'

app/models/concerns/token_authenticatable.rb:45:in `block in add_authentication_token_field'

app/models/project.rb:1590:in `runners_token'

app/views/projects/runners/_specific_runners.html.haml:28:in `_app_views_projects_runners__specific_runn ers_html_haml___4200129141666358982_69883394124780'

....(중략)....

==> /var/log/gitlab/gitlab-rails/production_json.log <==

{"method":"GET","path":"blarblar","format":"html","controller":"Projects::S ettings::CiCdController","action":"show","status":500,"error":"ActionView::Template::Error: ","duration" :315.46,"view":0.0,"db":58.61,"time":"2019-08-20T02:18:17.333Z","params":[{"key":"namespace_id","value": "hslee"},{"key":"project_id","value":"blarblar"}],"remote_ip":"172.18.0.1","user_id":17,"username": "blarblar","ua":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75 .0.3770.142 Safari/537.36","queue_duration":15.8,"gitaly_calls":1,"gitaly_duration":20.4,"correlation_id ":"blarblar"}

docker exec -it gitlab gitlab-rake db:migrate:status

#... 결과가 on 이 아니라면, ---

docker exec -it gitlab gitlab-rake db:migrate

-- db server 접속

su - postgres

psql -d postgres -U postgres

-- db 리스트 확인

postgres=# \l

List of databases

Name | Owner | Encoding | Collate | Ctype | Access privileges

-----------+----------+----------+---------+-------+-----------------------

gitlab | postgres | UTF8 | C | C | =Tc/postgres +

| | | | | postgres=CTc/postgres+

| | | | | gitlab=CTc/postgres

-- db 사용 선택

postgres=# \c gitlab

You are now connected to database "gitlab" as user "postgres".

-- db 내 프로젝트 테이블 정보 확인

gitlab=# \dti projects

List of relations

Schema | Name | Type | Owner | Table

--------+----------+-------+--------+-------

public | projects | table | gitlab |

(1 row)

-- 프로젝트 테이블 조회

gitlab=# select * from projects;