|
From: Carl A. <car...@va...> - 2006-01-15 18:25:09
|
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.
|