Solved

PostgreSQL database health check

Posted on 2011-03-25
2
1,404 Views
Last Modified: 2012-05-11
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
Comment
Question by:passion420
2 Comments
 
LVL 1

Accepted Solution

by:
data_n_poker earned 250 total points
Comment Utility
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
 
LVL 7

Assisted Solution

by:MrNed
MrNed earned 250 total points
Comment Utility
Some good suggestions and scripts available here: http://blog.kimiensoftware.com/2011/03/postgresql-quick-health-check/
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Query combine all charges 6 57
one-way data "masking" MD5 sql 26 95
Has anyone used domo? 1 37
null value 14 57
In today’s complex data management environments, it is not unusual for UNIX servers to be dedicated to a particular department, purpose, or database.  As a result, a SAS® data analyst often works with multiple servers, each with its own data storage…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now