Skip to content
This repository has been archived by the owner on May 17, 2021. It is now read-only.

Postgresql DB Setup Failing #297

Open
Izzy87 opened this issue Oct 20, 2017 · 0 comments
Open

Postgresql DB Setup Failing #297

Izzy87 opened this issue Oct 20, 2017 · 0 comments

Comments

@Izzy87
Copy link

Izzy87 commented Oct 20, 2017

Hello, can anyone advise me on the correct process for the installation of Minicron with Postgresql.

Currently, I log into PSQL and create a new "minicron" user (also granting Create DB privilege), and then create a Database manually called "minicrondb" with ownership set to the "minicron" user. I change /etc/minicron.toml to access Postgresql with the new relevant Database/User/Password information, then upon using minicron db setup I get this error:
FATAL: database "minicron" does not exist

It's like the new TOML database name isn't being acknowledged. If I change the TOML database name to just "minicron" to match the default, and alter the database name to "minicron", I then get this error:

PG::DuplicateDatabase: ERROR:  database "minicron" already exists
: CREATE DATABASE "minicron" ENCODING = 'utf8'

Seems like a new issue to me, this one suggesting I don't need to create a database manually at all, but if I DROPDB (but keeping the "minicron" user with CREATEDB privilege) and then run again minicron db setup I get the FATAL: database "minicron" does not exist error again, seemingly contrary to the DuplicateDatabase error above.

Any ideas? My PC already runs postgresql for another application, so presumably it's more efficient than using sqlite (which for the record, does seem to work).

PS: It's true, I am a Crontab-UI refugee, I had no joy getting that to run recently, so here I am!

@jamesrwhite jamesrwhite added this to the future milestone Jun 30, 2018
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants