Bug 450620

Not only is the file missing but pdns should be looking for libgpgsqlbackend.so
instead (see the extra 'g' inside the name) as it is the case in previous
releases, Fedora 8 for example.

I need a quick fix here, where can I get this file?

MySQL includes this files in the package libs-mysql. Is there such a package for
PostgreSQL?

Do you have pdns-backend-postgresql installed?

Yes, definitively. When I did a
yum install pdns-backend-postgresql

however, I didn't get an extra package as it does with pdns-backend-mysql that
adds libs-mysql.

It pulls in postgresql-libs:

[root@ruben yum.repos.d]# sudo yum install pdns-backend-postgresql
Loading "installonlyn" plugin
Setting up Install Process
Setting up repositories
Reading repository metadata in from local files
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for pdns-backend-postgresql to pack into transaction set.
pdns-backend-postgresql-2 100% |=========================| 3.9 kB    00:00     
---> Package pdns-backend-postgresql.x86_64 0:2.9.21-4.el5.centos set to be updated
--> Running transaction check
--> Processing Dependency: libpq.so.4()(64bit) for package: pdns-backend-postgresql
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for postgresql-libs to pack into transaction set.
postgresql-libs-8.1.11-1. 100% |=========================|  16 kB    00:00     
---> Package postgresql-libs.x86_64 0:8.1.11-1.el5_1.1 set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size 
=============================================================================
Installing:
 pdns-backend-postgresql  x86_64     2.9.21-4.el5.centos  extras             35 k
Installing for dependencies:
 postgresql-libs         x86_64     8.1.11-1.el5_1.1  updates           195 k

Actually, it doesn't.
I'll fix the package, in the meantime you can install postgresql-libs.

Actually pdns is expecting libgpsqlbackend.so and not libgpgsqlbackend.so. So I
created a link:

ln -s /usr/lib/pdns/libgpgsqlbackend.so /usr/lib/pdns/libgpsqlbackend.so 

But pdns still complains with this error:

----------------------------------------------
pdns[2687]: Guardian is launching an instance
pdns[2687]: This is module gpgsqlbackend.so reporting
pdns[2687]: Fatal error: Trying to launch unknown backend 'gpsql'
pdns[2680]: Our pdns instance exited with code 1
pdns[2680]: Respawning
----------------------------------------------

Forget about my last post. That was due to a bad config file. Somehow there must
have been a change of name for the backend and I was perhaps reading an older
documentation. The backend name to use PostgreSQL is 'gpgsql' and not 'gpsql',
so I corrected the config file /etc/pdns/pdns.conf like this:

------------------------
launch=gpsql
gpgsql-host=127.0.0.1
gpgsql-user=*****
gpgsql-dbname=*****
gpgsql-password=*****
------------------------

Hi Eric

Regarding comment #5, I just installed the backend on Fedora devel, and it pulls
in postgresql-libs:

[ruben@localhost devel]$ sudo yum install pdns-backend-postgresql
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package pdns-backend-postgresql.i386 0:2.9.21-4.fc9 set to be updated
--> Processing Dependency: libpq.so.5 for package: pdns-backend-postgresql
--> Running transaction check
---> Package postgresql-libs.i386 0:8.3.1-1.fc9 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size 
=============================================================================
Installing:
 pdns-backend-postgresql  i386       2.9.21-4.fc9     fedora             33 k
Installing for dependencies:
 postgresql-libs         i386       8.3.1-1.fc9      fedora            210 k

The backend is indeed named gpgsql (and has been since at least FC-5)

Is everything working for you now?

Hi Ruben,

Yes, it now pulls in the postgresql-libs package. Everything's working fine.
Thank you.