Hello
Thank you for you help and I try to give some information.
The DB size is 11G and I have only 23 CentOS boxes and 1 OEL. I have 2
proxy server and CentOS 5 and 6 repositories.
Oh, and I use monitoring. 4 suites, and every suite includes 5 probes
Is this size is normal? I think is too big.
Is there a way to set up the stored data? I mean, set how long storing
the monitoring data.
Balint
On 19/12/13 22:39, Paul Robert Marino wrote:
Well the template1 message is strange but its probably an issue with
the pg_hba.conf which you probably should correct.
template1 is a default database in PostgreSQL which is used as a
template when you create new databases and should never be dropped.
The vacuuming was a shot in the dark but is always what you should try
first in table bloat situations because PostgreSQL never deleted
things when you tell it to it instead marks all versions of the column
as invalid and recyclable.
I'll get back to you with some more ideas when I get back into the
office on Sunday and can tinker with my test instance a little
-- Sent from my HP Pre3
------------------------------------------------------------------------
On Dec 19, 2013 4:41, Balint Szigeti <[email protected]> wrote:
hello
I've run the command and got this:
*bash-4.1$ vacuumdb -azf*
vacuumdb: vacuuming database "postgres"
vacuumdb: vacuuming database "spaceschema"
vacuumdb: vacuuming database "template1"
vacuumdb: could not connect to database template1: FATAL: no
pg_hba.conf entry for host "[local]", user "postgres", database
"template1", SSL off
I don't think, I have template1. Maybe is it a default schema? The
used space didn't change.
Balint
On 18/12/13 20:42, Paul Robert Marino wrote:
I know I say this often but if you are running PostgreSQL8.x first try
a "vacuumdb -azf"
On Wed, Dec 18, 2013 at 1:51 AM, Balint Szigeti<[email protected]> wrote:
Hello All,
Do you all have a 'best practise' about how should be maintained the DB?
It's growing and growing. I think, it stores history data or what else but,
my disk capacity is almost reached the end of it.
What should I do?
Adding new disk, is the final scenario. At first I'd like to purge the
unwanted or obsolete data from DB.
Do you have any advice how I should do it?
Balint
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
