Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm trying to configure a pgpool2 loadbalancer (in a Ubuntu 12.04 server) to balance between 2 postgres nodes (2 ubuntu 12.04 servers).

The main problem is that, if I create a database using pgAdmin (conected to the pgpool2 loadbalancer), it's created in each postgres nodes, but its OID is different in each node and if I try to use that database, it fails (gives me an ERROR: kind mismatch among backeneds etc.). These are my modified options in opt/etc/pgpool2/pgpool.conf:

backend_hostname0 = 'postgres-lb1'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/var/lib/postgresql/9.2/main/'
backend_flag0 = 'ALLOW_TO_FAILOVER'

backend_hostname1 = 'postgres-lb2'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/var/lib/postgresql/9.2/main'
backend_flag1 = 'ALLOW_TO_FAILOVER'


replication_mode = on
replicate_select = off
load_balance_mode = on
pgpool2_hostname = 'postgres-lb'

Another options are set by default.

In /etc/postgresql/9.2/main/postgresql.conf (for each postgres node):

wal_level = hot_standby
max_wal_senders = 1
hot_standby = on

and trust user access for postgres user in the network.

Any suggestions? Thank you.

share|improve this question

migrated from stackoverflow.com Jan 10 at 6:05

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer 1

i was getting error: psql: ERROR: MD5 authentication is unsupported in replication, master-slave and parallel modes.HINT: check pg_hba.conf, i have uninstall pgpool2 and reinatall it by using apt-get install pgpool2 command.But now i am getting error "psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.9999"?" i am unable to find file "pgpool.conf". I think i am installing wrong way.Can you please tell me installation steps shortly for ubanbu 12.04

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.