I'm a hack on my good days but I'll give it a whirl as soon as I wrap my head around plugins in general.
I have a small stack of plugins we need for our feature set anyway. 🙂
First allow me to thank you and the team for all the improvements made recently with 1.10+. As always you guys are amazing!
Is there any chance to see @Ben-Lubar 's postgresql pull request integrated soon?
We are currently running the PR on https://what.thedailywtf.com/, and it's working without any new problems.
Wow amazing! how long have you been running? How's the performance in comparison to redis/mongo? When will this gem get integrated into master?
My apology for the many questions, just a bit excited to see this code finally on prime time
I decided to look at the recent commits, and..., well, could not believe my eyes, PostgreSQL just got integrated!
PostgreSQL opens the door for (novice) admins to create forums based on NodeBB, on cloud platforms that don't support MongoDB or Redis, or where such support is too expensive.
With PostgreSQL support, the admin does not need to create and maintain a database on an instance - instead for a similar cost he may opt for PostgreSQL as service. In Amazon AWS for example, the service comes with automated backup and restore. The integration is quite speedy with low to moderate effort (basically reading few AWS documents and following examples).
Besides that, PostgreSQL offers additional features over key-value database, so future releases may benefit as well.
Congratulations on this fine release.
I am grateful for your work and dedication!
Made some progress, but hit a small bump
For those who are converting from Redis:
Open pgAdmin and create a new user/pass (default username is nodebb). Create a new database, and grant login permission to the just created new user
DL the converter and follow the github instructions using the new database name
npm install continuation-local-storage
npm install pg
Change the Config file:
Run ./nodebb setup.
That's how far I got, I am now getting the following error:
Now configuring postgres database:
warn: NodeBB Setup Aborted.
error: type "legacy_object_type" already exists
The legacy_object_type was created by the converter, so something must have gone wrong.
@Ben-Lubar can you please help?
Thanks @Ben-Lubar! I tried running (,/nodebb build ), but got the below. Any idea?
Perhaps the issue sourced from the parameters I provided the converter?
Kindly note, I use Redis, on SCHEMA=1.
--type redis \
--input 'redis://REDIS_SERVER_ADDR:6379/1' \
--sessionType redis \
--sessionInput 'redis://REDIS_SERVER_ADDR:6379/1' \
--outputType postgres \
--output 'postgresql://username:[email protected]_SERVER_ADDR:5432/MY_NEW_DATABASE' \
Hi @Ben-Lubar ,
I am still stuck at the same spot, no matter what I do.
I guess the converter and the pg driver are a bit incompatible, at least on my database.
However my DB is very small, and quite standard...
Any suggestion how to resolve?
Thank you very much in advance!
Hi @Ben-Lubar ,
Yes they are the same, my apology for the naming confusion.
Kindly note the "/1" indicating SCHEMA=1 - I believe it is required but I was not sure it should appear in both Input and sessionInput,
Thanks for looking into this!
Hi @Ben-Lubar .
No matter what I do, I can't bring up the converted forum generated by nodebb-postgres-converter.
Honestly I am not sure what to do next... Any idea what I should check?