In dit artikel wordt beschreven hoe postgreSQl 16 te installeren op Virtualbox m.b.v. Vagrant. Installatie van Vagrant en Virtualbox wordt niet beschreven.
https://github.com/oracle/vagrant-projectsOracle heeft op github repository https://github.com/oracle/vagrant-projects met hierin verschillende Vagrant projecten in beheer. Clone deze repo in een directory.
rgeil@AGEOS_XPS152 MINGW64 /d/projects
$ git clone https://github.com/oracle/vagrant-projects
Cloning into 'vagrant-projects'...
remote: Enumerating objects: 3179, done.
remote: Counting objects: 100% (610/610), done.
remote: Compressing objects: 100% (309/309), done.
remote: Total 3179 (delta 313), reused 519 (delta 271), pack-reused 2569
Receiving objects: 100% (3179/3179), 1.54 MiB | 4.10 MiB/s, done.
Resolving deltas: 100% (1860/1860), done.
Ga naar de directory waar de Vagrantfile voor het aanmaken van de virtual machine staat. In dit artikel is dat /vagrant-projects/OracleLinux/8.
rgeil@AGEOS_XPS152 MINGW64 /d/projects
$ cd vagrant-projects
rgeil@AGEOS_XPS152 MINGW64 /d/projects/vagrant-projects (main)
$ ls -lt
total 29
-rw-r--r-- 1 rgeil 197609 5449 Feb 28 09:28 THIRD_PARTY_LICENSES.txt
-rw-r--r-- 1 rgeil 197609 3404 Feb 28 09:28 README.md
-rw-r--r-- 1 rgeil 197609 1775 Feb 28 09:28 SECURITY.md
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 OracleRAC/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 OracleLinux/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 OracleGoldenGate/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 OracleFPP/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 OracleDatabase/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 OracleDG/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 OracleAPEX/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 Ocr-Yum-Mirror/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 OCNE/
-rw-r--r-- 1 rgeil 197609 1874 Feb 28 09:28 LICENSE.txt
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 LAMP/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 DockerEngine/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 ContainerTools/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 ContainerRegistry/
-rw-r--r-- 1 rgeil 197609 2205 Feb 28 09:28 CONTRIBUTING.md
-rw-r--r-- 1 rgeil 197609 356 Feb 28 09:28 CODEOWNERS
rgeil@AGEOS_XPS152 MINGW64 /d/projects/vagrant-projects (main)
$ cd OracleLinux
rgeil@AGEOS_XPS152 MINGW64 /d/projects/vagrant-projects/OracleLinux (main)
$ ls -l
total 1
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 6/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 7/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 8/
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 9/
-rw-r--r-- 1 rgeil 197609 671 Feb 28 09:28 README.md
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 preview/
rgeil@AGEOS_XPS152 MINGW64 /d/projects/vagrant-projects/OracleLinux (main)
$ cd 8
rgeil@AGEOS_XPS152 MINGW64 /d/projects/vagrant-projects/OracleLinux/8 (main)
$ ls -ltr
total 12
-rw-r--r-- 1 rgeil 197609 3564 Feb 28 09:28 README.md
-rw-r--r-- 1 rgeil 197609 4567 Feb 28 09:28 Vagrantfile
drwxr-xr-x 1 rgeil 197609 0 Feb 28 09:28 scripts/
Gebuik vagrant up om de virtual machine aan te maken
$ vagrant up
==> vagrant: Getting Proxy Configuration from Host...
Bringing machine 'ol8-vagrant' up with 'virtualbox' provider...
==> ol8-vagrant: Box 'oraclelinux/8' could not be found. Attempting to find and install...
ol8-vagrant: Box Provider: virtualbox
ol8-vagrant: Box Version: >= 0
==> ol8-vagrant: Loading metadata for box 'https://oracle.github.io/vagrant-projects/boxes/oraclelinux/8.json'
ol8-vagrant: URL: https://oracle.github.io/vagrant-projects/boxes/oraclelinux/8.json
==> ol8-vagrant: Adding box 'oraclelinux/8' (v8.9.511) for provider: virtualbox
ol8-vagrant: Downloading: https://yum.oracle.com/boxes/oraclelinux/ol8/OL8U9_x86_64-vagrant-virtualbox-b511.box
ol8-vagrant:
ol8-vagrant: Calculating and comparing box checksum...
==> ol8-vagrant: Successfully added box 'oraclelinux/8' (v8.9.511) for 'virtualbox'!
.
.
.
.
ol8-vagrant: INSTALLER: Installation complete, Oracle Linux 8 ready to use!De volledige logging is te vinden via: https://drive.google.com/file/d/1Lx_qOUEnCV9dX4WisaaKS0dkOAdkAE3s/view?usp=drive_link
Standaard komt een Vagrant Virtualbox met alleen een NAT network interface. Dit geldt ook voor de oracleLinux Vbox. Om de virtual machine ook vanaf je netwerk te kunnen bereiken moeten er een aantal extra stappen ondernomen worden.
In de Vagrantfile voor de laatste end wordt onderstaande regel toegevoegd. Deze regel zorgt voor het aanmaken van een 2e netwerk adapter van het type Bridged met dhcp toewijzing ip-adres etc..
config.vm.network "public_network"Als je een ‘static’ ip adres wilt toekennen aan de Bridged network adapter kan dit met onderstaande regel. Let op dat je dan het ip-adres voor dateway en dns server nodig hebt.
config.vm.network "public_network", bridge: "eth1", ip: "192.168.178.38", netmask: "255.255.255.0", gateway: "192.168.178.1", dns: "192.168.178.1"
Een zgn. host_only network adapter kan je ook toevoegen met een static ip-adres.
config.vm.network "private_network", ip: "192.168.56.158"Hierna moet de configuratie van de Vagrant virtual box opnieuw geladen worden met vagrant reload.
rgeil@AGEOS_XPS152 MINGW64 /d/projects/vagrant-projects/OracleLinux/8 (main)
$ vagrant reload
==> vagrant: Getting Proxy Configuration from Host...
==> ol8-vagrant: Attempting graceful shutdown of VM...
==> ol8-vagrant: Checking if box 'oraclelinux/8' version '8.9.511' is up to date...
==> ol8-vagrant: Clearing any previously set forwarded ports...
==> ol8-vagrant: Clearing any previously set network interfaces...
==> ol8-vagrant: Preparing network interfaces based on configuration...
ol8-vagrant: Adapter 1: nat
ol8-vagrant: Adapter 2: bridged
==> ol8-vagrant: Forwarding ports...
ol8-vagrant: 22 (guest) => 2222 (host) (adapter 1)
==> ol8-vagrant: Running 'pre-boot' VM customizations...
==> ol8-vagrant: Booting VM...
==> ol8-vagrant: Waiting for machine to boot. This may take a few minutes...
ol8-vagrant: SSH address: 127.0.0.1:2222
ol8-vagrant: SSH username: vagrant
ol8-vagrant: SSH auth method: private key
==> ol8-vagrant: Machine booted and ready!
==> ol8-vagrant: Checking for guest additions in VM...
==> ol8-vagrant: Setting hostname...
==> ol8-vagrant: Configuring and enabling network interfaces...
==> ol8-vagrant: Configuring proxy environment variables...
==> ol8-vagrant: Configuring proxy for Yum...
==> ol8-vagrant: Mounting shared folders...
ol8-vagrant: /vagrant => D:/projects/vagrant-projects/OracleLinux/8
==> ol8-vagrant: Machine already provisioned. Run `vagrant provision` or use the `--provision`
==> ol8-vagrant: flag to force provisioning. Provisioners marked to run always will still run.
rgeil@AGEOS_XPS152 MINGW64 /d/projects/vagrant-projects/OracleLinux/8 (main)Gebruik vagrant ssh om ‘in’ de virtual machine te gaan en je ziet dat netwerkadapter eth1 is toegevoegd met een ip (192.168.178.165/24) die vanuit je netwerk bereikbaar is.
rgeil@AGEOS_XPS152 MINGW64 /d/projects/vagrant-projects/OracleLinux/8 (main)
$ vagrant ssh
==> vagrant: Getting Proxy Configuration from Host...
Welcome to Oracle Linux Server release 8.9 (GNU/Linux 5.15.0-200.131.27.el8uek.x86_64)
The Oracle Linux End-User License Agreement can be viewed here:
* /usr/share/eula/eula.en_US
For additional packages, updates, documentation and community help, see:
* https://yum.oracle.com/
[vagrant@ol8-vagrant ~]$ ip a
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 1000
link/ether 08:00:27:af:71:95 brd ff:ff:ff:ff:ff:ff
altname enp0s3
inet 10.0.2.15/24 brd 10.0.2.255 scope global dynamic noprefixroute eth0
valid_lft 86313sec preferred_lft 86313sec
inet6 fe80::a00:27ff:feaf:7195/64 scope link
valid_lft forever preferred_lft forever
3: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 1000
link/ether 08:00:27:67:57:94 brd ff:ff:ff:ff:ff:ff
altname enp0s8
inet 192.168.178.165/24 brd 192.168.178.255 scope global dynamic noprefixroute eth1
valid_lft 863913sec preferred_lft 863913sec
inet6 fe80::a00:27ff:fe67:5794/64 scope link
valid_lft forever preferred_lft forever
[vagrant@ol8-vagrant ~]$ sudo su - sshd_configNu moet de /etc/ssh/sshd_config worden aangepast om m.b.v. een password te kunnen aanloggen, want dit is standaard niet mogelijk in de virtual machine die m.b.v. de oracle Vagrantfile aangmaakt is. De waarde van PasswordAuthentication moet yes worden.
# To disable tunneled clear text passwords, change to no here!
PasswordAuthentication yes
#PermitEmptyPasswords no
Als laatste stap moet systemctl reload service sshd uitgevoerd worden om de aangepaste configuratie te laden.
[root@ol8-vagrant ~]# systemctl reload service sshd
Failed to reload service.service: Unit service.service not found.
[root@ol8-vagrant ~]# systemctl reload sshd
[root@ol8-vagrant ~]# systemctl status sshd
● sshd.service - OpenSSH server daemon
Loaded: loaded (/usr/lib/systemd/system/sshd.service; enabled; vendor preset: enabled)
Active: active (running) since Wed 2024-02-28 14:57:50 UTC; 6min ago
Docs: man:sshd(8)
man:sshd_config(5)
Process: 10835 ExecReload=/bin/kill -HUP $MAINPID (code=exited, status=0/SUCCESS)
Main PID: 886 (sshd)
Tasks: 1 (limit: 12209)
Memory: 5.8M
CGroup: /system.slice/sshd.service
└─886 /usr/sbin/sshd -D -u0 -oCiphers=aes256-gcm@openssh.com,chacha20-poly1305@openssh.com,aes256-ctr,aes256-cbc,aes128-gcm@openssh.com,aes128-ctr,aes128-cbc -oMACs=hmac-sha2-256-etm@openssh.com,hmac-sha1-etm@openssh.com,umac-128-etm@openssh.com,hmac-sha2-512-etm@openssh.com,h>
Feb 28 15:03:43 ol8-vagrant systemd[1]: Reloading OpenSSH server daemon.
Feb 28 15:03:43 ol8-vagrant sshd[886]: Received SIGHUP; restarting.
Feb 28 15:03:43 ol8-vagrant systemd[1]: Reloaded OpenSSH server daemon.
Feb 28 15:03:43 ol8-vagrant sshd[886]: Server listening on 0.0.0.0 port 22.
Feb 28 15:03:43 ol8-vagrant sshd[886]: Server listening on :: port 22.
Feb 28 15:03:53 ol8-vagrant systemd[1]: Reloading OpenSSH server daemon.
Feb 28 15:03:53 ol8-vagrant sshd[886]: Received SIGHUP; restarting.
Feb 28 15:03:53 ol8-vagrant systemd[1]: Reloaded OpenSSH server daemon.
Feb 28 15:03:53 ol8-vagrant sshd[886]: Server listening on 0.0.0.0 port 22.
Feb 28 15:03:53 ol8-vagrant sshd[886]: Server listening on :: port 22.
lines 1-22/22 (END)Gebruik vagrant ssh om als user vagrant in te loggen in de virtual machine ol8-vagrant.
$ vagrant ssh
==> vagrant: Getting Proxy Configuration from Host...
Welcome to Oracle Linux Server release 8.9 (GNU/Linux 5.15.0-200.131.27.el8uek.x86_64)
The Oracle Linux End-User License Agreement can be viewed here:
* /usr/share/eula/eula.en_US
For additional packages, updates, documentation and community help, see:
* https://yum.oracle.com/
[vagrant@ol8-vagrant ~]$ hostname
ol8-vagrant
Op de officiële postgresql site https://www.postgresql.org/download/linux/redhat/ wordt het volgende vermeld:
# Install the repository RPM:
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# Disable the built-in PostgreSQL module:
sudo dnf -qy module disable postgresql
# Install PostgreSQL:
sudo dnf install -y postgresql16-server
# Optionally initialize the database and enable automatic start:
sudo /usr/pgsql-16/bin/postgresql-16-setup initdb
sudo systemctl enable postgresql-16
sudo systemctl start postgresql-16De output hiervan geeft:
[vagrant@ol8-vagrant ~]$ sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Last metadata expiration check: 0:13:03 ago on Wed 28 Feb 2024 01:13:16 PM UTC.
pgdg-redhat-repo-latest.noarch.rpm 21 kB/s | 14 kB 00:00
Dependencies resolved.
=============================================================================================================================================
Package Architecture Version Repository Size
=============================================================================================================================================
Installing:
pgdg-redhat-repo noarch 42.0-38PGDG @commandline 14 k
Transaction Summary
=============================================================================================================================================
Install 1 Package
Total size: 14 k
Installed size: 15 k
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : pgdg-redhat-repo-42.0-38PGDG.noarch 1/1
Verifying : pgdg-redhat-repo-42.0-38PGDG.noarch 1/1
Installed:
pgdg-redhat-repo-42.0-38PGDG.noarch
Complete!
[vagrant@ol8-vagrant ~]$ sudo dnf -qy module disable postgresql
Importing GPG key 0x08B40D20:
Userid : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
From : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
Importing GPG key 0x08B40D20:
Userid : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
From : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
Importing GPG key 0x08B40D20:
Userid : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
From : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
Importing GPG key 0x08B40D20:
Userid : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
From : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
Importing GPG key 0x08B40D20:
Userid : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
From : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
Importing GPG key 0x08B40D20:
Userid : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
From : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
[vagrant@ol8-vagrant ~]$ sudo dnf install -y postgresql16-server
Last metadata expiration check: 0:09:01 ago on Wed 28 Feb 2024 10:25:10 AM UTC.
Dependencies resolved.
================================================================================================
Package Architecture Version Repository Size
================================================================================================
Installing:
postgresql16-server x86_64 16.2-1PGDG.rhel8 pgdg16 6.7 M
Installing dependencies:
lz4 x86_64 1.8.3-3.el8_4 ol8_baseos_latest 103 k
postgresql16 x86_64 16.2-1PGDG.rhel8 pgdg16 1.9 M
postgresql16-libs x86_64 16.2-1PGDG.rhel8 pgdg16 328 k
Transaction Summary
================================================================================================
Install 4 Packages
Total download size: 9.0 M
Installed size: 39 M
Downloading Packages:
(1/4): lz4-1.8.3-3.el8_4.x86_64.rpm 1.2 MB/s | 103 kB 00:00
(2/4): postgresql16-libs-16.2-1PGDG.rhel8.x86_64.rpm 352 kB/s | 328 kB 00:00
(3/4): postgresql16-16.2-1PGDG.rhel8.x86_64.rpm 834 kB/s | 1.9 MB 00:02
(4/4): postgresql16-server-16.2-1PGDG.rhel8.x86_64.rpm 1.4 MB/s | 6.7 MB 00:04
------------------------------------------------------------------------------------------------
Total 1.9 MB/s | 9.0 MB 00:04
PostgreSQL 16 for RHEL / Rocky / AlmaLinux 8 - x86_64 2.4 MB/s | 2.4 kB 00:00
Importing GPG key 0x08B40D20:
Userid : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
From : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : postgresql16-libs-16.2-1PGDG.rhel8.x86_64 1/4
Running scriptlet: postgresql16-libs-16.2-1PGDG.rhel8.x86_64 1/4
Installing : lz4-1.8.3-3.el8_4.x86_64 2/4
Installing : postgresql16-16.2-1PGDG.rhel8.x86_64 3/4
Running scriptlet: postgresql16-16.2-1PGDG.rhel8.x86_64 3/4
Running scriptlet: postgresql16-server-16.2-1PGDG.rhel8.x86_64 4/4
Installing : postgresql16-server-16.2-1PGDG.rhel8.x86_64 4/4
Running scriptlet: postgresql16-server-16.2-1PGDG.rhel8.x86_64 4/4
Verifying : lz4-1.8.3-3.el8_4.x86_64 1/4
Verifying : postgresql16-16.2-1PGDG.rhel8.x86_64 2/4
Verifying : postgresql16-libs-16.2-1PGDG.rhel8.x86_64 3/4
Verifying : postgresql16-server-16.2-1PGDG.rhel8.x86_64 4/4
Installed:
lz4-1.8.3-3.el8_4.x86_64 postgresql16-16.2-1PGDG.rhel8.x86_64
postgresql16-libs-16.2-1PGDG.rhel8.x86_64 postgresql16-server-16.2-1PGDG.rhel8.x86_64
Complete!
[vagrant@ol8-vagrant ~]$De ‘standaard’ postgreSQL database/CLUSTER maak je aan met sudo /usr/pgsql-16/bin/postgresql-16-setup initdb. Met behulp van systemctl wordt postgresql-16.service 'enabled' .
[vagrant@ol8-vagrant ~]$ sudo /usr/pgsql-16/bin/postgresql-16-setup initdb
Initializing database ... OK
[vagrant@ol8-vagrant ~]$ sudo systemctl enable postgresql-16
Created symlink /etc/systemd/system/multi-user.target.wants/postgresql-16.service → /usr/lib/systemd/system/postgresql-16.service.
[vagrant@ol8-vagrant ~]$ sudo systemctl start postgresql-16
[vagrant@ol8-vagrant ~]$ sudo systemctl status postgresql-16
● postgresql-16.service - PostgreSQL 16 database server
Loaded: loaded (/usr/lib/systemd/system/postgresql-16.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2024-02-28 10:39:19 UTC; 7s ago
Docs: https://www.postgresql.org/docs/16/static/
Process: 26034 ExecStartPre=/usr/pgsql-16/bin/postgresql-16-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
Main PID: 26040 (postgres)
Tasks: 7 (limit: 12216)
Memory: 21.6M
CGroup: /system.slice/postgresql-16.service
├─26040 /usr/pgsql-16/bin/postgres -D /var/lib/pgsql/16/data/
├─26041 postgres: logger
├─26042 postgres: checkpointer
├─26043 postgres: background writer
├─26045 postgres: walwriter
├─26046 postgres: autovacuum launcher
└─26047 postgres: logical replication launcher
Feb 28 10:39:19 ol8-vagrant systemd[1]: Starting PostgreSQL 16 database server...
Feb 28 10:39:19 ol8-vagrant postgres[26040]: 2024-02-28 10:39:19.756 UTC [26040] LOG: redirecting log output to logging collector process
Feb 28 10:39:19 ol8-vagrant postgres[26040]: 2024-02-28 10:39:19.756 UTC [26040] HINT: Future log output will appear in directory "log".
Feb 28 10:39:19 ol8-vagrant systemd[1]: Started PostgreSQL 16 database server.
[vagrant@ol8-vagrant ~]$
Op Oracle8 linux staan naast de datafiles o.a. de configuratie files postgresql.conf en pg_hba.conf in de $PGDATA directory.
[postgres@ol8-vagrant ~]$ echo $PGDATA
/var/lib/pgsql/16/data
[postgres@ol8-vagrant ~]$ cd $PGDATA
[postgres@ol8-vagrant data]$ ls -l
total 68
drwx------. 5 postgres postgres 33 Feb 28 10:39 base
-rw-------. 1 postgres postgres 30 Feb 28 10:39 current_logfiles
drwx------. 2 postgres postgres 4096 Feb 28 10:42 global
drwx------. 2 postgres postgres 32 Feb 28 10:39 log
drwx------. 2 postgres postgres 6 Feb 28 10:39 pg_commit_ts
drwx------. 2 postgres postgres 6 Feb 28 10:39 pg_dynshmem
-rw-------. 1 postgres postgres 5499 Feb 28 10:39 pg_hba.conf
-rw-------. 1 postgres postgres 2640 Feb 28 10:39 pg_ident.conf
drwx------. 4 postgres postgres 68 Feb 28 10:39 pg_logical
drwx------. 4 postgres postgres 36 Feb 28 10:39 pg_multixact
drwx------. 2 postgres postgres 6 Feb 28 10:39 pg_notify
drwx------. 2 postgres postgres 6 Feb 28 10:39 pg_replslot
drwx------. 2 postgres postgres 6 Feb 28 10:39 pg_serial
drwx------. 2 postgres postgres 6 Feb 28 10:39 pg_snapshots
drwx------. 2 postgres postgres 6 Feb 28 10:39 pg_stat
drwx------. 2 postgres postgres 6 Feb 28 10:39 pg_stat_tmp
drwx------. 2 postgres postgres 18 Feb 28 10:39 pg_subtrans
drwx------. 2 postgres postgres 6 Feb 28 10:39 pg_tblspc
drwx------. 2 postgres postgres 6 Feb 28 10:39 pg_twophase
-rw-------. 1 postgres postgres 3 Feb 28 10:39 PG_VERSION
drwx------. 3 postgres postgres 60 Feb 28 10:39 pg_wal
drwx------. 2 postgres postgres 18 Feb 28 10:39 pg_xact
-rw-------. 1 postgres postgres 88 Feb 28 10:39 postgresql.auto.conf
-rw-------. 1 postgres postgres 29671 Feb 28 10:39 postgresql.conf
-rw-------. 1 postgres postgres 58 Feb 28 10:39 postmaster.opts
-rw-------. 1 postgres postgres 100 Feb 28 10:39 postmaster.pid
[postgres@ol8-vagrant data]$sudo naar user postgres en postgreSQL is klaar voor gebruik.
[vagrant@ol8-vagrant ~]$ sudo su - postgres
[postgres@ol8-vagrant ~]$ psql
psql (16.2)
Type "help" for help.
postgres=# select * from pg_database;
oid | datname | datdba | encoding | datlocprovider | datistemplate | datallowconn | datconnlimit | datfrozenxid | datminmxid | dattablespace | datcollate | datctype | daticulocale | daticurules | datcollversion | datacl
-----+-----------+--------+----------+----------------+---------------+--------------+--------------+--------------+------------+---------------+-------------+-------------+--------------+-------------+----------------+-------------------------------------
5 | postgres | 10 | 6 | c | f | t | -1 | 722 | 1 | 1663 | en_US.UTF-8 | en_US.UTF-8 | | | 2.28 |
1 | template1 | 10 | 6 | c | t | t | -1 | 722 | 1 | 1663 | en_US.UTF-8 | en_US.UTF-8 | | | 2.28 | {=c/postgres,postgres=CTc/postgres}
4 | template0 | 10 | 6 | c | t | f | -1 | 722 | 1 | 1663 | en_US.UTF-8 | en_US.UTF-8 | | | | {=c/postgres,postgres=CTc/postgres}
(3 rows)
postgres=#