Обсуждение: not able to connect to Database

Hi,

When I do psql test (database name) it says database "test" does not exists.

But with pgAdminIII utility I get to see the database "test" and able to create tables ,insert the data etc.....

Why is this?

Rgds

Rao

On Thu, 31 Mar 2005 16:10:04 +0530, Nageshwar Rao
<NageshwarR@planetasia.com> wrote:
>
>
> Hi,
>
> When I do psql test (database name) it says database "test" does not exists.
>
> But with pgAdminIII utility I get to see the database "test" and able to
> create tables ,insert the data etc.....
>
> Why is this?

You're connecting to a different host than you think you are?


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama@gmail.com
LlamaLand                       http://netllama.linux-sxs.org

On Thu, 2005-03-31 at 16:10 +0530, Nageshwar Rao wrote:

> When I do psql test (database name) it says database "test" does not
> exists.
>
> But with pgAdminIII utility I get to see the database "test" and able
> to create tables ,insert the data etc.....
>
> Why is this?

maybe the existing data base is named "Test" ?

what does psql -l say ?

gnari

Hi,
Psql -l gives names of databases in which it does not show "test".
But same test I am still able to access through pgAdmin III utility.
Regards
Rao

-----Original Message-----
From: Ragnar Hafstað [mailto:gnari@simnet.is]
Sent: Friday, April 01, 2005 2:46 AM
To: Nageshwar Rao
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] not able to connect to Database

On Thu, 2005-03-31 at 16:10 +0530, Nageshwar Rao wrote:

> When I do psql test (database name) it says database "test" does not
> exists.
>
> But with pgAdminIII utility I get to see the database "test" and able
> to create tables ,insert the data etc.....
>
> Why is this?

maybe the existing data base is named "Test" ?

what does psql -l say ?

gnari

Nageshwar Rao wrote:
> Hi,
> Psql -l gives names of databases in which it does not show "test".
> But same test I am still able to access through pgAdmin III utility.

You must be looking at two different installations. Check your
connection settings in pgadmin.

--
   Richard Huxton
   Archonet Ltd