• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2183
  • Last Modified:

PostgreSQL database health check

Hello experts
I have a postgresql database. Right now nobody is doing any database maintenace and I was wondering if there are any scritps to do db health check or maintenace on this database. I have never worked on this db before so any help help would be appreciated. Thanks for your time,
0
passion420
Asked:
passion420
2 Solutions
 
data_n_pokerCommented:
Not sure exactly what you are looking to do on the database, but this might point you in the right direction

http://www.postgresql.org/docs/9.0/static/maintenance.html
0
 
MrNedCommented:
Some good suggestions and scripts available here: http://blog.kimiensoftware.com/2011/03/postgresql-quick-health-check/
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now