Tell me more ×
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.
up vote 5 down vote favorite
1

I am planing to have very soon few highly loaded postgresql databases. I have some expirience managing mysql databases with high load, but now we have to use postgresql.

I want to know what are the best tools for day-to-day database management and status reporting. (Of course console is the best one, but I want to know about other options too)

All expirience is welcome!

share|improve this question
What sort of load - OLTP? – Jack Douglas♦ May 17 '11 at 18:55
Yes, mostly OLTP and some stats calculation. It will be a backend for online game for social networks with some capitalism in it. – MinimeDJ May 18 '11 at 5:26

5 Answers

up vote 5 down vote accepted

Is pg_statsinfo something for you? Maybe the default stats collected are sufficient? There are some nice posts on SO with a similar topic.

share|improve this answer
up vote 4 down vote

What are you using for your other monitoring, e.g. disk space, processor load, etc? If it is Nagios then you can just get a Postgres plugin for it. That is probably better than having a whole 'nother monitoring framework.

share|improve this answer
up vote 2 down vote

http://www.logicmonitor.com/monitoring/databases/postgres-monitoring/

share|improve this answer
2  
Hi Steve, consider this a brief warning. I encourage you to read this meta.stackoverflow.com/questions/88642/… and then to peruse our FAQ May I promote products or websites I am affiliated with here? where it states "May I promote products or websites I am affiliated with here? Be careful, because the community frowns on overt self-promotion and tends to vote it down and flag it as spam." ~ Bear in mind we absolutely value your expert opinion, and really do want you to contribute. Help us help you! – jcolebrand♦ May 18 '11 at 22:24
up vote 2 down vote

There is a new tool available from Cybertec:

http://www.cybertec.at/en/postgresql_products/pgwatch-cybertec-enterprise-postgresql-monitor

(I have not used it though)

share|improve this answer
up vote -1 down vote

You can check out dbWatch. Its a cross platform monitoring and administration tool, that in the future will also add more modules such as audit, database replication and improved performance tuning.

I am quite partial, as I work there, but check it out at http://www.dbwatch.com/. There is a free 10 day full use license included, but we can extend this if you need to test further.

-Chris

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.