X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0B47352A54; Wed, 2 Mar 2005 14:28:30 +0000 (GMT) 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 74408-09; Wed, 2 Mar 2005 14:28:26 +0000 (GMT) Received: from ns.imr.no (ns.imr.no [82.134.28.194]) by svr1.postgresql.org (Postfix) with ESMTP id 88EAC52A4E; Wed, 2 Mar 2005 14:28:23 +0000 (GMT) Received: from post2.imr.no ([10.1.2.137]) by ns.imr.no with esmtp (Exim 4.42) id 1D6Upu-0002lB-CY; Wed, 02 Mar 2005 15:28:26 +0100 Received: from 10.1.11.34 ([10.1.11.34]) by post2.imr.no ([10.1.2.137]) with Microsoft Exchange Server HTTP-DAV ; Wed, 2 Mar 2005 14:28:26 +0000 Received: from bender by post2.imr.no; 02 Mar 2005 15:28:26 +0100 Subject: Re: Database Name From: Bernt Andreas Drange To: pgsql-admin@postgresql.org, pgsql-general@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Organization: Havforskningsinstituttet/Institute of Marine Research Date: Wed, 02 Mar 2005 15:28:25 +0100 Message-Id: <1109773705.5490.55.camel@bender> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/27 X-Sequence-Number: 16525 On Tue, 2005-03-01 at 09:44 +1300, Envbop wrote: > Hi > > I've just inherited a PostgreSQL database, for which I do not have any > details of, like database name or the users. > This used to be a library database which was managed via a web page written > in php. > Its running on a Linux box. > The front end was also written in php. The original writers of this > application is no longer. > > I've just started to get familiarisd with postgresql in the last week. and > have installed PostgreSQL v8.0.1 on a Windows server. > And I am trying to connect to the linux box via the phppgadmin tool. as well > as trying an odbc connection. > > Can someone tell me where I can find the database names. If you look at the php source code, you will find the database name, user name and password that the php scripts use to connect to the database. That should be a good start. If php uses odbc to connect, you might also check /etc/odbc.ini on the linux box. Good luck! Bernt