[Pgpool-general] what is "backend_data_directory"?

[Tatsuo Ishii]

> What is "backend_data_directory"?

Bakend's database cluster diretory.

> It's not really clear to me after reading the docs.
> 
> 
> Is it some temporary directory, needed for online recovery only?
> 
> I.e. I could set it like:
> 
> backend_hostname0 = 'host1'
> backend_port0 = 5432
> backend_weight0 = 1
> backend_data_directory0 = '/tmp/pgpool'
> backend_hostname1 = 'host2'
> backend_port1 = 5433
> backend_weight1 = 1
> backend_data_directory1 = '/tmp/pgpool'

No.

> Or is it perhaps the directory where postgres keeps its databases (like 
> /var/lib/postgresql/8.3/main)?
>
> I.e. I should set it like:
> 
> backend_hostname0 = 'host1'
> backend_port0 = 5432
> backend_weight0 = 1
> backend_data_directory0 = '/var/lib/postgresql/8.3/main'
> backend_hostname1 = 'host2'
> backend_port1 = 5433
> backend_weight1 = 1
> backend_data_directory1 = '/var/lib/postgresql/8.3/main'

Yes.
--
Tatsuo Ishii
SRA OSS, Inc. Japan