Map can't migrate to PostgreSQL

Post Reply
User avatar
MatyasP
Member
Posts: 140
Joined: Wed Jan 19, 2022 22:12
GitHub: Matyas-Pilz
In-game: MatyasP
Location: Prague, Czech republic
Contact:

Map can't migrate to PostgreSQL

by MatyasP » Post

Hello, I tried to migrate map backend from SQLite to PostgreSQL and I have got this problem:

Code: Select all

2026-03-29 00:58:33: VERBOSE[Main]: httpfetch_init: parallel_limit=8
2026-03-29 00:58:33: INFO[Main]: Gettext: domainname="luanti" path="/usr/share/locale"
2026-03-29 00:58:33: INFO[Main]: Message locale is now set to: C
2026-03-29 00:58:33: WARNING[Main]: MINETEST_SUBGAME_PATH is deprecated, use MINETEST_GAME_PATH instead.
2026-03-29 00:58:33: INFO[Main]: Using commanded gameid [MtV7]
2026-03-29 00:58:33: VERBOSE[Main]: Using world path [/home/container/.minetest/worlds/MtV6_01]
2026-03-29 00:58:33: VERBOSE[Main]: Using gameid [MtV7]
2026-03-29 00:58:33: INFO[Main]: Creating map database with backend "sqlite3"
2026-03-29 00:58:33: INFO[Main]: MapDatabaseSQLite3: split column format = yes
2026-03-29 00:58:33: ERROR[Main]: Database backend "postgresql" unknown or not supported
2026-03-29 00:58:33: ERROR[Main]: An unhandled exception occurred: "Database backend "postgresql" unknown or not supported"
2026-03-29 00:58:33: ERROR[Main]: In thread 709c7071ca80:
2026-03-29 00:58:33: ERROR[Main]: ./src/main.cpp:280: int main(int, char**): A fatal error occurred: "Database backend "postgresql" unknown or not supported"
I use game server on Pterodactyl on Debian (CLI), I tried it with hosting provider and it was without success.
Before it, I tried the migrate it on Windows 11 Home from sqlite3 to postgresql, too unsuccessful. After it, I tried migrate to LevelDB (not for use, only test of migration) and it was succesful.

sofar
Developer
Posts: 2194
Joined: Fri Jan 16, 2015 07:31
GitHub: sofar
IRC: sofar
In-game: sofar

Re: Map can't migrate to PostgreSQL

by sofar » Post

The DB backends require (1) that luanti is built with the proper support enabled, and (2) the local support libraries are installed and (3) the actual database backend up and running (in case of pgsql).

Most likely one or more of these things isn't right, and so it fails. You'd have to dig into the debian package to figure out how it's built - I'm not a debian user/developer so I can't help, but, maybe someone else can chime on for that.

User avatar
MatyasP
Member
Posts: 140
Joined: Wed Jan 19, 2022 22:12
GitHub: Matyas-Pilz
In-game: MatyasP
Location: Prague, Czech republic
Contact:

Re: Map can't migrate to PostgreSQL

by MatyasP » Post

sofar wrote:
Sun Mar 29, 2026 03:52
The DB backends require (1) that luanti is built with the proper support enabled, and (2) the local support libraries are installed and (3) the actual database backend up and running (in case of pgsql).

Most likely one or more of these things isn't right, and so it fails. You'd have to dig into the debian package to figure out how it's built - I'm not a debian user/developer so I can't help, but, maybe someone else can chime on for that.
Thank you!
1) This is the main problem... I assumed that all distributed versions of Luanti automatically supports PostgreSQL backend if PostgreSQL server is running. Is some repository where can I see compiled versions that supports PostgreSQL? For Linux Debian (Luanti server CLI) and for Windows.
2) I assumed that running PostgreSQL server and Luanti server egg are the all what is needed to run Luanti server with PostgreSQL as map backend...
3) I made it without any problem

sofar
Developer
Posts: 2194
Joined: Fri Jan 16, 2015 07:31
GitHub: sofar
IRC: sofar
In-game: sofar

Re: Map can't migrate to PostgreSQL

by sofar » Post

I don't know what the actual library is that is needed. I assume it's libpq.so.5, but, that is just a wild guess. Sorry, I neither use debian nor postgresql myself.

Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests