[geeklog-devel] postgresql and Geeklog 2.0.0b1

[Joe Mucchiello]

> "To create a database, you must be a superuser or have the special
> CREATEDB privilege."
> http://www.postgresql.org/docs/8.1/static/sql-createdatabase.html
> 
> "The user must have the PostgreSQL superuser privilege to register a
> new language."
> http://www.postgresql.org/docs/8.1/static/sql-createlanguage.html
> 
> When I create a new database for geeklog I am doing that step as a
> Superuser.

The Geeklog install script doesn't run the create database command in pgsql, mysql or mssql. It assumes the database is already created in order to avoid the problem of needing create database privilege. Most shared hosts provide a runnable script that creates databases outside of the normal admin programs for the database. (This is how they limit users to 1, 3, 5 or some other number of databases.)

So perhaps instead the pgsql install just needs to check if the language is set on the database, attempt to create it if it isn't there, and failing that, explain what is needed to get it up and running. I really don't think Geeklog should take it on itself to modify "templates" in the database system. That is too far outside Geeklog's responsibilities to be mucking with.

  Joe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist8.pair.net/pipermail/geeklog-devel/attachments/20120705/4b1a31ee/attachment.html>