From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
---|---|
To: | Rural Hunter <ruralhunter(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Massive table bloat |
Date: | 2012-12-12 03:46:36 |
Message-ID: | CAL_0b1vQvDf9tKwavJgTnToTHKBtZj7mFa0PzOo_o85F8M5Zuw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, Dec 11, 2012 at 7:40 PM, Rural Hunter <ruralhunter(at)gmail(dot)com> wrote:
> I downloaded pgtoolkit-v1.0beta3-fatscripts.tar.gz and tested it. I got
> error when trying this:
> ./pgcompactor -a -u
> DatabaseChooserError Can not find an adapter. at
> /loader/0x1c26f18/PgToolkit/DatabaseChooser.pm line 63.
> ./pgcompactor -d testdb -u
> DatabaseChooserError Can not find an adapter. at
> /loader/0x1156f50/PgToolkit/DatabaseChooser.pm line 63.
You need to have either psql or DBD::PgPP or DBD::Pg on your machine.
The last one is recommended.
>
> δΊ 2012/12/12 5:27, Sergey Konoplev ει:
>
>> On Tue, Dec 11, 2012 at 1:14 PM, Michael Sawyers <msawyers(at)iii(dot)com> wrote:
>>>
>>> Thanks for the tool suggestion. I already know that I will be refused
>>> permission to use it on a live db for the first run here, but I will be
>>> using this on several test machines that I am sure are bloated to prove
>>> the
>>> point and get this added into the standard toolkit here.
>>
>> If you will have any feedback considering pgcompactor feel free to
>> write me directly. I am going to publish a new release in the nearest
>> days so I may include your issues in it.
>>
>> ps. I have been using this tool constantly on more than 40 DB servers
>> for more than a year so it is tested quite good.
>>
>> --
>> Sergey Konoplev
>> Database and Software Architect
>> http://www.linkedin.com/in/grayhemp
>>
>> Phones:
>> USA +1 415 867 9984
>> Russia, Moscow +7 901 903 0499
>> Russia, Krasnodar +7 988 888 1979
>>
>> Skype: gray-hemp
>> Jabber: gray(dot)ru(at)gmail(dot)com
>>
>>
>
--
Sergey Konoplev
Database and Software Architect
http://www.linkedin.com/in/grayhemp
Phones:
USA +1 415 867 9984
Russia, Moscow +7 901 903 0499
Russia, Krasnodar +7 988 888 1979
Skype: gray-hemp
Jabber: gray(dot)ru(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Rural Hunter | 2012-12-12 03:57:42 | Re: Massive table bloat |
Previous Message | Rural Hunter | 2012-12-12 03:40:31 | Re: Massive table bloat |