LINGCC-CSDN博客

原创 PostgreSQL修改密码认证方式

[postgres@postgres_vm ~]$ psqlpsql (12.4)Type "help" for help.postgres=# show password_encryption ; password_encryption--------------------- md5(1 row)postgres=# select * from pg_authid where rolname='hr'; oid | rolname | rolsuper | rolinherit

2020-12-21 10:20:43 1485

原创 Install Grafana

[root@postgres_vm ~]# yum search grafanaLast metadata expiration check: 3:47:10 ago on Mon 26 Oct 2020 09:06:01 PM CST.====================================== Name Exactly Matched: grafana ======================================grafana.src : Metrics dashb

2020-10-27 00:55:32 126

原创 PostgreSQL - Create user & database

2020-10-25 19:50:36 448

原创配置 pg_hba.conf

[postgres@postgres_vm ~]$ cd $PGDATA[postgres@postgres_vm data]$ pwd/var/lib/pgsql/12/data[postgres@postgres_vm data]$ lsbase pg_dynshmem pg_notify pg_stat_tmp pg_wal postmaster.pidcurrent_logfiles pg_hba.conf p

2020-10-25 19:40:39 265

原创 Install Oracle Client and DBD:Oracle

Last login: Sun Oct 25 12:58:47 2020 from 192.168.10.17[root@client_vm ~]# yum install -y oracle-release-el7Loaded plugins: langpacks, ulninfoResolving Dependencies--> Running transaction check---> Package oracle-release-el7.x86_64 0:1.0-3.el7 w

2020-10-25 13:15:23 237

原创 Install ora2pg

Commands:yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpmyum install -y oracle-release-el7/usr/bin/ol_yum_configure.shyum install -y gcc perl-devel perl-DBI perl-CPANexport LD_LI

2020-10-25 11:44:10 242 1

原创 Install PostgreSQL

Install PostgreSQLLinux downloadsdnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpmdnf -qy module disable postgresqldnf install -y postgresql12-server/usr/pgsql-12/bin/postgresql-12-se

2020-10-24 13:07:35 147

TinaYu的博客