X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0D56DD953D for ; Sun, 25 Sep 2005 12:30:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 59829-05 for ; Sun, 25 Sep 2005 15:30:55 +0000 (GMT) Received: from gui.maxihost.com.br (gui.maxihost.com.br [66.98.166.8]) by svr1.postgresql.org (Postfix) with ESMTP id 3082CD9582 for ; Sun, 25 Sep 2005 12:30:54 -0300 (ADT) Received: from 200-206-214-59.dsl.telesp.net.br ([200.206.214.59] helo=maxihost) by gui.maxihost.com.br with smtp (Exim 4.52) id 1EJYSo-00083B-Ms for pgsql-admin@postgresql.org; Sun, 25 Sep 2005 12:30:51 -0300 Message-ID: <000d01c5c1e6$1f9bcbf0$3bd6cec8@maxihost> From: "Guilherme Alberto" To: Subject: PostgreSQL Remote Connection Date: Sun, 25 Sep 2005 12:30:53 -0300 MIME-Version: 1.0 Content-Type: multipart/related; type="multipart/alternative"; boundary="----=_NextPart_000_0009_01C5C1CC.F84E0900" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-PopBeforeSMTPSenders: gui@maxihost.com.br X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - gui.maxihost.com.br X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - maxihost.com.br X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.122 required=5 tests=[EXTRA_MPART_TYPE=0.222, HTML_30_40=0.056, HTML_IMAGE_ONLY_20=0.843, HTML_MESSAGE=0.001] X-Spam-Level: * X-Archive-Number: 200510/8 X-Sequence-Number: 19080 This is a multi-part message in MIME format. ------=_NextPart_000_0009_01C5C1CC.F84E0900 Content-Type: multipart/alternative; boundary="----=_NextPart_001_000A_01C5C1CC.F84E0900" ------=_NextPart_001_000A_01C5C1CC.F84E0900 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, Im trying to make a remote connection using a Windows Program called = "EMS PostgreSQL Manager". I am having issues setting up the pg_hba.conf properly to allow a user = to make connections only to his assigned database. Following the PostgreSQL documentation I could sucessfuly connect using = a user password with the following entry in pg_hba.conf: host all all my_ip 255.255.255.255 md5 With the above line I could connect to the server using a user password, = although I could see all the databases of the server and manage all of = them. When I change it to: host database_that_user_should_connect all my_ip 255.255.255.255 md5 I get an error message: no pga_hba.conf entry for host "my_ip", user = "user", database "template1" (dont know why it says template1 if the = database I choose was another one) I have also tried using: host all all my_ip 255.255.255.255 ident test With the proper lines inside pg_ident.conf for "test" *******: pg_ident.conf test user pg_user With no success=20 Anyone can help me ? I would like to allow a pg user to connect only to = his assigned database providing the correct password. Thank you very much. ------=_NextPart_001_000A_01C5C1CC.F84E0900 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,

Im trying to make a = remote=20 connection using a Windows Program called "EMS PostgreSQL = Manager".

I am=20 having issues setting up the pg_hba.conf properly to allow a user to = make=20 connections only to his assigned database.

Following the = PostgreSQL=20 documentation I could sucessfuly connect using a user password with the=20 following entry in pg_hba.conf:

host all all my_ip = 255.255.255.255=20 md5

With the above line I could connect to the server using a = user=20 password, although I could see all the databases of the server and = manage all of=20 them.

When I change it to:

host = database_that_user_should_connect=20 all my_ip 255.255.255.255 md5

I get an error message: no = pga_hba.conf=20 entry for host "my_ip", user "user", database "template1" (dont know why = it says=20 template1 if the database I choose was another one)

I have also = tried=20 using:

host all all my_ip 255.255.255.255 ident test

With = the=20 proper lines inside pg_ident.conf for "test"=20 *******:

pg_ident.conf
test user pg_user

With no = success

Anyone can help me ? I would like to allow a pg user = to connect=20 only to his assigned database providing the correct = password.

Thank you=20 very much.
------=_NextPart_001_000A_01C5C1CC.F84E0900-- ------=_NextPart_000_0009_01C5C1CC.F84E0900 Content-Type: image/gif; name="frown.gif" Content-Transfer-Encoding: base64 Content-Location: http://www.webhostingtalk.com/images/smilies/frown.gif R0lGODlhDwAPANUAAMDAwAY3sgc4swo7tQs8tQ4+txBAuBFBuRZGvBZFuxdGvBtJvh1MwB5NwCFP wiRSxClWxipXxyxZyC1ayTJezDdizjhjzztm0T1n0j9p00Fr1EVv1kly2Upz2VJ63lV94Fd/4VmA 4l+F5WaL6WiO62uQ7HSX8Xea836h94Ol+oyt/729vQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAEAAAAALAAAAAAPAA8AAAaXQIBQ yCoWh0hAkTQSfTpHJKtkYplKItbGwhqyRtUUyjQCsS6SrpLESqlSJ1IIOumyQODieFREM4oeIiVF V1ksFhALRR0fIiNMTh0ZFA8IRRodHiAhIB4dGhURDAdFFRkbHEZFEg4JBHYUXBgXFhQRLAoFaiwP EBITEhAPDAkFAWpKCwwNDAsIBwTHSUUGBgUDAlFJSqpJQQA7 ------=_NextPart_000_0009_01C5C1CC.F84E0900--