hi,
as of GeoNetwork 2.6 the DB will be created automatically on application
start-up, if it doesn't already exist; however that version is not yet
released, and as you're on GN 2.4.3, that doesn't help you much now.
You could use the program called "GAST", which is a Java desktop (Swing)
application, to manage the creation of your database and it will also insert
the necessary minimal data into it.
Some people find its interface somewhat less than intuitive, but I think
it's your best option at the moment.
To run it : type java -jar <installation-dir>/gast/gast.jar in a command
line. When started, click around until you find out where to set your
database vendor and JDBC credentials, then run "setup database". If you get
errors about circular references, ignore them, they're expected.
Hope this helps,
Kind regards
Heikki Doeleman
On Wed, Jul 28, 2010 at 1:37 PM, Sarah Schuessler <sarah_flip@anonymised.com>wrote:
Hi,
to your first question I can`t say something but second question is that
user/passw have to be the one at postgres user/passw.
HTH
best regards
Sarah
________________________________
heikki,
thank you for your quick reply. Do I have to create the database
"yourDatabaseName" before or will it be created qutomatically? And do
the user/pass have to be admin/admin or do they correspond with the
database user i.e. "postgres"? I am new to this and by now, finally,
totally confused.
Jan
Zitat von heikki <tropicano@anonymised.com>:
> hi,
>
> for example:
>
> <!-- - - - - - - - - - - - - - - - - - - - - - - - - - -
- -
> - - -->
> <!-- postgres -->
> <!-- - - - - - - - - - - - - - - - - - - - - - - - - - -
- -
> - - -->
>
> <resource enabled="true">
> <name>main-db</name>
>
<provider>jeeves.resources.dbms.DbmsPool</provider>
> <config>
> <user>yourUserName</user>
> <password>yourPassword</password>
> <driver>org.postgresql.Driver</driver>
>
> <url>jdbc:postgresql://localhost:5432/yourDatabaseName</url>
> <poolSize>10</poolSize>
> <reconnectTime>3600</reconnectTime>
> </config>
> </resource>
>
>
> Note that exactly one of the <resource> elements should have
enabled="true",
> so if you add something like this, make sure to disable (or comment) the
> ones that were there already.
>
> Kind regards
> Heikki Doeleman
>
>
>
> On Tue, Jul 27, 2010 at 2:40 PM, Jan Saalbach <fire@anonymised.com>
wrote:
>
>> Hi all,
>> sorry it took me so long to reply to your suggestions how to fix the
>> connection to the database. I just did not have time to get to this
>> issue and the problem persists. So I just checked JDBC settings in
>> config.xml and it seems that there is no specific case for postgresql,
>> which I would like to use. Under <resources>
>> there are the following parts:
>>
>> <!-- mckoi standalone -->
>> <!-- mysql -->
>> <!-- oracle -->
>>
>> How do I configure GN to work with postgresql?
>>
>> Regards,
>> Jan
>>
>> ubuntu 9.10
>> geonetwork 2.4.3
>>
>>
>>
>>
>>
------------------------------------------------------------------------------
>> The Palm PDK Hot Apps Program offers developers who use the
>> Plug-In Development Kit to bring their C/C++ apps to Palm for a share
>> of $1 Million in cash or HP Products. Visit us here for more details:
>> http://ad.doubleclick.net/clk;226879339;13503038;l?
>> http://clk.atdmt.com/CRS/go/247765532/direct/01/
>> _______________________________________________
>> GeoNetwork-users mailing list
>> GeoNetwork-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>> GeoNetwork OpenSource is maintained at
>> http://sourceforge.net/projects/geonetwork
>>
>
------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://ad.doubleclick.net/clk;226879339;13503038;l?
http://clk.atdmt.com/CRS/go/247765532/direct/01/
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork
------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://ad.doubleclick.net/clk;226879339;13503038;l?
http://clk.atdmt.com/CRS/go/247765532/direct/01/
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork