[GRASS-user] Navicat PostGRESQL and MYSQL

[Andreas Neumann]

Hi Kurt,

Yes, PostgreSQL/Postgis is definitely more powerful and tested for 
geographic data than MySQL and SQLite. Also PGAdminIII is a good piece 
of software. There is an installer for PgadminIII for OSX which runs 
withouth problem.

I did a PostgreSQL/Postgis install on OSX (compiled from source) several 
times, following the instructions here: 
http://www.faqs.org/docs/ppbook/x486.htm - although this is written for 
version 7 of Postgresql, the procedure is still the same. Here is also 
an installation tutorial: 
http://www.postgresql.org/docs/8.2/interactive/install-short.html It 
requires the Unix development tools (which you can install from the 
Apple Developers CD) and some Unix knowhow, but other than that its a 
step by step thing. I didn't have problems with it.

After installing, be sure to allow network access from other computers 
by following the instructions here: 
http://www.postgresql.org/docs/8.2/interactive/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS 
(postgresql.conf)

and here (pg_hba.conf):

http://www.postgresql.org/docs/8.2/interactive/client-authentication.html

Hope this helps,
Andreas

Kurt Springs wrote:

> Thanks everyone who answered.  Because of its reputed power in GIS I  
> would opt for PostGRESQL with PostGIS and an pgadmin front end.   
> However I have had trouble in the past trying to install PostGRESQL  
> and could never get it quite right.  I use a Mac with OS X, and it  
> requires me to open two accounts on the operating system, and even  
> following written directions to the letter, it never came out useable  
> and all I ended up doing is taking up space on my hard drive to no  
> useful purpose.  Has anyone else had a similar experience and found  
> away around these problems?  I wish I could describe what was said,  
> but it was some years ago.  After that experience I had been  
> reluctant to try again.
>
> Is MYSQL any easier to install?  Also, has anyone had success with  
> SQL Lite Browser?
>
> Thanks for the advice.
>
> Kurt
>
> _______________________________________________
> grassuser mailing list
> grassuser at grass.itc.it
> http://grass.itc.it/mailman/listinfo/grassuser



-- 
----------------------------------------------
Andreas Neumann
Institute of Cartography
ETH Zurich
Wolfgang-Paulistrasse 15
CH-8093  Zurich, Switzerland

Phone: ++41-44-633 3031, Fax: ++41-44-633 1153
e-mail: neumann at karto.baug.ethz.ch
www: http://www.carto.net/neumann/
SVG.Open: http://www.svgopen.org/
Carto.net: http://www.carto.net/