Last active
May 4, 2023 00:14
-
-
Save Josimar16/885ddee5afc2a31466c83ff3577ceb08 to your computer and use it in GitHub Desktop.
Comandos docker e psql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# instalar docker | |
sudo curl -fsSL http://get.docker.com | bash | |
# instalar docker-compose | |
sudo curl -L "https://github.com/docker/compose/releases/download/1.25.0/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose | |
sudo chmod +x /usr/local/bin/docker-compose | |
sudo ln -s /usr/local/bin/docker-compose /usr/bin/docker-compose | |
docker-compose --version | |
sudo usermod -aG docker <your-user> | |
sudo /etc/init.d/apache2 stop | |
# remover postgres da maquina | |
systemctl stop postgresql | |
# remover completamente o postgres da maquina | |
sudo apt purge postgresql | |
# verificar se existe algum registro de postgres | |
sudo apt search postgresql | grep installed | |
# cria arquivo docker-compose.yml | |
touch docker-compose.yml | |
# inicializar container | |
docker-compose up -d | |
# verificar containers | |
docker ps | |
# parar container | |
docker stop id_container | |
# remover containers parados | |
docker system prune -a -f --volumes | |
# Gerar arquivo txt | |
sudo docker exec -it nome_container psql -U nome_user -d nome_db -P pager=off -c "sql" > nome_arquivo.txt | |
# Gerar arquivo sql | |
sudo docker exec -it nome_container psql -U nome_user -d nome_db -f arquivo.sql "sql" | |
# Geração de backup | |
pg_dump --username (user) -d (banco) -B -f bkp.(banco).(ano).(mes).(dia).(hora).(minuto).sql -F p -O -x --column-inserts --no-tablespaces --no-unlogged-table-data | |
# copiar backup para a raiz do container | |
docker cp backup.sql nome_container(postgres):/ | |
# copiar backup para máquina | |
docker cp nome_conteiner(postgres):/caminho/de/origem /caminho/de/destino | |
# executar container docker | |
docker exec -it postgres bash | |
# restaurar backup para o banco atraves do psql | |
psql -U usuario -d banco -f backup.sql | |
# reiniciar o serial de uma coluna | |
ALTER SEQUENCE schema.tabela_id_seq RESTART WITH 1; | |
SELECT REGEXP_REPLACE(d.cidade,'/..','','g') FROM cidade d; | |
# OBS:. / = é o identificador do que está buscando | |
# OBS:. .. = quantidade de caracteres que vai substituir | |
# OBS:. '' = pelo o que vai ser substituido | |
# OBS:. g = todas as linhas | |
#Criar extensão de UUID no postgres | |
CREATE EXTENSION unaccent SCHEMA public | |
CREATE EXTENSION "uuid-ossp" SCHEMA public |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment