Re: [Cs-studio-users] ArchiveEngine: schema with PostgreSQL

[Martin K. <ko...@ik...>]

Hi Kay,
> As far as I know, PostgreSQL doesn't need/use the schema, so leave it
> empty.
PostgreSQL supports schemas but if you don't specify one, the 'public'
schema is used automatically:
http://www.postgresql.org/docs/9.1/static/ddl-schemas.html#DDL-SCHEMAS-PUBLIC

So you're right: PostgreSQL does not need a schema but schemas _can_ be
used and the question remains:
>> what's the right way to specify a schema in the configuration when using
>> PostgreSQL? Using the org.csstudio.archive.rdb/schema option in
>> org.csstudio.archive.engine/plugin_customization.ini or using the URL?
>> With version 3.0 I successfully used the schema option and a URL without
>> a schema. But the documentation
>> (http://cs-studio.sourceforge.net/docbook/ch09.html, last sentence) says
>> something about specifying the schema in the URL instead. I'm not sure
>> if this is correct for PostgreSQL...

Best regards

Martin

-- 
Dipl. Phys. Martin Konrad
Technische Universität Darmstadt
Institut für Kernphysik
Schlossgartenstr. 9
64289 Darmstadt
Tel.: +49-6151-16-5121
Fax: +49-6151-16-4321