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.
Excellent! Thanks for that contribution!
One comment should be added. To get the sample metadata and the templates for the local system to work, you should manually enter the metadata table and change the variables in the source column to reflect the SiteID of your installation for each metadata where the value is still [$SITE_ID].
Ciao,
Jeroen
On 15 Jan 2006, at 19:24, Carl Anderson wrote:
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.
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geonetwork-devel mailing list
Geonetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork