2 postgres postgres 6 Apr 26 15:07 pg_tblspcĭrwx. 2 postgres postgres 6 Apr 26 15:07 pg_twophaseĭrwx. 1 postgres postgres 3 Apr 26 15:07 PG_VERSIONĭrwx. Uid=26(postgres) gid=26(postgres) groups=26(postgres) Use command \conninfo to get connection details. When you enter psql you will be connected to psql terminal with database: postgres and user: postgres (Here postgres=# is DBName). Perform switch user to postgres and type psql (terminal-based front-end to PostgreSQL). Login to psql: Yum command will take care of all prerequisites and once all above steps are done you will notice OS user: postgres and Binary Location: /usr/pgsql-13/bin/ and Data Directory Location: /var/lib/pgsql/13/data/ created. Process: 8402 ExecStartPre=/usr/pgsql-13/bin/postgresql-13-check-db-dir $ (code=exited, status=0/SUCCESS) Loaded: loaded (/usr/lib/systemd/system/rvice enabled vendor preset: disabled)Īctive: active (running) since Wed 15:31:11 +03 23min ago ]# systemctl enable postgresql-13Ĭreated symlink from /etc/systemd/system//rvice to /usr/lib/systemd/system/rvice. ]# /usr/pgsql-13/bin/postgresql-13-setup initdb Initialize DB and Enable Auto Restart: Follow the below steps. Package : : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Userid : "PostgreSQL RPM Building Project "įingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG Install PostgreSQL Server: Use OS command “yum” to install PostgreSQL Version 13. Pgdg-common/7Server/x86_64 PostgreSQL common RPMs for RHEL/CentOS 7Server - x86_64 386 Ol7_UEKR6/x86_64 Latest Unbreakable Enterprise Kernel Release 6 for Oracle Linux 7Server (x86_64) 208
Ol7_UEKR5/x86_64 Latest Unbreakable Enterprise Kernel Release 5 for Oracle Linux 7Server (x86_64) 245 1 root root 9738 Sep 24 18:14 pgdg-redhat-all.repo Pgdg-redhat-repo noarch 42.0-14 /pgdg-redhat-repo-latest.noarch 11 k
0 kommentar(er)
