[bug]:Error opening postgres graph DB: unknown database type

[raymond98]

Background

Trying to configure LND with postgres as the db backend results in an error: unable to open databases: unable to obtain database backends: error opening postgres graph DB: unknown database type.

Environment

• version: v0.17.3-beta
• Ubuntu 22.04.3
• Neutrino
• GO1.19.7

Steps to reproduce

Installed LND following the steps on INSTALL.md:

git clone https://github.com/lightningnetwork/lnd
cd lnd
make install [also tried including the kvdb_postrgres build tag]

                         or

git clone https://github.com/lightningnetwork/lnd
cd lnd
git checkout v0.x.x
make install

The configuration includes the following:

[db]
db.backend=postgres

[postgres]
db.postgres.dsn=postgresql://lndadmin:********************@HostIP:5432/lndbname?sslmode=disable
db.postgres.timeout=0

The config file or the postgresSQL set up does not seem to be the issue as passing this same configuration to the LND docker build tagged:v0.17.3-beta works perfectly with the following results:

2023-12-18 16:57:26.096 [INF] LTND: Opening the main database, this might take a few minutes...
2023-12-18 16:57:26.141 [INF] LTND: Using remote postgres database! Creating graph and channel state DB instances
2023-12-18 16:57:26.155 [DBG] CHDB: Populating in-memory channel graph, this might take a while...
2023-12-18 16:57:26.161 [DBG] CHDB: Finished populating in-memory channel graph (took 4.590214ms, num_node_features=0, num_nodes=0, num_channels=0)
2023-12-18 16:57:26.161 [INF] CHDB: Checking for schema update: latest_version=31, db_version=31
2023-12-18 16:57:26.162 [INF] CHDB: Checking for optional update: prune_revocation_log=false, db_version=empty
2023-12-18 16:57:26.162 [INF] LTND: Database(s) now open (time_to_open=65.168512ms)!

Expected behaviour

LND to successfully start and connect to postgres or giving detailed error like failing to reach postgres

Actual behaviour

LND shuts down with the outcome:

2023-12-18 16:01:44.805 [INF] LTND: Opening the main database, this might take a few minutes...
2023-12-18 16:01:44.805 [ERR] LTND: Shutting down because error in main method: unable to open databases: unable to obtain database backends: error opening postgres graph DB: unknown database type
2023-12-18 16:01:44.806 [INF] LTND: Shutdown complete

unable to open databases: unable to obtain database backends: error opening postgres graph DB: unknown database type

[guggero]

Can you try with make release-install which automatically includes all production build tags?

[raymond98]

I did and LND is working as I expected, thanks.