Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostGIS extension

PostGIS extension

From
Pierre Ochsenbein
Date:
Hey Guy's

I Have install my PostGIS extension on my instance and I would like to try if it's works fine.
Any idea?

Thx

Re: PostGIS extension

From
Prince Pathria
Date:
Just a random query but this requires postgis to be installed. And don't forget to install it on standby's as well(if you're using replication)

select st_distance(st_makepoint(42.636002, -78.042527)::geography, st_makepoint( 42.582562, -77.941819 )::geography);

Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com


On Thu, Sep 20, 2018 at 3:11 PM Pierre Ochsenbein <pierreochsenbein@gmail.com> wrote:
Hey Guy's

I Have install my PostGIS extension on my instance and I would like to try if it's works fine.
Any idea?

Thx

Re: PostGIS extension

From
Prince Pathria
Date:
or use \dx on that db to verify which extensions are enabled on that specific db.
Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com


On Thu, Sep 20, 2018 at 5:00 PM Prince Pathria <prince.pathria@goevive.com> wrote:
Just a random query but this requires postgis to be installed. And don't forget to install it on standby's as well(if you're using replication)

select st_distance(st_makepoint(42.636002, -78.042527)::geography, st_makepoint( 42.582562, -77.941819 )::geography);

Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com


On Thu, Sep 20, 2018 at 3:11 PM Pierre Ochsenbein <pierreochsenbein@gmail.com> wrote:
Hey Guy's

I Have install my PostGIS extension on my instance and I would like to try if it's works fine.
Any idea?

Thx

Re: PostGIS extension

From
Shreeyansh Dba
Date:
Hi Pierre,
Go through this link. hope this will help you
https://postgis.net/docs/postgis_installation.html#make_install_postgis_extensions




On Thu, Sep 20, 2018 at 3:11 PM Pierre Ochsenbein <pierreochsenbein@gmail.com> wrote:
Hey Guy's

I Have install my PostGIS extension on my instance and I would like to try if it's works fine.
Any idea?

Thx

Re: PostGIS extension

From
Pierre Ochsenbein
Date:
Thanks a lot for your feedback !

Best,
Pierre Ochsenbein

Le jeu. 20 sept. 2018 à 15:12, Shreeyansh Dba <shreeyansh2014@gmail.com> a écrit :
Hi Pierre,
Go through this link. hope this will help you
https://postgis.net/docs/postgis_installation.html#make_install_postgis_extensions




On Thu, Sep 20, 2018 at 3:11 PM Pierre Ochsenbein <pierreochsenbein@gmail.com> wrote:
Hey Guy's

I Have install my PostGIS extension on my instance and I would like to try if it's works fine.
Any idea?

Thx


--
Cordialement,

Pierre Ochsenbein
Mobile: +33668295394