Zmiany pomiędzy wersją początkową i wersją 1 dla AdminGuide/pgbouncer

Data i czas:

08/17/15 16:08:33 (9 years temu)

Autor:

MK (IP: 79.188.124.105)

Komentarz:

--

AdminGuide/pgbouncer

@@ +1 @@
+= PgBouncer =
+
+1.      Instalacja (Debian itp.)
+
+{{{
+apt-get install pgbouncer
+}}}
+
+
+vim /etc/pgbouncer/pgbouncer.ini
+
+[databases]
+
+* =
+
+[pgbouncer]
+
+logfile = /var/log/postgresql/pgbouncer.log
+
+pidfile = /var/run/postgresql/pgbouncer.pid
+
+listen_addr = 127.0.0.1
+
+listen_port = 6432
+
+unix_socket_dir = /var/run/postgresql
+
+auth_type = trust
+
+auth_file = /etc/pgbouncer/userlist.txt
+
+admin_users = postgres
+
+stats_users = postgres
+
+pool_mode = transaction
+
+
+vim /etc/pgbouncer/userlist.txt
+
+"postgres" ""
+
+"edokumenty" ""
+
+"http" ""
+
+3. Restart usługi
+
+{{{
+/etc/init.d/pgbouncer restart
+}}}