Re: Best security practices for installing pgSQL with my software - Mailing list pgsql-general

From Harald Armin Massa
Subject Re: Best security practices for installing pgSQL with my software
Date
Msg-id 7be3f35d0606120305w42d92c38hda4fd890a96aead5@mail.gmail.com
Whole thread Raw
In response to Re: Best security practices for installing pgSQL with my software  ("Greg" <greg@officium.co.za>)
List pgsql-general
Greg,

The program will have a database on the local PC, and be able to connect to the server database as well. Eventually they will synchronise the email, contacts etc.

aaah. Like Lotus Notes.  

I need the database on the local PC so the user can take their PC/laptop home and still work.

Yes, now it is clear.

Do you think a direct connection to the database port using SSL will be suitable for this kind of scenario?

I guess the connection between client and server should be the least of your concerns in this scenario :) Of course you can connect via SSL, that is explicitly supported by PostgreSQL.

The challenges begin with the key infrastructure, the synchronization, the network, the ports, the installation of Databases on a lot of client computers in an automated fashion etc., the access rights et. all

It took me around a year to get that working :); so better start now.

Best wishes and good luck,

Harald


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
did you ever dream of visiting CERN? The place where the antimatter for exploding Vatican is created? To eat in cantinas
with the worlds highest propability to stand in queue with future or past Nobel Prize Winners? To talk about Web 2.5 at the place where Web 0.1 up to Web 1.0 were developed? register at www.europython.org!

pgsql-general by date:

Previous
From: "Greg"
Date:
Subject: Re: Best security practices for installing pgSQL with my software
Next
From: Martijn van Oosterhout
Date:
Subject: Re: TOAST not working