Skip to content

Instantly share code, notes, and snippets.

@mkostrikin

mkostrikin/tips for new setup

Created October 3, 2018 09:48
Show Gist options
  • Save mkostrikin/90a0150d62c741f5ab6b4781955aaf85 to your computer and use it in GitHub Desktop.
Save mkostrikin/90a0150d62c741f5ab6b4781955aaf85 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
tips for new setup
apt-get update
apt-get install curl
curl -sSL https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
echo deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main 9.4 | sudo tee /etc/apt/sources.list.d/postgres.list
#percona mysql
sudo apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
echo deb http://repo.percona.com/apt trusty main | sudo tee /etc/apt/sources.list.d/percona.list
curl -sSL http://nginx.org/keys/nginx_signing.key | sudo apt-key add -
echo deb http://nginx.org/packages/ubuntu/ trusty nginx | sudo tee /etc/apt/sources.list.d/nginx.list
wget -qP /tmp/ http://repo.zabbix.com/zabbix/2.4/ubuntu/pool/main/z/zabbix-release/zabbix-release_2.4-1+trusty_all.deb && dpkg -i /tmp/zabbix-release_2.4-1+trusty_all.deb && rm -rf /tmp/zabbix-release_2.4-1+trusty_all.deb
sed -i "/^# deb .*partner/ s/^# //; /multiverse/d" /etc/apt/sources.list
echo "deb http://ru.archive.ubuntu.com/ubuntu/ trusty multiverse" >> /etc/apt/sources.list
echo "deb http://ru.archive.ubuntu.com/ubuntu/ trusty-updates multiverse" >> /etc/apt/sources.list
sudo apt-key adv --keyserver hkp://pgp.mit.edu:80 --recv-keys 58118E89F3A912897C070ADBF76221572C52609D
echo deb https://apt.dockerproject.org/repo ubuntu-trusty main | sudo tee /etc/apt/sources.list.d/docker.list
echo deb mirror://mirrors.ubuntu.com/mirrors.txt trusty main restricted universe multiverse | sudo tee /etc/apt/sources.list.d/mirror.list
echo deb mirror://mirrors.ubuntu.com/mirrors.txt trusty-updates main restricted universe multiverse | sudo tee -a /etc/apt/sources.list.d/mirror.list
echo deb mirror://mirrors.ubuntu.com/mirrors.txt trusty-backports main restricted universe multiverse | sudo tee -a /etc/apt/sources.list.d/mirror.list
echo deb mirror://mirrors.ubuntu.com/mirrors.txt trusty-security main restricted universe multiverse | sudo tee -a /etc/apt/sources.list.d/mirror.list
apt-get install percona-server-server-5.6 percona-server-client-5.6 \
postgresql-9.4 \
nginx \
zabbix-agent \
docker-engine \
ssh vim mc iptraf bash-completion tcpdump mtr-tiny screen tmux rar unrar zip unzip lsof whois rlwrap dstat sudo xz-utils git mercurial etckeeper bridge-utils haveged strace ntp xfsprogs
#Add vagrant bash completion
sudo wget https://raw.githubusercontent.com/hashicorp/vagrant/master/contrib/bash/completion.sh -O /etc/bash_completion.d/vagrant
for i in `psql -tc 'SELECT datname FROM pg_database WHERE datistemplate = false;'|grep -v postgres|xargs`;do pg_dump -h 1.2.3.4 $i|psql $i;echo $i;done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment