Thread: Database Name

Database Name

From
"Envbop"
Date:
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.



Re: Database Name

From
Dorian Büttner
Date:
Envbop wrote:

> Can someone tell me where I can find the database names.

login using psql and type \l ;-)

chances are you have root access to the linux box, then you could modify
pg_hba.conf to gain some access

Do you have any account information at all?

Re: Database Name

From
Bernt Andreas Drange
Date:
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


Re: Database Name

From
"Greg Patnude"
Date:
"Envbop" <rajib@envbopdotgovtdot.nz> wrote in message
news:cvvvs3$1fli$1@news.hub.org...
> 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.
>
>

FWIW:

phppgAdmin is a good interface if you ONLY have web-based access to the
database.... if you need a real functionality -- I recommend pgAdmin III  --
much more functional and feature rich with a better interface and the
ability to extract SQL the constructs used to create the tables, etc....




Re: Database Name

From
Dorian Büttner
Date:
Goulet, Dick wrote:
> \l works fine in psql, but is there a table where this is stored in the data dictionary?
>
> -----Original Message-----
> From: Dorian Büttner [mailto:dorian.buettner@gmx.de]
> Sent: Tuesday, March 01, 2005 6:16 AM
> To: "pgsql-admin@postgresql.org.pgsql-general"@postgresql.org
> Subject: Re: [ADMIN] Database Name
>
> Envbop wrote:
>
>
>>Can someone tell me where I can find the database names.
>
>
> login using psql and type \l ;-)
>
> chances are you have root access to the linux box, then you could modify
> pg_hba.conf to gain some access
>
> Do you have any account information at all?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>
please stop cross posting
please stop e mailing
please stop tofu
please read the doc
http://www.postgresql.org/docs/7.4/interactive/managing-databases.html
...