Hey Sebastian,
thanks for reaching out!
I guess Andreas Rogge is right by saying that its just a warning since
everything seems to work as far as I can tell.
Nontheless, here's the output which should answer your questions:
[root@storage-test01 ~]# psql -U postgres --list
Liste der Datenbanken
Name | Eigentümer | Kodierung | Sortierfolge | Zeichentyp |
Zugriffsprivilegien
-----------+------------+-----------+--------------+-------------+-----------------------
bareos | postgres | SQL_ASCII | C | C |
postgres | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 |
template0 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 |
=c/postgres +
| | | | |
postgres=CTc/postgres
template1 | postgres | UTF8 | de_DE.UTF-8 | de_DE.UTF-8 |
=c/postgres +
| | | | |
postgres=CTc/postgres
(4 Zeilen)
[root@storage-test01 ~]# rpm -qf /usr/pgsql-14/lib/libpq.so.5
postgresql14-libs-14.11-1PGDG.rhel9.x86_64
[root@storage-test01 ~]# rpm -qf /usr/lib64/bareos/libbareossql.so.23
bareos-database-common-23.0.3~pre100.2a30db966-83.el9.x86_64
Output from dnf info *postgres*:
Installed Packages:
Name : bareos-database-postgresql
Version : 23.0.3~pre104.aaf825630
Release : 84.el9
Architektur : x86_64
Größe : 57 k
*Quelle : bareos-23.0.3~pre104.aaf825630-84.el9.src.rpm Paketquelle
: @System Aus Paketque : bareo*s
Name : postgresql14
Version : 14.11
Release : 1PGDG.rhel9
Architektur : x86_64
Größe : 7.6 M
*Quelle : postgresql14-14.11-1PGDG.rhel9.src.rpm Paketquelle :
@System Aus Paketque : pgdg14 *
Name : postgresql14-contrib
Version : 14.11
Release : 1PGDG.rhel9
Architektur : x86_64
Größe : 2.6 M
*Quelle : postgresql14-14.11-1PGDG.rhel9.src.rpm *
*Paketquelle : @System Aus Paketque : pgdg14 *
Name : postgresql14-libs
Version : 14.11
Release : 1PGDG.rhel9
Architektur : x86_64
Größe : 930 k
*Quelle : postgresql14-14.11-1PGDG.rhel9.src.rpm Paketquelle :
@System *
*Aus Paketque : pgdg14 *
Name : postgresql14-server
Version : 14.11
Release : 1PGDG.rhel9
Architektur : x86_64
Größe : 23 M
*Quelle : postgresql14-14.11-1PGDG.rhel9.src.rpm Paketquelle :
@System *
*Aus Paketque : pgdg14*
best regards
Max
Sebastian Sura schrieb am Montag, 29. April 2024 um 07:55:52 UTC+2:
> Hi Max,
>
> does the same warning occur if you try to run psql ? I suspect that libpq
> and your postgres server have different versions.
> Is it possible you installed them from different sources ? E.g. one is
> from your distributions repository while the other is from the postgres
> themselves ?
>
> Kind Regards
> Sebastian Sura
>
> 26.04.24 um 14:28 schrieb Max:
>
> Hi guys,
> I've got a Rocky 9 Linux VM with a predeployed PostgreSQL-DB (14.11) via
> ansible.
> The name, dbname, dbuser & dbpassword are set correctly in
> "/etc/bareos/bareos-dir.d/catalog/MyCatalog.conf" and the bconsole seem to
> work also.
>
> I encounter the following error everytime I run "bareos-dbcheck" OR
> "bareos-dir -t" with the bareos system user:
>
> [bareos@storage-test01 ~]$ bareos-dir -t
> bareos-dir: /usr/pgsql-14/lib/libpq.so.5: no version information available
> (required by /usr/lib64/bareos/libbareossql.so.23)
>
>
> the commands also dont work as root or postgres user.
> ps aux | grep postgres output:
> [root@storage-test01 ~]# ps aux | grep postgres
> postgres 39294 0.0 0.7 1162756 57780 ? Ss 13:59 0:00
> /usr/pgsql-14/bin/postmaster -D /var/lib/pgsql/14/data/
> postgres 39295 0.0 0.0 65268 5776 ? Ss 13:59 0:00
> postgres: logger
> postgres 39297 0.0 0.2 1162972 19516 ? Ss 13:59 0:00
> postgres: checkpointer
> postgres 39298 0.0 0.1 1162756 13300 ? Ss 13:59 0:00
> postgres: background writer
> postgres 39299 0.0 0.3 1162756 23228 ? Ss 13:59 0:00
> postgres: walwriter
> postgres 39300 0.0 0.0 66144 5724 ? Ss 13:59 0:00
> postgres: stats collector
> postgres 39301 0.0 0.0 1163188 7232 ? Ss 13:59 0:00
> postgres: logical replication launcher
>
>
> Im hoping someone can help me since I dont know anymore what to check.
>
>
> best regards
> Max
>
> --
> You received this message because you are subscribed to the Google Groups
> "bareos-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/bareos-users/6b441319-cb58-4349-9e94-179f87686988n%40googlegroups.com
>
> <https://groups.google.com/d/msgid/bareos-users/6b441319-cb58-4349-9e94-179f87686988n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
> --
> Sebastian Sura [email protected]
> Bareos GmbH & Co. KG Phone: +49 221 630693-0
> https://www.bareos.com
> Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646
> Komplementär: Bareos Verwaltungs-GmbH
> Geschäftsführer: Stephan Dühr, Jörg Steffens, Philipp Storz
>
>
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/bareos-users/07f6bf28-de7b-4007-84bd-e1ce28ae43f9n%40googlegroups.com.
