Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is there any load emulation client for postgresql like mysqlslap? And is there any good monitoring tool for postgresql database server?

Thanks

share|improve this question

migrated from stackoverflow.com Jun 7 '13 at 3:48

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 1 down vote accepted

pgbench ? It's built-in, and you can add custom scripts to it.

For monitoring, since you haven't defined "good" it's rather hard to say. Monitoring's a bit limited in terms of Pg specific tools. Most people use Icinga or Nagios with the check_postgres tool, and use Cacti or Munin for trending. Zabbix is another moderately popular alternative.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.