tags 382640 + wontfix
severity 382640 wishlist
thanks
hi Sven,
On Sat, Aug 12, 2006 at 03:26:38PM +0200, Sven Goldt wrote:
> This package forces the usage of mysql instead of postgresql even though
> postgresql is supported by the original software.
yes, postgresql is indeed supported, however, mysql is recommended by upstream:
(from upstream's Documentation:)
> Regarding the choice between PostgreSQL and MySQL, MySQL is recommended for
> several reasons:
> * MySQL is faster
> recent benchmarks using ZABBIX clearly show that PostgreSQL (7.1.x) is
> at least 10 times slower than MySQL (3.23.29)
>
> Note: These results are predictable. ZABBIX server processes use simple
> SQL statements like single row INSERT, UPDATE and simple SELECT
> operators. In
> such environment, use of advanced SQL engine (like PostgreSQL) is
> overkill.
> * no need to constantly run resource-hungry command vacuum for MySQL
> * MySQL is used as a primary development platform.
>
> If you do use PostgreSQL, zabbix_server will periodically (defined in
> HousekeepingFrequency) execute command vacuum analyze
>
for this reason the current packages are only compiled with mysql, not with
postgresql support.
> You can't even install only the zabbix-server without any database or
> you can't create your own zabbix-server-postgresql package because the
> zabbix server is included only in the zabbix-server-mysql package.
in fact zabbix-server-mysql Recommends mysql, you dont need to have a mysql
server running on the host you install the package (and due to the use of
dbconfig-common you can easily setup the databaes on a remote host (given your
debconf question priority is set to low).
The zabbix-server-mysql Package does not include the needed files for setting
up a postgresql database as the software is not compiled with postgresql
support anyway and shipping those file would be unneccesary overhead. You can
however, set up your mysql database by hand (by skipping dbconfig-common's
setup on installation)
Given this is not a 'bug', and does not break anything im downgrading it to
wishlist. A server package with PostgreSQL support may be provided in the
future, this however, belongs on how Upstream will change its opinion about
using PostgreSQL in the future.
bye,
- michael
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
