Thread: postgresql error while connecting to cluster with pgadmin

postgresql error while connecting to cluster with pgadmin

From
GMAIL
Date:
i have created two cluster in the same host the first called "main" with
port 5432 the second called "remote" with port 5433.
but when i try to connect with pgadmin3 to the second cluster i get the
error "authentication failed".
if i try to connect to the first cluster i don't have any kind of problem.

i'm using postgresql 9.1 and ubuntu 10.04


Re: postgresql error while connecting to cluster with pgadmin

From
Raymond O'Donnell
Date:
On 18/10/2012 15:47, GMAIL wrote:
> i have created two cluster in the same host the first called "main" with
> port 5432 the second called "remote" with port 5433.
> but when i try to connect with pgadmin3 to the second cluster i get the
> error "authentication failed".
> if i try to connect to the first cluster i don't have any kind of problem.

Yes, they maintain two completely separate lists of users. A successful
login on the first cluster doesn't mean that you can necessarily log in
on the second - they are completely separate... so whatever you did on
the first to be able to log in, you need to do it again on the second.

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie