Re: Massive table bloat

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



于 2012/12/12 12:24, Sergey Konoplev 写道:
On Tue, Dec 11, 2012 at 7:57 PM, Rural Hunter <ruralhunter@xxxxxxxxx> 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>"
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


于 2012/12/12 11:46, Sergey Konoplev 写道:

On Tue, Dec 11, 2012 at 7:40 PM, Rural Hunter <ruralhunter@xxxxxxxxx>
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@xxxxxxx>
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@xxxxxxxxx



--
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@xxxxxxxxx



--
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@xxxxxxxxx




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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux