Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2019
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. psql -c "SELECT aid FROM pgbench_accounts" "host=localhost port=9999 user=pgpool password=pass dbname=bench_parallel"
  2. # Giant record set is returned here.
  3.  
  4. psql -c "SELECT aid FROM pgbench_accounts" "host=localhost port=9999 user=pgpool password=notmypass dbname=bench_parallel"
  5. psql: FATAL: password authentication failed for user "pgpool"
  6.  
  7. psql -c "SELECT count(aid) FROM pgbench_accounts" "host=localhost port=9999 user=pgpool password=pass dbname=bench_parallel"
  8. ERROR: password is required
  9. DETAIL: Non-superusers must provide a password in the connection string.
  10.  
  11. ERROR: could not establish connection
  12. DETAIL: fe_sendauth: no password supplied
  13.  
  14. 2014-10-23 19:59:10 DEBUG: pid 1643: OneNode_do_command: Query: SELECT
  15. sum(pool_g$0) AS count FROM
  16. dblink('host=ip-10-1-2-17 dbname=bench_parallel port=9999 user=pgpool',
  17. 'SELECT pool_parallel("SELECT count(aid) FROM pgbench_accounts")',false)
  18. AS pool_t$0g (pool_g$0 bigint )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement