[Spacewalk-list] purge old data from PostgreSQL

[Paul Robert Marino]

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 <balint.szgt at gmail.com> 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 <balint.szgt at gmail.com> 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 <balint.szgt at gmail.com>
> 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
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list