Re: Massive table bloat

On Tue, Dec 11, 2012 at 7:57 PM, Rural Hunter <ruralhunter@gmail.com> wrote:
> I do have psql installed. I'm on the db server.
> $ psql
> psql.bin (9.1.0)
> Type "help" for help.
>
> postgres=# \q
> $ ./pgcompactor -a -u
> DatabaseChooserError Can not find an adapter. at
> /loader/0x2539f18/PgToolkit/DatabaseChooser.pm line 63.

You are running it with user postgres, correct?

Can you show me the output of the following command, please?

echo 'SELECT 1;' | psql -q -A -t -X -U postgres -P null="<NULL>"

>
> 于 2012/12/12 11:46, Sergey Konoplev 写道:
>
>> On Tue, Dec 11, 2012 at 7:40 PM, Rural Hunter <ruralhunter@gmail.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@iii.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.ru@gmail.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.ru@gmail.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.ru@gmail.com