ReIndex available layers in a PostgreSQL Store?

View: New views
2 Messages — Rating Filter:   Alert me  

ReIndex available layers in a PostgreSQL Store?

by Jeffrey Johnson-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi All,

I am using GeoServer 2.0-RC2 ... and have a basic question. When I add
a Postgres DB as a store, it appears that geoserver makes some sort of
index of the available layers in that DB. I have poked around in my
webapps dir to find where that is stored, but came up empty. When I
add a new table to my DB by some other means (ogr2ogr in this case), I
see no way to regenerate that index so that I can create a GeoServer
layer from that new table in the DB. Is there someway to regenerate
this index of available tables/layers?

Thanks,

Jeff

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: ReIndex available layers in a PostgreSQL Store?

by Justin Deoliveira-6 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Jeff,

This index you are looking for is stored in memory. This is a known
issue already reported in GeoTools which should be fixed for 2.0.1:

http://jira.codehaus.org/browse/GEOT-2732

-Justin

Jeffrey Johnson wrote:

> Hi All,
>
> I am using GeoServer 2.0-RC2 ... and have a basic question. When I add
> a Postgres DB as a store, it appears that geoserver makes some sort of
> index of the available layers in that DB. I have poked around in my
> webapps dir to find where that is stored, but came up empty. When I
> add a new table to my DB by some other means (ogr2ogr in this case), I
> see no way to regenerate that index so that I can create a GeoServer
> layer from that new table in the DB. Is there someway to regenerate
> this index of available tables/layers?
>
> Thanks,
>
> Jeff
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

> Hi All,
>
> I am using GeoServer 2.0-RC2 ... and have a basic question. When I add
> a Postgres DB as a store, it appears that geoserver makes some sort of
> index of the available layers in that DB. I have poked around in my
> webapps dir to find where that is stored, but came up empty. When I
> add a new table to my DB by some other means (ogr2ogr in this case), I
> see no way to regenerate that index so that I can create a GeoServer
> layer from that new table in the DB. Is there someway to regenerate
> this index of available tables/layers?
>
> Thanks,
>
> Jeff
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users