Skip site navigation (1) Skip section navigation (2)

Re: Problems

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'eday(at)sandibooks(dot)com'" <eday(at)sandibooks(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Problems
Date: 2001-10-25 20:45:22
Message-ID: AA30E7BCCA5C1D4E88A231900F8325C00BF9@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: Eric Day [mailto:eday(at)sandibooks(dot)com] 
> Sent: 25 October 2001 17:35
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Problems
> 
> 
> Hi,
> 
> 	I've just downloaded & installed PostgresSql 7.1.3 & 
> pgAdmin II 1.1.59. Postgresql is up and running, and I can 
> connect  with pgAdmin II from my windows 2000 machine to the 
> Linux red hat 7.0 where postgresql is running.
> 
> 	My problem is when I try to see the objects of my 
> database, it puts an X mark on my database although I am 
> logged in as user 'postgres' !
> 
> 	What am I doing wrong ?
> 

Hi Eric,

pgAdmin marks databases with an X when it can't access them for some reason.
It is desinged to do this primarily in situations where an ISP or sysadmin
has given a user access only to specific databases.

In your case, I would suggest checking your pg_hba.conf file on the server.
In the *first* line in the file that will match your workstation, make sure
that it specifies 'all' (without the quotes) as the database name, rather
than just 'template1' which it sounds like is probably there at the moment.

Regards, Dave.

pgadmin-support by date

Next:From: Mike HedmanDate: 2001-11-06 04:51:31
Subject: Connect problem
Previous:From: Eric DayDate: 2001-10-25 16:34:44
Subject: Problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group