[OSM-Devserver] Missing osmosisci user

[Brett Henderson]

Hi Sven,

2011/7/1 Sven Geggus <lists at fuchsschwanzdomain.de>

> Brett Henderson <brett at bretth.com> wrote:
>
> > The osmosis continuous integration build is failing due to a missing
> > osmosisci user on the PostgreSQL database.  Is this a known issue?
>
> Not a known issue but unsurprising since the new Postgresql 9.0 database
> has
> been set up from scratch. I just created a osmosisci user for you.
> Which permissions do you need for osmosisci? Will you need password
> autentication?
>

Thanks for this.

I think normal ident authentication will be fine.  I am fairly that's what I
was using on the old database.

osmosisci needs the ability to create tables in its own databases, but
shouldn't need anything special outside of that.


>
> > Can anybody confirm if the following databases still exist?
> >
> >   - osmosisci_api06
> >   - osmosisci_pgsql06
>
> I did not migrate any old databases from the old database to the new one.
> Dump files from the old Databases are availabel in /osm/database-dumps/
>

Can you please create two new empty databases with the above names?  They
need postgis and hstore extensions installed.  I have scripts to install
from that point forwards.

Brett
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.openstreetmap.de/pipermail/devserver/attachments/20110704/772bff1d/attachment.htm>