Re: PostGIS extension

From: Prince Pathria <prince(dot)pathria(at)goevive(dot)com>
To: pierreochsenbein(at)gmail(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostGIS extension
Date: 2018-09-20 11:33:12
Message-ID: CAON0DaztpknmYJB2T+YeHgdzaKm+8AvM3Y_sDikwnjYA4Fga4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)pathria(at)goevive(dot)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(at)gmail(dot)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
>>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Boriss Mejias 2018-09-20 11:43:52 Re: Repmgr 4, 2 primary servers in cluster
Previous Message Prince Pathria 2018-09-20 11:30:07 Re: PostGIS extension