LINGCC-优快云博客

原创 PostgreSQL修改密码认证方式

[postgres@postgres_vm ~]$ psql psql (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 1815

原创 Install Grafana

[root@postgres_vm ~]# yum search grafana Last 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 195

原创 PostgreSQL - Create user & database

2020-10-25 19:50:36 532

原创配置 pg_hba.conf

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

2020-10-25 19:40:39 368

原创 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-el7 Loaded plugins: langpacks, ulninfo Resolving Dependencies --> Running transaction check ---> Package oracle-release-el7.x86_64 0:1.0-3.el7 w

2020-10-25 13:15:23 323

原创 Install ora2pg

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

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

原创 Install PostgreSQL

Install PostgreSQL Linux downloads dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm dnf -qy module disable postgresql dnf install -y postgresql12-server /usr/pgsql-12/bin/postgresql-12-se

2020-10-24 13:07:35 232

TinaYu的博客