> -----Original Message-----
> From: James Dean [mailto:jfdean@ihug.com.au]
> Sent: 05 March 2002 01:37
> To: Dave Page
> Subject: Re: [pgadmin-support] beginner problem connecting to database
>
>
> Thanks Dave, but...
>
> whatever, however, the database that I wanted to work on had
> a red cross
> on it. I was logged in to the server as athe owner of the database.
>
Ahh, that means that pgAdmin's connection to that database has failed. This
is normally for one of 3 reasons:
- pgAdmin has exceeded the number of allow connections on your server. This
can be modified in your $PGDATA/postgresql.conf file. Future versions of
pgAdmin will be a little less connection hungry.
- your $PGDATA/pg_hba.conf file on the server doesn't contain an entry that
will allow your client PC to connect to that database
- The system table pg_database (access it from template1) contains a row for
each database. If the datallowconn column for your database is set to false,
then no connections will be allowed to this database.
Regards, Dave.