go-guerrilla icon indicating copy to clipboard operation
go-guerrilla copied to clipboard

Cannot change SQL backend to Postgres

Open lllama opened this issue 5 years ago • 2 comments

I've been trying to use the new backends functionality to change from MySQL to Postgres.

I get the following error (or variant depending on what I change sql_driver to:

error while initializing the backend: sql: unknown driver \"lib/pq\" (forgotten import?)

Would it be possible to get an example config, or some idea of how to make sure the correct driver is loaded? (perhaps @danielwhite might have an idea...)

Many thanks!

lllama avatar Apr 03 '19 16:04 lllama

Looks like the driver string needs to be postgres.

Note that there seems to be other issues with using postgres, as the SQL statements use backticks, which postgres does not like.

lllama avatar Apr 04 '19 13:04 lllama

Thanks for the update. You're welcome to document this if you get it to work - would be happy to add your contribution to the wiki.

flashmob avatar Apr 04 '19 22:04 flashmob