[postgis] Re: [mapserver-users] Demo using PostGIS ...

[Tyler Mitchell]

>pg_dump --inserts -C -t itasca itasca > itasca.sql

This will only dump an individual table right?  Is that what you recommend?
I would like to dump the whole user.  Would that make it so that I could by
pass your other setup steps?

>then edit the sql file so that (a) the table creation is done by first
>creating the attribute table then running AddGeometryColumn and (b)
>wrapping the inserts with BEGIN and END transaction blocks. You might
>also want to ensure that the geometries have an explicit SRID and that
>an appropriate row exists in SPATIAL_REF_SYS. IE, make it so that
>loading the dump will result in a perfect PostGIS db, requiring no
>fiddling at all.


Tyler



                                                                                                                     
                    Paul Ramsey                                                                                      
                    <pramsey at refrac       To:     postgis at yahoogroups.com                                            
                    tions.net>            cc:                                                                        
                                          Fax to:                                                                    
                    01/22/2002            Subject:     Re: [postgis] Re: [mapserver-users] Demo using PostGIS ...    
                    09:09 AM                                                                                         
                    Please respond                                                                                   
                    to postgis                                                                                       
                                                                                                                     
                                                                                                                     







pg_dump --inserts -C -t itasca itasca > itasca.sql

then edit the sql file so that (a) the table creation is done by first
creating the attribute table then running AddGeometryColumn and (b)
wrapping the inserts with BEGIN and END transaction blocks. You might
also want to ensure that the geometries have an explicit SRID and that
an appropriate row exists in SPATIAL_REF_SYS. IE, make it so that
loading the dump will result in a perfect PostGIS db, requiring no
fiddling at all.

> I'll make a tar.gz and forward it to you Steve, along with a new
demo.map,
> but need some help on the syntax of the pg_dump command.
> Here's what I did - will it suffice?
>
>  pg_dump -C --file=itasca_dump.sql.tar --format t -a --superuser=postgres
> itasca
>
> and here are the files it produced:
>
> 16.dat  19.dat  22.dat  25.dat  28.dat  31.dat
> 17.dat  20.dat  23.dat  26.dat  29.dat  restore.sql
> 18.dat  21.dat  24.dat  27.dat  30.dat  toc.dat
>
>
>                     "Steve Lime"
>                     <steve.lime at dnr.st       To:
<mapserver-users at lists.gis.umn.edu>, <raanders at tincan.org>,
>                     ate.mn.us>                <postgis at yahoogroups.com>
>                                              cc:
>                     01/18/2002 07:27         Fax to:
>                     AM                       Subject:     [postgis] Re:
[mapserver-users] Demo using PostGIS ...
>                     Please respond to
>                     postgis
>
>
>
> It would be interesting to have a postGIS ready version of the
> shapefiles used in
> the itasca demo. Perhaps someone could prepare that? It could be
> distributed,
> along with a PostGIS version of the map file as part of the main demo.
> I'd take
> care of that part if the data were somehow available.
>
> Steve
>
> Stephen Lime
> Data & Applications Manager
>
> Minnesota DNR
> 500 Lafayette Road
> St. Paul, MN 55155
> 651-297-2937
>
> >>> "Roderick A. Anderson" <raanders at tincan.org> 01/17/02 08:15PM >>>
> I'm bringing a new PostgreSQL testbed server online in the next few
> days.  Since I can't seem to find the time to get good PostGIS data
> and
> learn the fun parts of mapserver I'd like to offer access to the
> server
> for the data for a demo using PostGIS and mapserver.  I'll learn by
> copying the work of great minds.
>
>    I'm thinking a readonly database and I may have to throttle it some
> if it starts eating too much bandwidth.
>
> This make sense and is there any interest with these caveats?
>
> Cheers,
> Rod
> --
>                       Let Accuracy Triumph Over Victory
>
>                                                        Zetetic
> Institute
>                                                         "David's
> Sling"
>                                                          Marc Stiegler
>
> To unsubscribe from this group, send an email to:
> postgis-unsubscribe at yahoogroups.com
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
> To unsubscribe from this group, send an email to:
> postgis-unsubscribe at yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_


To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/







------------------------ Yahoo! Groups Sponsor ---------------------~-->
Tiny Wireless Camera under $80!
Order Now! FREE VCR Commander!
Click Here - Only 1 Day Left!
http://us.click.yahoo.com/WoOlbB/7.PDAA/ySSFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/