Re: [postgis-users] encryption of PostGIS databases

2011-05-12 Thread Ben Madin 
You can use the pgctrypto functions from contrib, but you might be better off 
securing the database and connections to it, rather than encrypting the data. 
Apart from the overhead of encrypting and decrypting the large volumes of data 
typically associated with geometry, I suspect your indexing would suffer.

cheers

Ben



On 12/05/2011, at 8:30 PM, Malm Paul wrote:

> Hi,
> Is there a way to protect geographical data by encrypt the GIS db, if so that 
> is the impact on performance?
>  
> Kind regards,
> Paul
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] encryption of PostGIS databases

2011-05-12 Thread Mike Toews 
Hi Paul,

This is more of a PostgreSQL question, see:
http://www.postgresql.org/docs/9.0/static/encryption-options.html

You can require that all connections use SSL and make sure all users
have strong passwords.

-Mike

On 13 May 2011 00:30, Malm Paul  wrote:
> Hi,
> Is there a way to protect geographical data by encrypt the GIS db, if so
> that is the impact on performance?
>
> Kind regards,
> Paul
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[postgis-users] encryption of PostGIS databases

2011-05-12 Thread Malm Paul 
Hi,
Is there a way to protect geographical data by encrypt the GIS db, if so that 
is the impact on performance?

Kind regards,
Paul
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users