Thread: install postgis in linux server without desktop
I want to know is there any way can install postgis for postgresql so easily, just like one click bin on Ubuntu using command line? I know there is a tool called stack builder which work after version 8.2 for easily installing extensions, I have tried, but it seem doesnt work under command line. I don't know how to install postgis on ubuntu? I go to postgis website and find the install method is complicated, need me to compile three or more things. -- View this message in context: http://www.nabble.com/install-postgis-in-linux-server-without-desktop-tp25258662p25258662.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On 09/02/2009 08:20 PM, shane_china wrote: > I want to know is there any way can install postgis for postgresql so easily, > just like one click bin on Ubuntu using command line? > > I know there is a tool called stack builder which work after version 8.2 for > easily installing extensions, I have tried, but it seem doesnt work under > command line. > > I don't know how to install postgis on ubuntu? I go to postgis website and > find the install method is complicated, need me to compile three or more > things. > use the stackbuilder to get hold of the postgis installer binary. (It gets downloaded in /tmp by default). Then use the binary with "--mode text" as an option. Check --help for all options available. -- Regards, Sachin Srivastava www.enterprisedb.com
On Wed, 2009-09-02 at 22:23 +0530, Sachin Srivastava wrote: > On 09/02/2009 08:20 PM, shane_china wrote: > > I want to know is there any way can install postgis for postgresql so easily, > > just like one click bin on Ubuntu using command line? sudo apt-get install postgresql-8.3-postgis Then there will likely be something to the affect of: psql -U <user> <db> < /usr/share/postgresql/8.3/contrib/postgis.sql (or something like that) Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering
I do follow your instruction. I successfully install postgis, but I can't find postgis.sql under any folder. My postgresql installed by apt-get. After apt-get postgis, What should I to do? Only execute sql in postgis.sql? Joshua D. Drake wrote: > > On Wed, 2009-09-02 at 22:23 +0530, Sachin Srivastava wrote: >> On 09/02/2009 08:20 PM, shane_china wrote: >> > I want to know is there any way can install postgis for postgresql so >> easily, >> > just like one click bin on Ubuntu using command line? > > sudo apt-get install postgresql-8.3-postgis > > Then there will likely be something to the affect of: > > psql -U <user> <db> < /usr/share/postgresql/8.3/contrib/postgis.sql (or > something like that) > > Joshua D. Drake > > > -- > PostgreSQL.org Major Contributor > Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 > Consulting, Training, Support, Custom Development, Engineering > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://www.nabble.com/install-postgis-in-linux-server-without-desktop-tp25258662p25267637.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
How to "use the stackbuilder to get hold of the postgis installer binary", could you explain it more exactly? I execute stackbuilder, but there is an error root@ubuntu-yingxia:/opt/PostgreSQL/8.4/stackbuilder/bin# ./stackbuilder ./stackbuilder: error while loading shared libraries: libgtk-x11-2.0.so.0: cannot open shared object file: No such file or directory thank you for help Sachin Srivastava-2 wrote: > > On 09/02/2009 08:20 PM, shane_china wrote: >> I want to know is there any way can install postgis for postgresql so >> easily, >> just like one click bin on Ubuntu using command line? >> >> I know there is a tool called stack builder which work after version 8.2 >> for >> easily installing extensions, I have tried, but it seem doesnt work under >> command line. >> >> I don't know how to install postgis on ubuntu? I go to postgis website >> and >> find the install method is complicated, need me to compile three or more >> things. >> > use the stackbuilder to get hold of the postgis installer binary. (It > gets downloaded in /tmp by default). > Then use the binary with "--mode text" as an option. Check --help for > all options available. > > -- > Regards, > Sachin Srivastava > www.enterprisedb.com > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://www.nabble.com/install-postgis-in-linux-server-without-desktop-tp25258662p25267681.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Wed, 2009-09-02 at 22:23 +0530, Sachin Srivastava wrote: > On 09/02/2009 08:20 PM, shane_china wrote: > > I want to know is there any way can install postgis for postgresql so easily, > > just like one click bin on Ubuntu using command line? sudo apt-get install postgresql-8.3-postgis Then there will likely be something to the affect of: psql -U <user> <db> < /usr/share/postgresql/8.3/contrib/postgis.sql (or something like that) Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering
Am Mittwoch, den 02.09.2009, 16:54 -0700 schrieb shane_china: > I do follow your instruction. I successfully install postgis, but I can't > find postgis.sql under any folder. > My postgresql installed by apt-get. > > After apt-get postgis, What should I to do? Only execute sql in > postgis.sql? > Already checked: http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/ ? -- Greetings, Robert
Thank you very much, I successfully install postgis. Robert Dörfler wrote: > > Am Mittwoch, den 02.09.2009, 16:54 -0700 schrieb shane_china: >> I do follow your instruction. I successfully install postgis, but I can't >> find postgis.sql under any folder. >> My postgresql installed by apt-get. >> >> After apt-get postgis, What should I to do? Only execute sql in >> postgis.sql? >> > > Already checked: > http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/ ? > > -- > Greetings, > Robert > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://www.nabble.com/install-postgis-in-linux-server-without-desktop-tp25258662p25274835.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
> Thank you very much, I successfully install postgis. no problem ;) -- Greetings, Robert