Hi.

I cannot seem to find any packaging guidelines an how to deal with a
PostgreSQL database management in a package of a web app requiring a PG
DB.

More specifically, if usual installation directives mention modifying of
pg_hba.conf, how should one translate that into Debian packaging scripts
actions ?

Is modifying pg_hba.conf in a package's config script via ucf an
option ?

Is there a better place to ask or learn ?

Thanks in advance.

Best regards,
--
Olivier BERGER (Debian developer)
(OpenPGP: 4096R/7C5BB6A5)
http://www.olivierberger.com/weblog/


--
To UNSUBSCRIBE, email to debian-devel-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Archive: 1313154700.7174.4.camel@inf-8657.int-evry.fr">http://lists.debian.org/1313154700.7174.4.camel@inf-8657.int-evry.fr

On 08/12/2011 03:11 PM, Olivier Berger wrote:
> Hi.
>
> I cannot seem to find any packaging guidelines an how to deal with a
> PostgreSQL database management in a package of a web app requiring a PG
> DB.
>
> More specifically, if usual installation directives mention modifying of
> pg_hba.conf, how should one translate that into Debian packaging scripts
> actions ?

If your application runs on the same host as postgres, there is no need to
modify pg_hba.conf as local users will be authenticated with ident - all you
need to to is to create the role for them in postgres.

If it runs somewhere else, you can't modify the remote pg_hba.conf.

To add new databases (and roles....) to postgres, look into dbconfig-common.


--
Bernd Zeimetz Debian GNU/Linux Developer
http://bzed.de http://www.debian.org
GPG Fingerprint: ECA1 E3F2 8E11 2432 D485 DD95 EB36 171A 6FF9 435F


--
To UNSUBSCRIBE, email to debian-devel-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Archive: 4E45707D.4010104@bzed.de">http://lists.debian.org/4E45707D.4010104@bzed.de