[Talk-de] Hilfe bei Postgres Installation für Osmosis

[Alexander Matheisen]

Am Sonntag, den 23.01.2011, 18:22 +0100 schrieb Thomas Ineichen:
> Hallo Alex,
> 
> > psql:script/pgsql_simple_schema_0.6.sql:40: FEHLER:
> > AddGeometryColumns() - invalid SRID
> > KONTEXT:  SQL statement "SELECT AddGeometryColumn('','', $1 , $2 , $3 ,
> > $4 , $5 )"
> > PL/pgSQL-Funktion »addgeometrycolumn« Zeile 4 bei SQL-Anweisung
> 
> Ich habe heute Nachmittag ebenfalls mit Osmosis herumgespielt und  
> wollte das Wiki eigentlich heute Abend verbessern:

Da warst du wohl nicht schnell genug... ;)

Danke jedenfalls, jetzt klappt zumindest das anlegen. Leider
funktioniert aber noch nicht das einspielen mit osmosis:

osmosis-0.38/bin/osmosis --rx 20110122.osm --wp host=localhost
database=osm user=osm password=osm


23.01.2011 18:45:27 org.openstreetmap.osmosis.core.Osmosis run
INFO: Osmosis Version 0.38
23.01.2011 18:45:29 org.openstreetmap.osmosis.core.Osmosis run
INFO: Preparing pipeline.
23.01.2011 18:45:29 org.openstreetmap.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
23.01.2011 18:45:29 org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
23.01.2011 18:45:56
org.springframework.beans.factory.xml.XmlBeanDefinitionReader
loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource
[org/springframework/jdbc/support/sql-error-codes.xml]
23.01.2011 18:45:57
org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL,
MySQL, Oracle, PostgreSQL, Sybase]
23.01.2011 18:45:57
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion
SCHWERWIEGEND: Thread for task 1-rx failed
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
SQL grammar [SELECT version FROM schema_info]; nested exception is
org.postgresql.util.PSQLException: FEHLER: keine Berechtigung für
Relation schema_info
	at
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
	at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
	at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455)
	at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:463)
	at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:471)
	at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:476)
	at
org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:485)
	at
org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForInt(SimpleJdbcTemplate.java:113)
	at
org.openstreetmap.osmosis.pgsnapshot.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:64)
	at
org.openstreetmap.osmosis.pgsnapshot.common.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:47)
	at
org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.CopyFilesetLoader.run(CopyFilesetLoader.java:78)
	at
org.openstreetmap.osmosis.pgsnapshot.v0_6.PostgreSqlCopyWriter.complete(PostgreSqlCopyWriter.java:108)
	at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:110)
	at java.lang.Thread.run(Thread.java:636)
Caused by: org.postgresql.util.PSQLException: FEHLER: keine Berechtigung
für Relation schema_info
	at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
	at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
	at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
	at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
	at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
	at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
	at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
	at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
	at org.springframework.jdbc.core.JdbcTemplate
$1QueryStatementCallback.doInStatement(JdbcTemplate.java:440)
	at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
	... 12 more
23.01.2011 18:45:57 org.openstreetmap.osmosis.core.Osmosis main
SCHWERWIEGEND: Execution aborted.
org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more
tasks failed.
	at
org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)
	at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)
	at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:616)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:329)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
	at
org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
	at org.codehaus.classworlds.Launcher.main(Launcher.java:31)



Alex