[Dbconfig-common-devel] Read only access for all users to database

[Kip Warner]

On Tue, 2016-06-07 at 20:53 +0200, Paul Gevers wrote:
> Pardon my ignorance, but I don't understand what you mean by this (no
> idea what it means if a package hosts a database). If the package is
> using dbconfig-common, there is no way to guarantee that it is used
> on
> the same computer that hosts the database. So maybe dbconfig-common
> is
> not for your package (I can't really say), or you need to be very
> explicit in you description of the package that the admin must never
> tell dbconfig-common to "install the schema" onto a different host.
> Whatever the answer, I guess there is no dbconfig-common way to do
> what
> you originally asked for.

Paul, by host I mean it installs the schema. Here is a typical minimal
.config Debian maintainer script.

...
dbc_dbname=mydb
dbc_dbuser=myrole
if [ -f /usr/share/dbconfig-common/dpkg/config.pgsql ]; then
    . /usr/share/dbconfig-common/dpkg/config.pgsql
    dbc_go helios-database $@
fi

#DEBHELPER#
...

That installs the schema the package contains into the local PSQL
database. I'm not sure if it's even possible to install it remotely
into another machine with dbconfig-common.

-- 
Kip Warner -- Senior Software Engineer
OpenPGP encrypted/signed mail preferred
http://www.thevertigo.com

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 181 bytes
Desc: This is a digitally signed message part
URL: <http://lists.alioth.debian.org/pipermail/dbconfig-common-devel/attachments/20160607/bff9e591/attachment.sig>