Add pooler connection to newly created database in tembo

add_pooler_connection_tembo.sql

GRANT CONNECT ON DATABASE db_name_here TO cnpg_pooler_pgbouncer;
CREATE OR REPLACE FUNCTION user_search(uname TEXT)
  RETURNS TABLE (usename name, passwd text)
  LANGUAGE sql SECURITY DEFINER AS
  'SELECT usename, passwd FROM pg_shadow WHERE usename=$1;';

REVOKE ALL ON FUNCTION user_search(text)
  FROM public;

GRANT EXECUTE ON FUNCTION user_search(text)
  TO cnpg_pooler_pgbouncer;

ALTER FUNCTION user_search(TEXT) OWNER TO postgres;