11 нояб2021

docker compose Postgres run

Written by Super User. Posted in Articles Unix

I need migrate  DB from faildown AKS conteiners with postgres 9.6 to Azure Database for PostgreSQL 11 

so I use:

  1. link
  2. link2
  3. link3
  4. link4
  5. Download PVC disk frome AZURE and open VHD file disk 
  • #istall psql client
    • sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
    • sudo yum install -y postgresql11
  • #install docker    

    sudo yum install -y yum-utils
    sudo yum-config-manager     --add-repo     https://download.docker.com/linux/centos/docker-ce.repo
    sudo yum-config-manager --enable docker-ce-nightly
    sudo yum-config-manager --enable docker-ce-test
    sudo yum-config-manager --disable docker-ce-nightly
    sudo yum install docker-ce docker-ce-cli containerd.io
    yum list docker-ce --showduplicates | sort -r
    wq
    sudo systemctl start docker
    sudo systemctl enable docker
    sudo systemctl status docker
    sudo docker run hello-world

  • #install docker-compose    

 sudo curl -L "https://github.com/docker/compose/releases/download/1.29.2/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose

or

sudo curl -L "https://github.com/docker/compose/releases/download/v2.6.0/docker-compose-linux-x86_64" -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

  • #vi docker-compose-postgres.yml
    • version: '3'
      services:
        database:
          image: postgres:9.6.23 # use latest official postgres version
          env_file:
            - database.env # configure postgres
          volumes:
            - database-data:/var/lib/postgresql/data/ # persist data even if container shuts down
          ports:
            - "5432:5432"
      volumes:
        database-data: # named volumes can be managed easier using docker-compose
  • #vi database.env

    • POSTGRES_USER=ksi
      POSTGRES_PASSWORD=ksi
      POSTGRES_DB=ksi

  • #sudo docker-compose -f docker-compose-postgres.yml up -d
  • #docker ps
  • #psql --host=127.0.0.1 --username=ksi --dbname=ksi

  • Еще один вариант подключиться к базе данных, не устанавливая дополнительных утилит — подключиться непосредственно к Docker-контейнеру. Для этого выполним команду docker exec с дополнительными ключами:

    •  sudo docker exec -it $(docker ps| grep postgres | awk '{print $1}') psql -U ksi
    • sudo docker exec -it $(docker ps| grep postgres | awk '{print $1}') bash
  • After that I have run DB server with DBs located on folder 
    • ll /var/lib/docker/volumes/psql_database-data/_data/
  • #sudo docker-compose -f docker-compose-postgres.yml down

  • #get our DBs dump
    DBuser='ksi'
    DBdbname='ksi'
    DBhost='127.0.0.1'
    pg_dump -Fc --host=$DBhost --username=$DBuser $DBdbname --file=sandbox.dump

  • #restore to Azure Database for PostgreSQL                             default DBdbname='postgres'

    DBuser='{azureAdminDB}@{azureDBhostname}'
    DBpass='{azurePassDB}'
    DBdbname='{AzureDB}'
    DBhost='{azureDBhostname}.postgres.database.azure.com'
    #for connect to Azure DB? if need test connect/creat/flush DB
    psql "host=$DBhost port=5432 dbname=$DBdbname user=$DBuser sslmode=require"
  • show DB version
    •  SELECT version();
    • CREATE DATABASE lusiadas;
    • DROP DATABASE <database_name>;
    • DROP DATABASE db_name WITH (FORCE)
      pg_restore --no-owner --host=$DBhost --port=5432 --username=$DBuser --dbname=$DBdbname $DBdbname.dump
Добавить комментарий
23 сен2021

Docker support & clear trash

Written by Super User. Posted in Articles Unix

You can get the basic information about your Docker configuration by executing:

$ docker info
 Storage Driver: overlay2
 Docker Root Dir: /var/lib/docker

Clearing:
https://habr.com/ru/post/486200/

  • -Show:
    • docker system df
    • docker ps 
    • docker container ls
    • docker image ls
    • netstat -tulpn     #show services
    • docker logs -f fdea35c59924 1>/dev/null
    • docker logs 8738c47aebbb --tail N
    • docker stats    running at this moment conteyners
  • Stop/kills
    •  docker stop $(docker ps -a -q)   kill 
  • Clearning
    •   Volumes
      • docker volume ls
      • docker volume prune
      • rm -rf $(docker volume ls -qf dangling=true )
      • cd {docker volumes PATH} && rm -rf $(docker volume ls -qf dangling=true | grep -v sql)
      • docker volume rm $(docker volume ls -q)
      • docker volume rm $(docker volume ls -qf dangling=true | grep -v sql)
      • hard clear volumes  
        • cd /home/docker/volumes/
rm -rf $(docker volume ls -qf dangling=true)
      • Cash
        • docker system prune -a
      • Images
        • docker images
        • docker image prune  #удалить все установленные контейнеры и очистить ваш диск от всех созданных ими на уровне чтения-записи файлов
        • docker image rm $(docker image ls -f dangling=true -q) -f
        • docker image rm $(docker image ls -q)
        • docker image rm $(docker image ls -q) -f   clear all images
      • Conteiners
        • docker container prune
        • Stop all running containers: docker stop $(docker ps -a -q)
        • Delete all stopped containers: docker rm $(docker ps -a -q)
        •  
1 комментарий
03 авг2021

CloneFileZilla

Written by Super User. Posted in Articles Unix

  1.  Download rufus https://github.com/pbatard/rufus/releases/download/v3.15/rufus-3.15.exe   for windows OS
  2.  Download ISO filezilla https://deac-fra.dl.sourceforge.net/project/clonezilla/clonezilla_live_stable/2.7.2-39/clonezilla-live-2.7.2-39-amd64.iso
  3.  Creat boot USB disk
  4.  Boot PC from disk(change BIOS setting for boot)
  5. Boot frome CloneFileZilla ISO:
    • Choose
    • -- English-keep(default keyboard)
    • -- Start_Clonezilla
    • --"device-device"(work directly disk-disk)
    • ---Beginer
    • --disk_to_local_disk
    • Choose source disk to destination disk
    • "sfsck"(skip checking/repairing source file system)
    • -p choose(choose reboot/shutdown)
    • y   y 
Добавить комментарий
14 мая2021

ssh by key

Written by Super User. Posted in Articles Unix

ssh-keygen :

ssh-keygen -t rsa -b 4096 -C "ssh_key_auth"

ssh-copy-id username@remote_host 

ssh-copy-id Адрес электронной почты защищен от спам-ботов. Для просмотра адреса в вашем браузере должен быть включен Javascript.

or

cat /root/.ssh/id_rsa.pub | ssh Адрес электронной почты защищен от спам-ботов. Для просмотра адреса в вашем браузере должен быть включен Javascript..1.6 'cat >> /etc/ssh/keys-root/authorized_keys'   for VmWare Esx

try connect:

ssh 192.168.1.131
chmod =600 ~/.ssh/ id_rsa
chmod =600 ~/.ssh/ id_rsa.pub
chmod 750 /root/.ssh
chmod 644 /root/.ssh/authorized_keys
Добавить комментарий
20 апр2021

BackUP restore Postgress

Written by Super User. Posted in Articles Unix

$date_rep = get-date -uformat "%A"
$catalogPOST = "C:\Program Files\PostgreSQL\10.15-4.1C\bin"
$userDB = "postgres"
# command save password for CMD 
#SET 'PGPASSWORD = PostAdmin';

# command save password for powershell 
$env:PGPASSWORD = 'PostAdmin';

cd $catalogPOST 
$databases = .\psql.bat --% -U postgres -w -l -t -A
$databases = foreach ($database in $databases){[regex]::escape($database) -replace "\\\|.+$",""}
$databases = $databases | Select-String "^(?!.*postgres)"| Select-String "^(?!.*template)" | Select-String "^(?!.*Copy)" | Select-String "^(?!.*Perf_test)"# | Select-String "(\S*_\S*_\S*)"

foreach ($database in $databases)
{ 
$file_db = "D:\backUp\1c\Postgress\" + $date_rep + "_" +$database + ".sql"
cmd /c  $catalogPOST\pg_dump.exe --file $file_db --host "localhost" --port "5432" --username $userDB --verbose --format=c --blobs $database
}

# cmd /c  $catalogPOST\pg_restore.exe --host "localhost" --port "5432" --username $userDB  --dbname "ksi" --verbose $file_db

Добавить комментарий

Еще статьи...

Login