Hi again,
I just wanted to add that I added root to pg_shadow(access list) and
it works. What I don't understand is that this was not necessary for a
normal connect but only in case of a switch over - what's the difference?
Thanks again,
Lisa
--- Original posting ---
> Hi all,
>
> I'm testing db(postgres) failover with the radiator. The radiator is able
> to connect to each of the databases individually. But when it tries to
> switch over to the 2nd db when the first db is down, I get the following
> situation:
>
>
> Cannot connect to old db -> OK because db is down:
>
> Mon Mar 5 17:48:17 2001: ERR: Could not connect to SQL database with
> DBI->connect dbi:Pg:dbname=radmin;host=xxx.xxx.xxx.xxx, radmin, :
> PQconnectPoll() -- connect() failed: Connection refused
> Is the postmaster running (with -i) at 'xxx.xxx.xxx.xxx'
> and accepting connections on TCP/IP port '5432'?
>
>
> Cannot connect to the second DB:
>
> Mon Mar 5 17:48:17 2001: ERR: Could not connect to SQL database with
> DBI->connect dbi:Pg:dbname=radmin;host=yyy.yyy.yyy.yyy, , : FATAL 1:
> SetUserId: user 'root' is not in 'pg_shadow'
>
>
> I appreciate any help.
>
> Regards,
> Lisa
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
