5 ms·

Anything similar with python perhaps?

sandGorgon 8y ago
It works with docker, so you don't have to worry about having perl. >docker run -it --rm jfcoz/postgresqltuner --host=dbhost --user=username --password=pass --database=testdb
- qaq 8y ago
  You gonna pull a random image into prod and give it access to prod db :)?
  - indigo945 8y ago
    It's no more a "random image" than the script itself is a random software.
    - qaq 8y ago
      it's a lot easier to audit a script
      - dalore 8y ago
        Dockerfile is a script of sorts too you can audit that
        semiquaver 8y ago
        Nothing guarantees the image in docker hub has anything to do with the Dockerfile or this repo. This is a valid concern.
        dalore 8y ago
        Except it does, docker hub builds it with that Dockerfile.
        semiquaver 8y ago
        Docker hub allows any user with the appropriate permissions to `docker push` any image they want.
      - flukus 8y ago
        It is just a perl script (in this case), just one that needs 45MB of baggage.
    - zbuttram 8y ago
      Also the Dockerfile seems to be in the repo. Looks like it just installs some apt packages and adds the script file: https://github.com/jfcoz/postgresqltuner/blob/master/Dockerfile https://github.com/jfcoz/postgresqltuner/blob/master/Dockerf...
- claudiawerner 8y ago
  Is not having Perl such a worry? I'd imagine most systems that use this also use Git and that requires Perl, and I'm not aware of any GNU/Linux distro that doens't come with Perl (5, of course) pre-installed. While we're speaking of Perl, I just want to say how amazing Perl 6 is, especially compared to Perl 5, in every regard - from syntax to arrays/lists to the quality of the (admittedly small range of) libraries.
  - edoceo 8y ago
    Perl and python are part of LSB.
  - Ultimatt 8y ago
    +1 for Perl 6 shout out. Also there are increasingly nice things for use with Postgres like https://github.com/CurtTilmes/perl6-dbpg https://github.com/CurtTilmes/perl6-dbpg with https://github.com/FCO/Red https://github.com/FCO/Red
grafelic 8y ago
If you for some reason can not use docker and don't want to pollute your system globally with cpan packages, you can use a locallib install instead. CentOS example: sudo yum -y install postgresql-devel sudo useradd -d /home/pgsqltun -m -s /bin/bash -c"pgsql tuner user" psqltun sudo su - psqltun wget -O- https://cpanmin.us | perl - -l $HOME/perl5 App::cpanminus local::lib echo 'eval `perl -I $HOME/perl5/lib/perl5 -Mlocal::lib`' >> $HOME/.bash_profile echo 'export MANPATH=$HOME/perl5/man:$MANPATH' >> $HOME/.bash_profile . .bash_profile cpanm DBD::Pg <install postgresqltuner.pl>

It works with docker, so you don't have to worry about having perl. >docker run -it --rm jfcoz/postgresqltuner --host=dbhost --user=username --password=pass --database=testdb

qaq 8y ago
You gonna pull a random image into prod and give it access to prod db :)?
- indigo945 8y ago
  It's no more a "random image" than the script itself is a random software.
  - qaq 8y ago
    it's a lot easier to audit a script
    - dalore 8y ago
      Dockerfile is a script of sorts too you can audit that
      - semiquaver 8y ago
        Nothing guarantees the image in docker hub has anything to do with the Dockerfile or this repo. This is a valid concern.
        dalore 8y ago
        Except it does, docker hub builds it with that Dockerfile.
        semiquaver 8y ago
        Docker hub allows any user with the appropriate permissions to `docker push` any image they want.
    - flukus 8y ago
      It is just a perl script (in this case), just one that needs 45MB of baggage.
  - zbuttram 8y ago
    Also the Dockerfile seems to be in the repo. Looks like it just installs some apt packages and adds the script file: https://github.com/jfcoz/postgresqltuner/blob/master/Dockerfile https://github.com/jfcoz/postgresqltuner/blob/master/Dockerf...
claudiawerner 8y ago
Is not having Perl such a worry? I'd imagine most systems that use this also use Git and that requires Perl, and I'm not aware of any GNU/Linux distro that doens't come with Perl (5, of course) pre-installed. While we're speaking of Perl, I just want to say how amazing Perl 6 is, especially compared to Perl 5, in every regard - from syntax to arrays/lists to the quality of the (admittedly small range of) libraries.
- edoceo 8y ago
  Perl and python are part of LSB.
- Ultimatt 8y ago
  +1 for Perl 6 shout out. Also there are increasingly nice things for use with Postgres like https://github.com/CurtTilmes/perl6-dbpg https://github.com/CurtTilmes/perl6-dbpg with https://github.com/FCO/Red https://github.com/FCO/Red

grafelic 8y ago

If you for some reason can not use docker and don't want to pollute your system globally with cpan packages, you can use a locallib install instead. CentOS example: sudo yum -y install postgresql-devel sudo useradd -d /home/pgsqltun -m -s /bin/bash -c"pgsql tuner user" psqltun sudo su - psqltun wget -O- https://cpanmin.us | perl - -l $HOME/perl5 App::cpanminus local::lib echo 'eval `perl -I $HOME/perl5/lib/perl5 -Mlocal::lib`' >> $HOME/.bash_profile echo 'export MANPATH=$HOME/perl5/man:$MANPATH' >> $HOME/.bash_profile . .bash_profile cpanm DBD::Pg <install postgresqltuner.pl>