Minetest服务器如何使用postgresql存储数据

服务器 服务器配置
1

数据库创建


CREATE DATABASE minetest_world OWNER minetest;
GRANT ALL PRIVILEGES ON DATABASE minetest_world TO minetest;

CREATE DATABASE minetest_auth OWNER minetest;
GRANT ALL PRIVILEGES ON DATABASE minetest_auth TO minetest;

在地图配置文件中增加如下

pgsql_connection = host=127.0.0.1 port=5432 user=minetest password=www dbname=minetest_world_fire_plume
pgsql_player_connection = host=127.0.0.1 port=5432 user=minetest password=www. dbname=minetest_player
pgsql_auth_connection = host=127.0.0.1 port=5432 user=minetest password=www dbname=minetest_auth

分别执行

./minetestserver --migrate postgresql /home/hzhzhzh/Minetest/minetest_server/worlds/world
./minetestserver --migrate-players postgresql /home/hzhzhzh/Minetest/minetest_server/worlds/world
./minetestserver --migrate-auth postgresql /home/hzhzhzh/Minetest/minetest_server/worlds/world