MySQL to PostgreSQL

[wick3dr0se]

How can I migrate TFS 1.3 from MariaDB to PostgreSQL? In config.lua I tried changing mysqlHost to sqlHost, mysqlUser to sqlUser, etc. I use Adminer instead of phpMyAdmin for the front end and I tried uploading the schema.sql from the forgottenserver which worked fine with MariaDB(MySQL). The schema won't upload with PostgresSQL in Adminer or through command line. It gives me syntax errors in schema.sql. I tried editing the syntax to examples of Postgres create table commands but I can't seem to get it right. I've seen others on the forum discussing Postgres, but haven't seen a working example. No conversion tools such as pgloader have worked for me

 

[Evil Puncker]

would you mind to tell us why would you like to change these? btw its not only the .sql file what would need changes, but your entire source queries and the AAC (znote/gesior etc) would need to be changed in order to work with PostgreSQL



OR I'M JUST TALKING A BUNCH OF NON SENSE

 

[wick3dr0se]

would you mind to tell us why would you like to change these? btw its not only the .sql file what would need changes, but your entire source queries and the AAC (znote/gesior etc) would need to be changed in order to work with PostgreSQL



OR I'M JUST TALKING A BUNCH OF NON SENSE

I wanted to attempt to serve my database with Redis, PostgreSQL and GitLab by following the Arch Wiki:

GitLab - ArchWiki