[Postgresql] Change the owner of the tables

$ psql -qAt -d mydatabase -c "SELECT 'ALTER TABLE '||schemaname||'.'||tablename||' OWNER TO new_owner;' FROM pg_tables WHERE schemaname = 'myschema'" > data.txt

 

$ psql < data.txt -d mydatabase

 

source : http://penningpence.blogspot.fr/2014/09/changing-owner-of-multiple-database.html

Pgbouncer [postgres]

Installer pgbouncer , configurer le .ini :

cat /etc/pgbouncer/pgbouncer.ini

 

[databases]
<aliasBDD> = dbname=test user=pg_test port=5433 pool_size=48

[pgbouncer]
logfile = /var/log/pgbouncer/pgbouncer.log
pidfile = /var/run/pgbouncer/pgbouncer.pid
auth_file = /etc/pgbouncer/userlist.txt
listen_addr = <hostname>-pgb
listen_port = 5432
auth_type = trust
admin_users = pgbouncer
stats_users = monitor

pool_mode = transaction

#server_reset_query =
server_reset_query =
max_client_conn = 1800
default_pool_size = 20
unix_socket_dir = /tmp

ignore_startup_parameters = extra_float_digits, application_name
server_check_query = select 1
server_check_delay = 10
log_connections = 1
log_disconnections = 1
log_pooler_errors = 1

 

Se connecter au pgbouncer :

su - pgbouncer

psql

show databases : affiche les databases liés