Ticket #96 (closed task: fixed)

Opened 10 months ago

Last modified 10 months ago

Create a debian package supporting PostgreSQL DBMS

Reported by: apoloval Assigned to: apoloval
Priority: major Milestone: Software packaging
Component: Package system Version:
Keywords: Cc:

Description

Currently only SQLite3 is supported by Debian package. This task is aimed to support PostgreSQL DBMS also in a package called ezweb-platform-postgres.

Change History

02/04/08 07:30:06 changed by apoloval

Copy create-deb.sh script, debian-control and debian-postinst files from SQLite3 version to adapt them for PG.

02/04/08 07:30:36 changed by apoloval

  • status changed from new to assigned.

02/04/08 08:08:17 changed by apoloval

When getting input data while configuring the package, may be very useful using a ncursers-based menu provided by Debian packaging tools. At this time, this feature seems very hard for learning, so it's left for the future with #98.

02/04/08 08:25:49 changed by apoloval

In create-deb.sh, configuration file settings.py is modified to set up database connection with known tokens:

  • DATABASE_NAME --> PKG_DBNAME
  • DATABASE_USER --> PKG_DBUSER
  • DATABASE_PASSWORD --> PKG_DBPASSWD
  • DATABASE_HOST --> PKG_DBHOST
  • DATABASE_PORT --> PKG_DBPORT

This tokens will be substituted by sed when executing post-install script.

02/04/08 08:27:42 changed by apoloval

In debian-control, package python-pysqlite2}} is substituted by {{{python-psycopg2.

02/04/08 08:31:35 changed by apoloval

In create-deb.sh, generated package name should be modified from ezweb-platform-sqlite3 to ezweb-platform-postgres.

02/04/08 09:51:59 changed by apoloval

In debian-control file, package postgresql.

02/04/08 11:17:38 changed by apoloval

File debian-postinst modified to read DB connection parameters from stdin. Such data is used to substitute tokens in previously prepared settings.py and to create user and database in PostgreSQL.

02/04/08 11:43:05 changed by apoloval

First version commited in r858.

02/04/08 12:55:37 changed by apoloval

In r859, some checks are done before create database and users to avoid creation of already existing elements.

02/04/08 14:04:12 changed by apoloval

  • status changed from assigned to closed.
  • resolution set to fixed.