Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 55447476DAE for ; Wed, 18 Dec 2002 16:13:49 -0500 (EST) Received: from virt3s.webintellects.com (virt3s.webintellects.com [216.98.153.73]) by postgresql.org (Postfix) with ESMTP id 6D2AC475EA8 for ; Wed, 18 Dec 2002 15:47:50 -0500 (EST) Received: from pclnxrhunter.digitalglobe.com (ew-fw-out.digitalglobe.com [205.166.175.2]) (authenticated (0 bits)) by virt3s.webintellects.com (8.11.6/8.11.6) with ESMTP id gBIKmm603893; Wed, 18 Dec 2002 12:48:48 -0800 Subject: Re: problems when i try to connect to my Databasse From: Ray Hunter To: Jesus Rios Cc: POSTGRESLQ-PHP In-Reply-To: <200212181838.gBIIc3M0030993@smtp.wanadoo.es> References: <200212181838.gBIIc3M0030993@smtp.wanadoo.es> Content-Type: text/plain; charset=ISO-8859-1 Organization: Venticon Consulting Message-Id: <1040244677.31681.8.camel@pclnxrhunter.digitalglobe.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.0 Date: 18 Dec 2002 13:51:17 -0700 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/38 X-Sequence-Number: 1713 You should create another user that has atleast read access to the database... The user "postgres" is kinda like the root user, so that user should not be used. Read here: http://www.postgresql.org/idocs/index.php?user-manag.html Then u can use that user in your php scripts. On Wed, 2002-12-18 at 11:42, Jesus Rios wrote: > > Hi........ > > Firts, sorry with my English. I am from Galician Country. > > My problem is : > i have only one user( in my postgresql) known as posgres. > # su postgres > #passwd ***** > > once , i am user postgres , i write : #psql mybd and it does not ask me for > the BD'pasword ( postgres is like a user root) > The problem comes when i am running a script php , where I try to connect to > my BD-----> $db=pg_connect("user=$user dbname=$dbname "). This refuse the > connection because I dont have the password.!!!!!. > > How can i get it?????????????????????? > > > > Thanks................... > > NUNCA MAIS!!!! , GOVERNO DIMISSOM!!!!! FORÇA GALIZA!! > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- Ray Hunter email: rhunter@venticon.com www: http://venticon.com