Thread: 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