hey Balint sorry for the delayed response Ive been sick for the last few days. so go to Schedule -> Completed Actions click on "Select ALL" then "Archive Actions" next go to Schedule -> Archived Actions click on "Select ALL" then "Delete Actions"
then if you run the "vacuumdb -azf" It should clear up some space As for the monitoring I don't really use it so I cant be of much help in cleaning out that data. On Fri, Dec 20, 2013 at 4:03 AM, Balint Szigeti <[email protected]> wrote: > 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 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
