KenwoodFox

# ps auwwx | grep postgresq
root     33099  0.0  0.0   6732  2552  1  S+J  16:22   0:00.00 grep postgresq
root@Bacula-Iron2:/ # ps auwwx | grep postgres
postgres 33087  0.0  0.1 168940 25616  -  IsJ  16:22   0:00.00 postgres: checkpointer    (postgres)
postgres 33088  0.0  0.1 168940 25616  -  SsJ  16:22   0:00.01 postgres: background writer    (postgres)
postgres 33089  0.0  0.1 168940 25616  -  SsJ  16:22   0:00.00 postgres: walwriter    (postgres)
postgres 33090  0.0  0.1 168940 25876  -  SsJ  16:22   0:00.00 postgres: autovacuum launcher    (postgres)
postgres 33091  0.0  0.0  23848 14972  -  SsJ  16:22   0:00.00 postgres: stats collector    (postgres)
postgres 33092  0.0  0.1 168940 25836  -  IsJ  16:22   0:00.00 postgres: logical replication launcher    (postgres)
postgres 33085  0.0  0.1 168940 25592  1  SJ   16:22   0:00.03 /usr/local/bin/postgres -D /var/db/postgres/data11

KenwoodFox

# service postgresql start
2020-05-13 16:22:20.675 EDT [33085] LOG:  listening on IPv6 address "::1", port 5432
2020-05-13 16:22:20.675 EDT [33085] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2020-05-13 16:22:20.676 EDT [33085] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2020-05-13 16:22:20.689 EDT [33085] LOG:  ending log output to stderr
2020-05-13 16:22:20.689 EDT [33085] HINT:  Future log output will go to log destination "syslog".
root@Bacula-Iron2:/ # su pgsql
su: unknown login: pgsql
root@Bacula-Iron2:/ # su postgres
$ exit

KenwoodFox

# pkg info -R bareos.com-database-postgresql-19.2.7

KenwoodFox

# cat /var/log/bareos/bareos.log
13-May 01:47 bareos-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bareos".
13-May 01:47 bareos-dir JobId 0: Fatal error: cats/postgresql.cc:252 Unable to connect to PostgreSQL server. Database=bareos User=bareos
Possible causes: SQL server not running; password incorrect; max_connections exceeded.
13-May 01:47 bareos-dir ERROR TERMINATION
Please correct the configuration in /usr/local/etc/bareos/bareos-dir.d/*/*.conf

KenwoodFox

# ps aux | grep bareos
root     4573  0.0  0.0  17636  8340  -  SsJ  23:08   0:00.16 /usr/local/sbin/bareos-sd
root     4576  0.0  0.0  14660  7648  -  SsJ  23:08   0:00.16 /usr/local/sbin/bareos-fd
root     8359  0.0  0.0  23092 10544  -  SsJ  01:30   0:00.05 /usr/local/sbin/bareos-dir
postgres 8361  0.0  0.1 170988 28264  -  IsJ  01:30   0:00.00 postgres: bareos bareos [local]  (postgres)
root     8546  0.0  0.0   6732  2540  1  S+J  01:35   0:00.00 grep bareos

KenwoodFox

# service postgresql start
Shared object "libicuuc.so.66" not found, required by "postgres"
no data was returned by command ""/usr/local/bin/postgres" -V"
The program "postgres" is needed by pg_ctl but was not found in the
same directory as "/usr/local/bin/pg_ctl".
Check your installation.

KenwoodFox

# service bacula-dir status
bacula_dir is running as pid 95404.
# bconsole
Connecting to Director Bacula-Iron:9101
# service bacula-dir status
bacula_dir is not running.

KenwoodFox

# service bacula-dir status
bacula_dir is running as pid 95404.
root@Bacula-Iron:/ # bconsole
Connecting to Director Bacula-Iron:9101
root@Bacula-Iron:/ # service bacula-dir status
bacula_dir is not running.

KenwoodFox

# pkg install --yes bareos.com-director bareos.com-storage bareos.com-filedaemon bareos.com-database-postgresql bareos.com-bconsole
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
Updating Bareos repository catalogue...
Certificate verification failed for /C=US/O=Let's Encrypt/CN=Let's Encrypt Authority X3
34404218008:error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed:/usr/src/crypto/openssl/ssl/s3_clnt.c:1269:
Certificate verification failed for /C=US/O=Let's Encrypt/CN=Let's Encrypt Authority X3
34404218008:error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed:/usr/src/crypto/openssl/ssl/s3_clnt.c:1269:
Certificate verification failed for /C=US/O=Let's Encrypt/CN=Let's Encrypt Authority X3
34404218008:error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed:/usr/src/crypto/openssl/ssl/s3_clnt.c:1269:

KenwoodFox

# zpool status ArchiveVolume
  pool: ArchiveVolume
 state: ONLINE
status: One or more devices has experienced an unrecoverable error.  An
        attempt was made to correct the error.  Applications are unaffected.
action: Determine if the device needs to be replaced, and clear the errors
        using 'zpool clear' or replace the device with 'zpool replace'.
   see: http://illumos.org/msg/ZFS-8000-9P
  scan: resilvered 0 in 0 days 00:00:02 with 0 errors on Sun May  3 20:34:19 2020
config: