Thank you all, very useful posts.
On Tue, Apr 13, 2010 at 9:14 AM, <pcr...@pcreso.com> wrote: > Hi Vasile, > > > createdb -T [template] [name_of_the_database] > > This creates a new database in a working Postgres instalation. > > The -T is an optional parameter allowing you to specify a template database > to base the new one on. You can create a template database as a custom > Postgres database with whatever special facilities you may desire to be > automatically provided in a new database you create, by using it as the > template. You do not need to use this to create a Postgis database (but you > can if you so desire) > > For example just use createdb dbname to create a new database called > dbname. > > A Postgres database newly created without specifyinfg a suitable custom > template will not have support for the plpgsql language installed in the > database. Postgis is basically written in this language, so you need to add > it to the Postgres database before adding Postgis, using createlang plpgsql > [database] > > You can add Postgis without running > psql -d [database] -f /usr/share/postgresql/8.4/contrib/spatial_ref_sys.sql > but generally I would not. This command creates a table in the Postgis > database called spatial_ref_sys, which contains information about standard > projections to enable Postgis to transform (reproject) spatial objects from > one datum/projection to another. > > These steps (along with psql -d [database] -f > /usr/share/postgresql/8.4/contrib/postgis.sql) > will create a Postgis, or spatially enabled Postgres database which is > capable of storing, querying & manipulating spatial objects (geometries), > but will not create any geometries in the database. You have the facilities > to manage spatial data, but have not yet added any such data to the new > database. > > The documentation available at www.postgis.org is a good place to start, > and various books also provide information on using Postgis, including: > > Web Mapping Illustrated: Using Open Source GIS > Toolkits<http://www.amazon.com/Web-Mapping-Illustrated-Source-Toolkits/dp/0596008651/ref=sr_1_1?ie=UTF8&s=books&qid=1271142583&sr=1-1> > by > Tyler > Mitchell<http://www.amazon.com/Tyler-Mitchell/e/B001IXUH7Y/ref=sr_ntt_srch_lnk_1?_encoding=UTF8&qid=1271142583&sr=1-1> > PostGIS in > Action<http://www.amazon.com/PostGIS-Action-Regina/dp/1935182269/ref=sr_1_2?ie=UTF8&s=books&qid=1271142583&sr=1-2> > by > Regina and Leo Hsu (being written) > <http://www.amazon.com/Beginning-MapServer-Source-Development-Experts/dp/1590594908/ref=sr_1_3?ie=UTF8&s=books&qid=1271142583&sr=1-3> > Beginning MapServer: Open Source GIS > Development<http://www.amazon.com/Beginning-MapServer-Source-Development-Experts/dp/1590594908/ref=sr_1_3?ie=UTF8&s=books&qid=1271142583&sr=1-3>by > Bill Kropla > Desktop GIS: Mapping the Planet with Open Source > Tools<http://www.amazon.com/Desktop-GIS-Mapping-Planet-Source/dp/1934356069/ref=sr_1_6?ie=UTF8&s=books&qid=1271142583&sr=1-6> > by > Gary > Sherman<http://www.amazon.com/Gary-Sherman/e/B002BMKE8I/ref=sr_ntt_srch_lnk_6?_encoding=UTF8&qid=1271142583&sr=1-6> > Open Source Approaches in Spatial Data Handling (Advances in Geographic > Information > Science)<http://www.amazon.com/Approaches-Handling-Advances-Geographic-Information/dp/354074830X/ref=sr_1_9?ie=UTF8&s=books&qid=1271142583&sr=1-9> > by > Brent Hall and Michael G. Leahy > > HTH, > > Brent Wood > > --- On *Fri, 4/9/10, Vasile Cristian Stan <vasilees...@gmail.com>* wrote: > > > From: Vasile Cristian Stan <vasilees...@gmail.com> > > Subject: [postgis-users] steps in creating a new database > To: postgis-users@postgis.refractions.net > Date: Friday, April 9, 2010, 10:10 PM > > > Hi all, > > > I try to create a new postgis database on Ubuntu, and I'm quite confused > about the steps in creating a database. > > > Creating database: > # createdb -T [template] [name_of_the_database] > > - what are the use [-T] and [template] in this line > - I can create my own template? for example: # createdb -T [general_data] > [world] > > Adding plpsql language to the database: > > # createlang plpgsql [database] > > # psql -d [database] -f /usr/share/postgresql/8.4/contrib/postgis.sql > > # psql -d [database] -f > /usr/share/postgresql/8.4/contrib/spatial_ref_sys.sql > > # psql -d [database] -c"select postgis_lib_version();" > > > - is plpgsql a condition in creating a geodatabase > - what's happening if I don't add this line # psql -d [database] -f > /usr/share/postgresql/8.4/contrib/spatial_ref_sys.sql > > - This are the complete steps in creating a spatial database? > - Where i can find more information regarding this subject? > > > Thank you, > Cristian > > > -----Inline Attachment Follows----- > > _______________________________________________ > postgis-users mailing list > > postgis-users@postgis.refractions.net<http://mc/compose?to=postgis-us...@postgis.refractions.net> > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
