Thread: install postgis in linux server without desktop

install postgis in linux server without desktop

From
shane_china
Date:
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.


Re: install postgis in linux server without desktop

From
Sachin Srivastava
Date:
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


Re: install postgis in linux server without desktop

From
"Joshua D. Drake"
Date:
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

Re: install postgis in linux server without desktop

From
shane_china
Date:
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.


Re: install postgis in linux server without desktop

From
shane_china
Date:
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.


Re: install postgis in linux server without desktop

From
"Joshua D. Drake"
Date:
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



Re: install postgis in linux server without desktop

From
Robert Dörfler
Date:
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



Re: install postgis in linux server without desktop

From
shane_china
Date:
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.


Re: install postgis in linux server without desktop

From
Robert Dörfler
Date:
> Thank you very much, I successfully install postgis.

no problem ;)

--
Greetings,
Robert