From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | 'James Dean' <jfdean(at)ihug(dot)com(dot)au> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: beginner problem connecting to database |
Date: | 2002-03-05 08:12:06 |
Message-ID: | FED2B709E3270E4B903EB0175A49BCB1047668@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: James Dean [mailto:jfdean(at)ihug(dot)com(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Gastón Micheri | 2002-03-06 19:57:42 | A consult |
Previous Message | Dave Page | 2002-03-04 22:42:28 | Re: beginner problem connecting to database |