Re: MySQL v. PostgreSQL

Hallöchen!

Markus Hoenicka writes:

> [...]
>
> I'd like to see your RefDB setup (run refdb-bug to create an
> overview of your setup)

I can't find this program, but my config file says

refdblib /usr/local/share/refdb
main_db	refdb
serverip	localhost
dbsport		5432
dbserver	pgsql
dbpath		/usr/local/var/lib/refdb/db
port	9734
logfile /usr/local/var/log/refdbd.log
logdest file
loglevel info
pidfile		/usr/local/var/run/refdbd.pid
remoteadmin f
remoteconnect f
keep_pnames t
keyword_scan t
dbi_driverdir /usr/lib/dbd
db_encoding	UTF-8
in_encoding	UTF-8

Only dbsport and dbserver are different for MySQL.

> and the refdbd log to see what happens during addref, ideally with
> both database engines.

http://www-users.rwth-aachen.de/Torsten.Bronger/mysql.log
http://www-users.rwth-aachen.de/Torsten.Bronger/pgsql.log

However, take them with a grain of salt because they are copied from
the shell.  I don't know whether the shell can "repair" or interpret
encodings.  Anyway, it should be sufficient for comparing both.

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: [email protected]


------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H