From d2290697a7b3834a3fb9f68baff1658fbdcd3645 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Sat, 26 Jun 2010 11:14:28 -0400 Subject: [PATCH] Set the application_name (to 'bucardo', natch) if the db is >= 9.0 --- Bucardo.pm | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/Bucardo.pm b/Bucardo.pm index bc960b024..f474ffea8 100644 --- a/Bucardo.pm +++ b/Bucardo.pm @@ -282,11 +282,17 @@ sub connect_database { {AutoCommit=>0, RaiseError=>1, PrintError=>0} ); + ## Set the application name if we can + if ($dbh->{pg_server_version} >= 90000) { + $dbh->do(q{SET application_name='bucardo'}); + $dbh->commit(); + } + ## If we are using something like pgbouncer, we need to tell Bucardo not to ## use server-side prepared statements, as they will not span commits/rollbacks. if (! $ssp) { - $dbh->{pg_server_prepare} = 0; $self->glog('Turning off server-side prepares for this database connection', LOG_TERSE); + $dbh->{pg_server_prepare} = 0; } ## Grab the backend PID for this Postgres process -- 2.39.5