I've been using PowerDNS for a few years now and finally decided to switch over to pgSQL instead of mySQL. I've been researching this question but I haven't found anything solid so I'm assuming it's probably not possible.
I'm curious if it's possible to install and run PowerDNS from within a schema called pdns
instead of a database called pdns
? I'm unable to find any option to tell PowerDNS to look in X database and Y schema.
For example I have a database called example
and in this database I have two schema's called mydb
and pdns
. I'd like to install the PowerDNS table structure in the pdns
schema and then run the PowerDNS service from that schema. It seems to work just fine when the tables are in the public
schema.