[Pgpool-general] parallel mode ERROR: password is required, DETAIL: Non-superuser cannot connect if the server does not request a password

[Vlad Kosilov]

answering my own questions.

solution is to give pgpool user a superuser (CREATEUSER,CREATEDB) 
permissions.
the error comes from dblink.c:

./contrib/dblink/dblink.c:                                 
errdetail("Non-superuser cannot connect if the server does not request a 
password."),

it checks and fails with this error if dblink is called by anything 
other then the superuser.
V.

Vlad Kosilov wrote:
> Hello pgpool experts,
> can you help with the following error:
>
> I'm testing pgpool parallel mode, failing query:
>  
> $ psql -U postgres -h ds1pgp -p 9999 MONSOONAUDIT_SCALABILITY -c "select 
> count(1) from tcp_audit;"
> ERROR:  password is required
> DETAIL:  Non-superuser cannot connect if the server does not request a 
> password.
> HINT:  Target server's authentication method must be changed.
>
> however this one works:
>
> $ psql -U postgres -h ds1pgp -p 9999 MONSOONAUDIT_SCALABILITY -c "select 
> * from tcp_audit;"
>    id   | beacon_id |                       
> message                        | flow | timestamp  | unique_id | byte_count
> --------+-----------+------------------------------------------------------+------+------------+-----------+------------
>  366915 |     25327 | 
> ,49.28139,-123.129592,22,NW,343.233,1214358904,10000 | in   | 1214358906 
> |           |         54
>
> how do I change target server's authentication method ?
>
> here is my pgpool.conf:
>
> listen_addresses = '*'
> port = 9999
>   
>> recovery_2nd_stage_command = ''
>> recovery_timeout = 90
>>
>>
>>
>> and debug for the failed query, /usr/local/pgpool/bin/pgpool -d -n  2>&1
>> ....
>>     
> pcp_port = 9898
> socket_dir = '/tmp'
> pcp_socket_dir = '/tmp'
> backend_socket_dir = '/tmp'
> pcp_timeout = 10
> num_init_children = 90
> max_pool = 1
> child_life_time = 300
> connection_life_time = 0
> child_max_connections = 0
> client_idle_limit = 0
> authentication_timeout = 60
> logdir = '/tmp'
> replication_mode = false
> load_balance_mode = false
> replication_stop_on_mismatch = false
> replicate_select = false
> reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
> print_timestamp = true
> master_slave_mode = false
> connection_cache = false
> health_check_timeout = 20
> health_check_period = 0
> health_check_user = 'nobody'
> failover_command = ''
> failback_command = ''
> insert_lock = false
> ignore_leading_white_space = true
> log_statement = true
> log_connections = true
> log_hostname = false
> parallel_mode = true
> enable_query_cache = false
> pgpool2_hostname = ''
> system_db_hostname = 'localhost'
> system_db_port = 5432
> system_db_dbname = 'pgpool'
> system_db_schema = 'pgpool_catalog'
> system_db_user = 'pgpool'
> system_db_password = ''
> backend_hostname0 = '192.168.0.111'
> backend_port0 = 5432
> backend_weight0 = 1
> backend_data_directory0 = '/usr/local/pgsql/data'
> backend_hostname1 = '192.168.0.112'
> backend_port1 = 5432
> backend_weight1 = 1
> backend_data_directory1 = '/usr/local/pgsql/data'
> enable_pool_hba = false
> recovery_user = 'nobody'
> recovery_password = ''
> recovery_1st_stage_command = ''
> recovery_2nd_stage_command = ''
> recovery_timeout = 90
>
>
>
> and debug for the failed query, /usr/local/pgpool/bin/pgpool -d -n  2>&1
> ....
>