db-create with PostgreSQL fails with user "user"

[Louis Bertrand]

-----Original Message-----
From: Mads Kiilerich <mads at kiilerich.com>
Sent: May 15, 2020 12:56 PM
To: Louis Bertrand <Louis.Bertrand at durhamcollege.ca>; Thomas De Schampheleire <patrickdepinguin at gmail.com>
Cc: Kallithea <kallithea-general at sfconservancy.org>
Subject: Re: db-create with PostgreSQL fails with user "user"

[EXTERNAL EMAIL]

On 5/15/20 10:08 AM, Louis Bertrand wrote:
> Hi Thomas,
>
> Thanks for the prompt reply but it turns out that it's pilot error.
> The name 'user' came from my.ini, where the postgresql URL was set to
> default. After setting the URL correctly
>
>     sqlalchemy.url = postgresql://kallithea:S3CR3T@localhost/kallithea
>    (not the real password)
>
> the database seems to be initialized correctly.


Would a more verbose installation overview have helped you? Something like
https://kallithea-scm.org/repos/kallithea-incoming/changeset/512aef4199733151ec76490915bca1e6ce7d63e2
?


/Mads



Hi Mads,
Yes, greatly (except for slight typo s/scheme/schema). I chose PostgreSQL because a) it's already installed on the eventual target server and b) I'm familiar with it. However, where is the trade-off between SQLite and PostgreSQL? Tens, hundreds, thousands? Number of users, transactions? Etc. In other words, I might have saved myself some trouble by simply accepting the default for a small site.
Thanks
 --Louis


________________________________

________________________________
This message is intended only for the named recipients. This message may contain information that is confidential or exempt from disclosure under applicable law. Any dissemination or copying of this message by anyone other than a named recipient is strictly prohibited. If you are not a named recipient or an employee or agent responsible for delivering this message to a named recipient, please notify us immediately, and permanently destroy this message and any copies you may have. Warning: Email may not be secure unless properly encrypted.