PostGIS vs. Shapefile

[Daniele Margotti]

My connection string is:

DATA "the_geom from my_table01"
CONNECTION "user=postgres dbname=my_database host=localhost port=5432"
CONNECTIONTYPE postgis

Where can I find logs?
I installed PostgreSQL via RPMs, which did put the program in
/var/lib/pgsql:

# ls -al /var/lib/pgsql/data/
totale 52
drwx------    6 postgres postgres     4096 10 feb 16:37 .
drwx------    4 postgres postgres     4096 10 feb 17:02 ..
drwx------    5 postgres postgres     4096 10 feb 12:38 base
drwx------    2 postgres postgres     4096 11 feb 09:09 global
drwx------    2 postgres postgres     4096  8 feb 15:57 pg_clog
-rw-------    1 postgres postgres     2572 10 feb 10:13 pg_hba.conf
-rw-------    1 postgres postgres     1441  8 feb 15:58 pg_ident.conf
-rw-------    1 postgres postgres        4  8 feb 15:57 PG_VERSION
drwx------    2 postgres postgres     4096 10 feb 13:09 pg_xlog
-rw-------    1 postgres postgres     5238  9 feb 14:03 postgresql.conf
-rw-------    1 postgres postgres       32 10 feb 15:17 postmaster.opts
-rw-------    1 postgres postgres       45 10 feb 15:17 postmaster.pid

In pg_clog and pg_xlog I have no text logs, only data files that are not
comprehensible.

        Daniele



-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of Umberto Nicoletti
Sent: Friday, February 11, 2005 8:29 AM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] PostGIS vs. Shapefile


Ciao Daniele,
Could be a name resolution problem. Are you using an ip address or a
host name to specify the postgres connection string? If you are using a
name please make sure that it can be resolved correctly by registering
it in dns and/or in the /etc/hosts file.

Did you try localhost in the connection string?
Also have a look at the log files in /var/lib/postgres/data.

HTH,
Umberto

On Thu, 2005-02-10 at 17:01 +0100, Daniele Margotti wrote:
> Yes, Mapserver is in the same computer of PostGIS: a Linux Red Hat 9.
> Computer is rather fast: I can dump a 33000-row table (14 Mb dumped to
> file) in about 3 seconds.
>
> And also when I connect from a Windows XP (via Lan) using ODBC
> drivers, data are read very fast.
>
> Only Mapserver is slow...
>
>         Daniele
>
>
> >-----Original Message-----
> >From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU]
> On Behalf Of Lyndon Tiu
> >Sent: Thursday, February 10, 2005 4:36 PM
> >To: MAPSERVER-USERS at LISTS.UMN.EDU
> >Subject: Re: [UMN_MAPSERVER-USERS] PostGIS vs. Shapefile
> >
> >
> >On February 10, 2005 02:03 am, Daniele Margotti wrote:
> >> Hi all,
> >> I have made some spatial queries (with cgi-bin Mapserver 4.2.3)
> >> alternately with data stored in shapefiles and PostGIS (imported
> >> from
>
> >> these shapefiles).
> >>
> >> My query (304 elements on 5 layers) takes 5 seconds (elaboration,
> >> and
>
> >> then output on browser) if data are read from shapefiles, and about
> 50
> >> seconds if data are read from PostGIS.
> >>
> >> The query is the same: I simply press "reload" on my browser (after

> >> manually changed .map file and query template files) to be sure of
> >> it...
> >>
> >> Is it normal?
> >>
> >
> >Is Postgis in the same computer as mapserver?
> >
> >--
> >Lyndon Tiu
> >
--
Umberto Nicoletti <unicoletti at prometeo.it>
Prometeo SRL