How to configure VerneMQ Docker container uses PostgreSQL for storage instead of Google's LevelDB

VerneMQ Forum VerneMQ Questions
,
1

Hi All

Can you please let us know how to configure VerneMQ Docker container uses PostgreSQL for storage instead of Google’s LevelDB.

Thank you for your help

Regards, Bao

1 Like
2

Hi Bao,

You can only use PostgreSQL as a vmq_diversity plugin, that is, as an authentication/authorization plugin. You’ll store ClientID/Username/Password/ACLs in PostgreSQL.

I’m not sure this is what you are asking, though. PostgreSQL cannot be used for storing messages, that is to replace LevelDB as an internal persistence layer.

2 Likes
3

Hi @afa

Thank you for confirm that PostgreSQL cannot be used for storing messages instead of LevelDB.

Regards, Bao

4

@afa

And Firestore, can it be used to store msg?

1 Like
5

@maykonfpp You can build a VerneMQ plugin that exports messages to Firestore. The plugin will have to speak to some Firestore API and decide which of the messages will be forwarded.

We cannot use Firestore as a means of internal message persistence (ie. as a replacement for LevelDB), as Firestore is a closed-source cloud database.

1 Like
7

Do you have any documentation on how to create this plug-in?

8

Documentation on plugin development is here:

Depending on your previous knowledge of VerneMQ and Erlang/OTP this will require some effort.

1 Like