pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: codeWarrior <gpatnude@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: protecting database from internet access
Date: Wed, 12 Oct 2005 08:13:31 -0700
Message-ID: <dij95r$1a41$1@news.hub.org> (raw)
References: <BAY111-F137A8BA63A48E213E01AF59F7B0@phx.gbl>

  From the postgreSQL docs:
16.7. Secure TCP/IP Connections with SSL
19.1. The pg_hba.conf file
  19.2. Authentication methods
    19.2.1. Trust authentication
    19.2.2. Password authentication
    19.2.3. Kerberos authentication
    19.2.4. Ident-based authentication
    19.2.5. PAM Authentication
  19.3. Authentication problems

""ashish srivastava"" <ashu_shri@hotmail.com> wrote in message 
news:BAY111-F137A8BA63A48E213E01AF59F7B0@phx.gbl...
> hi,
>
> please do the needful..
>
> I am using j2ee on the server side and postgresql as the database to 
> connect. This database is exposed to the internet.
>
> The user is shown a login page in which user enters its username and 
> password. Password authentication takes place.This password is 
> authenticated on the basis of password field in the userprofile table.
>
> some questions :-
> 1)can anybody tell me how to do this so that the database is at most 
> secure on the internet ?
> 2)should i have different password(login password) for the connection 
> string ? or connection string password should be same and authentication 
> should be done by fetching the password value from the userprofile table 
> for the coressponding user ?
> 3)Encrypting the password ?
> 4)Adding the password in the session so that once authentication is done 
> user is allowed for authorization for different resources such 
> databases,tables etc..
> 5)providing some SSl or tunneling to the database ?
>
> please help with some examples..
>
> i am presently using pg admin III on windows of postgresql. later on might 
> switch to linux.
>
> i have read about pg_hba.conf file..But these things are not clear to me.
>
> Thanks,
> Ashish
>
> _________________________________________________________________
> Finding it difficult to find your life partner?Here is your solution 
> http://www.bharatmatrimony.com/ 
> http://creative.mediaturf.net/creatives/bm05/bm_msn_tagoffline.htm
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 





view thread (3+ messages)  latest in thread

Message-ID: <dij95r$1a41$1@news.hub.org>
Permalink:  ../dij95r$1a41$1@news.hub.org/
Also on:    postgresql.org/message-id/dij95r$1a41$1@news.hub.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: gpatnude@hotmail.com
  Subject: Re: protecting database from internet access
  In-Reply-To: <dij95r$1a41$1@news.hub.org>
  References: <BAY111-F137A8BA63A48E213E01AF59F7B0@phx.gbl> <dij95r$1a41$1@news.hub.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox