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 04:47:14 |
Message-ID: | CAL_0b1tz+J_qxk9wAeFiMStJyFhs-9OpA3X_gNqznPQ6bVKw6w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, Dec 11, 2012 at 8:30 PM, Rural Hunter <ruralhunter(at)gmail(dot)com> wrote:
> No. I was running it with another db super user. should it only be run by
> postgres?
>
> $ echo 'SELECT 1;' | psql -q -A -t -X -U postgres -P null="<NULL>"
> Password for user postgres:
> 1
Oh, looks like I know why it happens.
The tool does not expect any password prompts.
$ echo 'SELECT 1;' | psql -q -A -t -X -U postgres -P null="<NULL>"
1
It expects either trusted access (without password) or that password
will be specified as a parameter -W somesecret.
I will definitely need to fix it. My false, sorry, it is not easy to
wrap a command line tool to a fully flegged database adapter in Perl.
So either make a trusted access for the super user from the localhost
(you are working on localhost, right?) or specify -W
theuserspassword.
Anyway I suggest to install DBD::Pg Perl module, it will work much
faster and will load the system significantly less. The psql wrapper I
was asked to implement because one of the users had a hopeless boss
who did not allowed him to install DBD::Pg.
>
>
>>
>>> 于 2012/12/12 11:46, Sergey Konoplev 写道:
>>>
>>>> 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
>>>>
>>
>>
>> --
>> 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 05:21:17 | Re: Massive table bloat |
Previous Message | Rural Hunter | 2012-12-12 04:30:58 | Re: Massive table bloat |