# Use ident method
self.db = pg.connect("user=%s dbname=postgres" % user)
elif port != '':
self.db = pg.connect(host=server, port=port, user=user,
password=passwd, database='postgres')
else:
self.db = pg.connect(host=server, user=user, password=passwd,
database='postgres')
self._get_version()
except ImportError, e:
self.logger.exception("Cannot import psypg2")
return False
except Exception, e: #Fixme: catch only pg errors
self.logger.exception('PostgreSql connection error')
return False
# Check version
self._get_version()
# Collect metrics
self._collect_stats()
return self.get_samples()
if __name__ == "__main__":
import logging
pg = PostgreSql(logging)
pg.check({'postgresql_server': 'localhost', 'postgresql_user': '******', 'postgresql_pass': '******'})
# Check version
version = self._get_version(key, db)
self.log.debug("Running check against version %s" % version)
# Collect metrics
self._collect_stats(db, tags)
@staticmethod
def parse_agent_config(agentConfig):
server = agentConfig.get('postgresql_server','')
port = agentConfig.get('postgresql_port','')
user = agentConfig.get('postgresql_user','')
passwd = agentConfig.get('postgresql_pass','')
if server != '' and user != '':
return {
'instances': [{
'host': server,
'port': port,
'username': user,
'password': passwd
}]
}
return False
if __name__ == "__main__":
pg = PostgreSql(logging)
pg.check({'host': 'localhost', 'username': '******', 'password': '******'})
# Use ident method
self.db = pg.connect("user=%s dbname=postgres" % user)
elif port != '':
self.db = pg.connect(host=server, port=port, user=user,
password=passwd, database='postgres')
else:
self.db = pg.connect(host=server, user=user, password=passwd,
database='postgres')
self._get_version()
except ImportError, e:
self.logger.exception("Cannot import psypg2")
return False
except Exception, e: #Fixme: catch only pg errors
self.logger.exception('PostgreSql connection error')
return False
# Check version
self._get_version()
# Collect metrics
self._collect_stats()
return self.get_samples()
if __name__ == "__main__":
import logging
pg = PostgreSql(logging)
pg.check({'PostgreSqlServer': 'localhost', 'PostgreSqlUser': '******', 'PostgreSqlPass': '******'})
