[MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema

[Carlos Ruiz]

Ritesh,
 
There's a way to stablish the default schema to a postgres user when it connects, maybe this can help you to pull the data from postgres.
 
To check what's the current default user's schema, you need to execute this:
 
SHOW search_path
 
It must throw $user, public
 
So, to set the default user's schema, you execute this:
 
ALTER USER <user_name> SET search_path TO <schema_name>
 
I suggest you to create a new role to connect to the database via map file, and then 
change its default schema.
 
Another thing (maybe this was the first step) is to check if the user postgres is the owner 
of the schema, and if it's not, then check if it haves the USAGE privilege on it.
 
Hope this information helps

IC Carlos Ruiz
 

--- On Wed, 7/16/08, Ritesh Ambastha <group.ritesh at gmail.com> wrote:

From: Ritesh Ambastha <group.ritesh at gmail.com>
Subject: RE: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema
To: mapserver-users at lists.osgeo.org
Date: Wednesday, July 16, 2008, 4:37 AM

Hey Venkat,

Thanks for the details. 
I understand the standard way to write a connection parameter. 

I am sure that this table "rgp_gis_gmm_100_metros" is stored in
"public"
schema of your database. 

My question is, what will you write if you keep this table in some other
schema?

Regards,


Venkatrao wrote:
> 
> Hi,
> Here is my Example .I think it helps you.
> 
> Layer # Layer starts here
>   Name "GMM 100" #name of the layer
>   ConnectionType POSTGIS #connection type
>   Connection "host=192.168.1.158 dbname=GIS password=administrator
> user=postgres port=5432" #connection type.
>   Data "the_geom from rgp_gis_gmm_100_metros"   #table name
> 
> Thanks and Regards
> Venkat.
> 
> 
> 
> 
> 
> -----Original Message-----
> From: mapserver-users-bounces at lists.osgeo.org
> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Ritesh
> Ambastha
> Sent: Wednesday, July 16, 2008 2:44 PM
> To: mapserver-users at lists.osgeo.org
> Subject: [MAPSERVER-USERS] Connection parameter errors while using
> Postgres
> DB Schema
> 
> 
> Hello Readers, 
> 
> I am facing a problem in defining the DATA path in mapserver while using
> PostGIS. 
> 
> I have two schemas, lets say 'a' and 'b' in a database
'd'
> 
> Now, I want to access tables of schema 'a' in the mapserver layer.

> 
> I define DATA path like this: 
> 
> DATA "the_geom FROM a.table_name USING UNIQUE id SRID -1" 
> 
> Please pour in your thoughts for defining schema in the connection/data
> parameters.
> 
> Thanks,
> Ritesh Ambastha
> -- 
> View this message in context:
>
http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc
> hema-tp18483547p18483547.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 

-- 
View this message in context:
http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Schema-tp18483547p18483876.html
Sent from the Mapserver - User mailing list archive at Nabble.com.

_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080716/59e9e61e/attachment.htm>