<html><div style='background-color:'><DIV>Hi Craig,</DIV>
<DIV> </DIV>
<DIV>I recive your message and I don't find the source of postgresql, I installed Postgresql from CD ports then this lines don't function</DIV>
<DIV> </DIV>
<DIV># gmake PGSQL_SRC=/usr/ports/databases/postgresql7/work/postgresql-7.3.4<BR># gmake PGSQL_SRC=/usr/ports/databases/postgresql7/work/postgresql-7.3.4<BR>install<BR></DIV>
<DIV>and when I run only gmake I have this message:</DIV>
<DIV>Makefile:27:../../src/Makefile.global:No such file or directory</DIV>
<DIV>Makefile:111:/src/Makefile.shlib:no such file or directory</DIV>
<DIV>gmake: *** No rule to make target '/src/Makefile.shlib' stop</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>I have FreeBSD4.8, postgresql-7.3.2 for example I can installed without problem the proj4</DIV>
<DIV> </DIV>
<DIV>Regards, </DIV>
<DIV>Ricardo</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////</DIV>
<DIV>Craig wrote</DIV>
<DIV>Here are some notes I took last week.<BR><BR>Install FreeBSD 4.8<BR><BR>cvsup the ports collection<BR><BR>Do the following as root E.g.<BR>$ su -<BR>Password: <enter your password><BR># cd /root<BR><BR>Install postgresql<BR><BR>cd /usr/ports/databases/postgresql7<BR>make<BR>make install<BR><BR>Install proj4<BR>cd /root<BR>fetch <A href="ftp://ftp.remotesensing.org/pub/proj/proj-4.4.7.tar.gz">ftp://ftp.remotesensing.org/pub/proj/proj-4.4.7.tar.gz</A><BR>gzip -dc proj-4.4.7.tar.gz | tar xvf -<BR>cd proj-4.4.7<BR>./configure<BR>make<BR>make install<BR><BR>Install postgis<BR># cd /root<BR># fetch <A href="http://postgis.refractions.net/postgis-0.7.5.tar.gz">http://postgis.refractions.net/postgis-0.7.5.tar.gz</A><BR># gzip -dc postgis-0.7.5.tar.gz | tar xvf -<BR># cd postgis-0.7.5<BR><BR># vi Makefile<BR>/USE_PROJ=0<BR>:<I>s/USE_PROJ=0/USE_PROJ=1/<BR></I>:<I>wq<BR></I><BR># gmake PGSQL_SRC=/usr/ports/databases/postgresql7/work/postgresql-7.3.4<BR># gmake PGSQL_SRC=/usr/ports/databases/postgresql7/work/postgresql-7.3.4<BR>install<BR><BR>Initialize PostgreSQL<BR># cd /usr/local/share/postgresql<BR># su -l pgsql -c "initdb -E UNICODE"<BR># /usr/local/etc/rc.d/010.pgsql.sh start<BR><BR>Enable remote access<BR>edit ~pgsql/data/postgresql.conf<BR>uncomment tcpip=false, and change it to tcpip=true<BR>edit ~pgsql/data/pg_hba.conf and add an entry to trust the host you want<BR>to connect from.<BR># su -l pgsql pg_ctl restart<BR><BR>Read a few docs -- get familiar<BR>For postmaster settings, see /usr/local/pgsql/data/postgresql.conf<BR>For more tips, read /usr/local/pgsql/post-install-notes<BR>For complete PostgreSQL docs, look in /usr/local/share/postgresql<BR>For PostGIS docs, look in /usr/local/share/postgresql/contrib<BR><BR>Play with it<BR><BR>Create your database<BR># cd /usr/local/share/postgresql/contrib<BR># su -l pgsql -c "createdb -E UNICODE <yourtestdatabase>"<BR><BR>Add plpgsql support<BR># su -l pgsql -c "createlang plpgsql <yourtestdatabase>"<BR><BR>Add all the postgis extensions, and create the postgis tables (e.g.<BR>spatial ref sys.<BR># su -l pgsql -c "psql -d <yourtestdatabase> -f<BR>/usr/local/share/postgresql/contrib/postgis.sql"<BR><BR>Populate the Spatial Ref System tables.<BR># su -l pgsql -c "psql -d <yourtestdatabase> -f<BR>/usr/local/share/postgresql/contrib/spatial_ref_sys.sql"<BR><BR></DIV></div><br clear=all><hr>¿Estás buscando un auto nuevo? <a href="http://g.msn.com/8HMBES/2752??PS=">Haz clic aquí...</a> </html>