[Spacewalk-list] purge old data from PostgreSQL

[Balint Szigeti]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20131219/fec67b6d/attachment.htm>