[jadmin] Jabberd 14 1.6 Postgresql Table Setup Script?

[Matthias Wimmer]

John W. M. Stevens schrieb:
> I'm trying to move from a file spool, and jabberd 1.4.2, to jabber14 1.6.0
> with PostGresql as the data base engine.
> 
> I've replaced the default MySql statements in the jabber.xml file with
> the PostGresql ones, but I can't find a PostGresql tables/relations
> setup script for PostGresql that is equivalent to the mysql.sql
> file.
> 
> Does anybody know where I can get a PostGresql relations setup script
> that is compatible with the xdb_postgresql.xml commands?

http://svn.jabberd.org/trunk/jabberd14/xdb_postgresql.xml
http://svn.jabberd.org/trunk/jabberd14/pgsql_createdb.sql

If you use this pgsql_createdb.sql script, please use also the
definitions from the above link, they have changed a bit compared with
the version included in the release.


Matthias

-- 
Matthias Wimmer      Fon +49-700 77 00 77 70
Züricher Str. 243    Fax +49-89 95 89 91 56
81476 München        http://ma.tthias.eu/