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