[Geonetwork-devel] postgresql support

[Carl A. <car...@va...>]

I was able to get geonetwork-2.0.1 working against Postgresql 8.0.
the only real issue seems to be, don't use the longvarchar type and use 
the text type instead.
and add an type alias into Data Druid for the postgresql driver.


As a manual process

Let a standard geonetwork install against McKoi run.
As a Postgresql DB Admin
    create user geonetwork  (create user geonetwork password 'mypass';)
    create schema geonetwork    (create schema geonetwork authorization 
geonetwork;)
Create objects using the MySQL script in setup/sql/create-db-mysql.sql
       (the create-db-postgresql.sql script is broken.  Druid needs to 
have a type alias for longvarchar to text added for postgresql)
Download Database-Druid version 3.7 (http://druid.sf.net) version 3.2 
does not work
    add the postgresql driver to Druid
    connect to the postgresql database
    navigate to the tables in the geonet schema
    select a table and  use the "data" tab
       import from the setup/db/<tab>.ddf file in the geonetwork 
installation
    import tables in the order
    Categories, Users, User Groups, Groups, Metadata, Metadataategories, 
Operations, OperationsAllowed
       (foreign keys will fail otherwise.  Commit after each import)
copy a postgresql JDBC jar into web/WEB-INF/lib    
(http://jdbc.postgresql.org)
edit web/WEB-INF/config.xml
    add

>                 <resource enabled="true">
>                         <name>main-db</name>
>                         
> <provider>jeeves.resources.dbms.DbmsPool</provider>
>                         <config>
>                                 <user>geonetwork</user>
>                                 <password>[PASS]</password>
>                                 <driver>org.postgresql.Driver</driver>
>                                 <url>jdbc:postgresql://[HOST]/[DB]</url>
>                                 <poolSize>4</poolSize>
>                         </config>
>                 </resource>

change [HOST] to be your postgresql host name
change [DB] to be your postgresql database name
change [PASS] to be your geonet login password
set all other main-db resources to be enabled="false"

start geonetwork

C.