Message-ID: <50C800B6.6060306@gmail.com>
Date: Wed, 12 Dec 2012 11:57:42 +0800
From: Rural Hunter <ruralhunter@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
To: Sergey Konoplev <gray.ru@gmail.com>
CC: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Massive table bloat
References: <1355242268184-5736111.post@n5.nabble.com>
	<CAL_0b1tKNmHe4Qq7fDAkpJNt2Jq8sWzKmwWtscF659x8BYuXeQ@mail.gmail.com>
	<1355260487663-5736180.post@n5.nabble.com>
	<CAL_0b1vDs8dpxFwyMwgROoWtM=QQaPvpm6rA8cQLXGP_AcU8rQ@mail.gmail.com>
	<50C7FCAF.1080502@gmail.com>
	<CAL_0b1vQvDf9tKwavJgTnToTHKBtZj7mFa0PzOo_o85F8M5Zuw@mail.gmail.com>
In-Reply-To: 
 <CAL_0b1vQvDf9tKwavJgTnToTHKBtZj7mFa0PzOo_o85F8M5Zuw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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.

于 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
>


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin