[Pgpool-general] kind does not match between backends

[Tatsuo Ishii]

Sorry for the delay. I think your complain is that pre-opened psql
session is not kept between fail over.

> > > My understaing was that the query should be processed as if nothing has 
> > > happened.

No. While the fail over process the TCP connection from psql to pgpool
(thus pgpool to PostgreSQL) cannot be kept since PostgreSQL and pgpool
will be newly created. Sorry for the inconvenience.
--
Tatsuo Ishii

> Yes, sure, thank you!
> 
> Fernando.
> 
> En un mensaje anterior, Tatsuo Ishii escribió:
> > Sorry for the delay...
> > 
> > Can you show me your pgpool.conf so that I could reproduce your
> > problem?
> > --
> > Tatsuo Ishii
> > 
> > > En un mensaje anterior, Tatsuo Ishii escribió:
> > > > Can you use trust or clear text password authentication?
> > > 
> > > Ok, I did, and it started. But...
> > > 
> > > -Start both postmasters
> > > -Start pgpool
> > > -psql -p 9999 ...
> > > -SELECT * FROM ... = OK
> > > -Shutdown main postmaster
> > > -Wait for pgpool to make the health check:
> > > 
> > > LOG:   pid 89915: starting health checking
> > > ERROR: pid 89915: connect_inet_domain_socket: connect() failed: Connection refused
> > > ERROR: pid 89915: health check failed. master XXXXXXXXXX at port 5432 is down
> > > DEBUG: pid 89915: failover_handler called
> > > LOG:   pid 89915: starting failover from  XXXX(5432) to XXXXX(5432)
> > > 
> > > -Same SELECT, from the same, open psql:
> > > 
> > > server closed the connection unexpectedly...
> > > 
> > > My understaing was that the query should be processed as if nothing has 
> > > happened.
> > > 
> > > Thanks again.
> > > 
> > > 
> > > Fernando.
> > >