访问GitLab的PostgreSQL数据库
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了访问GitLab的PostgreSQL数据库，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含8820字，纯文字阅读大概需要13分钟。
内容图文
1.登陆gitlab的安装服务查看配置文件
[root@node06 ~]# cat /var/opt/gitlab/gitlab-rails/etc/database.yml
# This file is managed by gitlab-ctl. Manual changes will be
# erased! To change the contents below, edit /etc/gitlab/gitlab.rb
# and run `sudo gitlab-ctl reconfigure`.
production:
adapter: postgresql
encoding: unicode
collation:
database: gitlabhq_production //数据库名
pool: 10
username: "gitlab" //用户名
password:
host: "/var/opt/gitlab/postgresql" //主机
port: 5432
socket:
sslmode:
sslrootcert:
sslca:
load_balancing: {"hosts":[]}
prepared_statements: false
statements_limit: 1000
fdw:
[root@node06 ~]#
查看/etc/passwd文件，确定gitlab对应的系统用户
[root@node06 ~]# cat /etc/passwd
gitlab-www:x:498:498::/var/opt/gitlab/nginx:/bin/false
git:x:497:497::/var/opt/gitlab:/bin/sh
gitlab-redis:x:496:496::/var/opt/gitlab/redis:/bin/false
gitlab-psql:x:495:495::/var/opt/gitlab/postgresql:/bin/sh //gitlab的postgresql用户
2、根据查询出的配置信息登陆postgresql数据库
[root@node06 ~]# su - gitlab-psql //登陆用户
-sh-4.1$ psql -h /var/opt/gitlab/postgresql -d gitlabhq_production
//连接到gitlabhq_production库
psql (9.6.8)
Type "help" for help.
gitlabhq_production=# \h //查看帮助命令
Available help:
ABORT ALTER TYPE CREATE RULE DROP GROUP LOAD
ALTER AGGREGATE ALTER USER CREATE SCHEMA DROP INDEX LOCK
ALTER COLLATION ALTER USER MAPPING CREATE SEQUENCE DROP LANGUAGE MOVE
ALTER CONVERSION ALTER VIEW CREATE SERVER DROP MATERIALIZED VIEW NOTIFY
ALTER DATABASE ANALYZE CREATE TABLE DROP OPERATOR PREPARE
ALTER DEFAULT PRIVILEGES BEGIN CREATE TABLE AS DROP OPERATOR CLASS PREPARE TRANSACTION
ALTER DOMAIN CHECKPOINT CREATE TABLESPACE DROP OPERATOR FAMILY REASSIGN OWNED
ALTER EVENT TRIGGER CLOSE CREATE TEXT SEARCH CONFIGURATION DROP OWNED REFRESH MATERIALIZED VIEW
gitlabhq_production-# \l //查看数据库
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
---------------------+-------------+----------+-------------+-------------+---------------------------------
gitlabhq_production | gitlab | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | gitlab-psql | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | gitlab-psql | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/"gitlab-psql" +
| | | | | "gitlab-psql"=CTc/"gitlab-psql"
template1 | gitlab-psql | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/"gitlab-psql" +
| | | | | "gitlab-psql"=CTc/"gitlab-psql"
(4 rows)
gitlabhq_production-# \dt //查看多表
List of relations
Schema | Name | Type | Owner
--------+------------------------------------------+-------+--------
public | abuse_reports | table | gitlab
public | appearances | table | gitlab
public | application_setting_terms | table | gitlab
public | application_settings | table | gitlab
public | audit_events | table | gitlab
public | award_emoji | table | gitlab
public | badges | table | gitlab
public | boards | table | gitlab
public | broadcast_messages | table | gitlab
public | chat_names | table | gitlab
public | chat_teams | table | gitlab
public | ci_build_trace_chunks | table | gitlab
public | ci_build_trace_section_names | table | gitlab
public | ci_build_trace_sections | table | gitlab
public | ci_builds | table | gitlab
public | ci_builds_metadata | table | gitlab
public | ci_group_variables | table | gitlab
public | ci_job_artifacts | table | gitlab
public | ci_pipeline_schedule_variables | table | gitlab
public | ci_pipeline_schedules | table | gitlab
public | ci_pipeline_variables | table | gitlab
public | ci_pipelines | table | gitlab
public | ci_runner_namespaces | table | gitlab
public | ci_runner_projects | table | gitlab
public | ci_runners | table | gitlab
public | ci_stages | table | gitlab
public | ci_trigger_requests | table | gitlab
public | ci_triggers | table | gitlab
public | ci_variables | table | gitlab
public | cluster_platforms_kubernetes | table | gitlab
public | cluster_projects | table | gitlab
public | cluster_providers_gcp | table | gitlab
public | clusters | table | gitlab
public | clusters_applications_helm | table | gitlab
public | clusters_applications_ingress | table | gitlab
public | clusters_applications_prometheus | table | gitlab
public | clusters_applications_runners | table | gitlab
public | container_repositories | table | gitlab
public | conversational_development_index_metrics | table | gitlab
public | deploy_keys_projects | table | gitlab
gitlabhq_production-# \d abuse_reports //查看表结构
Table "public.abuse_reports"
Column | Type | Modifiers
-------------------------+-----------------------------+------------------------------------------------------------
id | integer | not null default nextval('abuse_reports_id_seq'::regclass)
reporter_id | integer |
user_id | integer |
message | text |
created_at | timestamp without time zone |
updated_at | timestamp without time zone |
message_html | text |
cached_markdown_version | integer |
Indexes:
"abuse_reports_pkey" PRIMARY KEY, btree (id)
gitlabhq_production-# \di \\查看索引
List of relations
Schema | Name | Type | Owner | Table
--------+-----------------------------------------------------------------+-------+--------+------------------------------------------
public | abuse_reports_pkey | index | gitlab | abuse_reports
public | appearances_pkey | index | gitlab | appearances
public | application_setting_terms_pkey | index | gitlab | application_setting_terms
public | application_settings_pkey | index | gitlab | application_settings
public | audit_events_pkey | index | gitlab | audit_events
public | award_emoji_pkey | index | gitlab | award_emoji
public | badges_pkey | index | gitlab | badges
public | boards_pkey | index | gitlab | boards
gitlabhq_production=# SELECT spcname FROM pg_tablespace; //查看表空间
spcname
------------
pg_default
pg_global
(2 rows)
gitlabhq_production=# \q //退出psql
-sh-4.1$ exit //退出登陆用户
logout
[root@node06 ~]#
内容总结
以上是互联网集市为您收集整理的访问GitLab的PostgreSQL数据库全部内容，希望文章能够帮你解决访问GitLab的PostgreSQL数据库所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。