Skip site navigation (1) Skip section navigation (2)

RE: requiring a password to connect

From: "Williams, Travis L, NPONS" <tlw(at)att(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: RE: requiring a password to connect
Date: 2001-06-27 13:32:36
Message-ID: C9AA291109D8D311BE15009027AD06CF05B1A9A6@mo3980po14.ems.att.com (view raw or flat)
Thread:
Lists: pgsql-novice
If i'm understanding you correctly (and I'm a newbie) you need to edit the
/data/pg_hba.conf file this is where you can set up your permissions to not
trust local connections.. (by default it is set up to trust local)

Travis

-----Original Message-----
From: charlie derr [mailto:wrong(at)crosswinds(dot)net]
Sent: Wednesday, June 27, 2001 7:26 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: RE: [NOVICE] requiring a password to connect


obviously, i meant pg_Connect not pgConnect

+-----Original Message-----
+From: pgsql-novice-owner(at)postgresql(dot)org
+[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of charlie derr
+Sent: Wednesday, June 27, 2001 7:45 AM
+To: pgsql-novice(at)postgresql(dot)org
+Subject: [NOVICE] requiring a password to connect
+
+
+Hi all,
+
+	I am using postgresql in conjunction with php.  The
+following code works to
+establish a database connection:
+
+$db = pgConnect("dbname=mydb user=myuser");
+
+
+	I would prefer it if this would fail to connect.  Is there
+a command line
+switch I can use to start the postmaster that will require a password to be
+passed in the connection string?  Or do I need to recompile postgresql with
+a particular option to achieve the desired behavior?  I have
+experienced the
+above on 6.5.3, 7.0.2 and 7.1.2.
+
+	Thank you very much for your time,
+		~c
+
+
+---------------------------(end of broadcast)---------------------------
+TIP 3: if posting/reading through Usenet, please send an appropriate
+subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
+message can get through to the mailing list cleanly
+


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

pgsql-novice by date

Next:From: Willie NorthwayDate: 2001-06-27 18:17:59
Subject: exploring data
Previous:From: charlie derrDate: 2001-06-27 12:25:53
Subject: RE: requiring a password to connect

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group