Solved

Connecting to PostgreSQL-server using PGAdmin via SSL

Posted on 2009-04-09
1
1,080 Views
Last Modified: 2012-08-13
I would like to connect to a postgresql-server using PGAdmin instead of phpPgAdmin. It is not so difficult to open a port, and limit the connection to my own ip-address. Is it possible to require that the connection uses SSL, while the internal connection (from the webserver) doesn't do this? Any other tips? Is this secure enough?
0
Comment
Question by:R7AF
1 Comment
 
LVL 22

Accepted Solution

by:
earth man2 earned 500 total points
ID: 24106359
see
http://www.postgresql.org/docs/8.3/static/auth-pg-hba-conf.html

each record  in file pg_hba.conf can have one of the seven formats

local      database  user  auth-method  [auth-option]
host       database  user  CIDR-address  auth-method  [auth-option]
hostssl    database  user  CIDR-address  auth-method  [auth-option]
hostnossl  database  user  CIDR-address  auth-method  [auth-option]
host       database  user  IP-address  IP-mask  auth-method  [auth-option]
hostssl    database  user  IP-address  IP-mask  auth-method  [auth-option]
hostnossl  database  user  IP-address  IP-mask  auth-method  [auth-option]

your internal connection uses "local" authentication format
your PGAdmin will require an entry with "hostssl"
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you have a windows based Checkpoint SmartCenter for centralized Checkpoint management?  Have you ever backed up the firewall policy residing on the SmartCenter?  If you have then you know the hassles of connecting to the server, doing an upgrade_…
This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question