Author: None None

first column,then row

=OFFSET($A$1,COLUMN(A1)-1+(ROW(A1)-1)*4,)

first row then column

=OFFSET($A$1,ROW(A1)-1+COLUMN(A1)*4-4,)

cat /var/opt/gitlab/gitlab-rails/etc/database.yml 

cat /etc/passwd

su - gitlab-psql

psql -h /var/opt/gitlab/postgresql -d gitlabhq_production

\l    \dt  \h   \d table_name  \di  \q

 

docker exec -t <your container name> gitlab-backup

docker exec -t <your container name> /bin/sh -c ‘umask 0077; tar cfz /secret/gitlab/backups/$(date “+etc-gitlab-\%s.tgz”) -C / etc/gitlab’

database  /var/opt/gitlab/postgresql/data

https://gitlab.com/gitlab-org/omnibus-gitlab/raw/master/docker/docker-compose.yml

web:
  image: 'gitlab/gitlab-ce:latest'
  restart: always
  hostname: 'gitlab.example.com'
  environment:
    GITLAB_OMNIBUS_CONFIG: |
      external_url 'https://gitlab.example.com'
  ports:
    - '80:80'
    - '443:443'
    - '22:22'
  volumes:
    - '/srv/gitlab/config:/etc/gitlab'
    - '/srv/gitlab/logs:/var/log/gitlab'
    - '/srv/gitlab/data:/var/opt/gitlab'

 

gitlab-ctl diff-config

docker logs -f gitlab

docker run –detach \ –hostname gitlab.example.com \ –publish 443:443 –publish 80:80 –publish 22:22 \ –name gitlab \ –restart always \ –volume $GITLAB_HOME/gitlab/config:/etc/gitlab \ –volume $GITLAB_HOME/gitlab/logs:/var/log/gitlab \ –volume $GITLAB_HOME/gitlab/data:/var/opt/gitlab \ gitlab/gitlab-ce:latest