Change your private key formant from OPENSSL (--BEGIN OPENSSH PRIVATE KEY--) to PEM (--BEGIN RSA PRIVATE KEY--)
$ ssh-keygen -p -m pem -f my_private_file
| ## Fonts | |
| # Family | |
| font_family Hack Nerd Font Mono | |
| bold_font Hack Nerd Font Mono Bold | |
| italic_font Hack Nerd Font Mono Italic | |
| bold_italic_font Hack Nerd Font Mono Bold Italic | |
| # Font Size | |
| font_size 13.0 | |
| disable_ligatures never |
| #!/bin/bash | |
| usage() | |
| { | |
| cat << EOF | |
| usage: $0 options | |
| OPTIONS: | |
| -h Show this message | |
| -d Database name |
Change your private key formant from OPENSSL (--BEGIN OPENSSH PRIVATE KEY--) to PEM (--BEGIN RSA PRIVATE KEY--)
$ ssh-keygen -p -m pem -f my_private_file
Extract a limit records from a table and restore it on postgresql
SELECT p.*
INTO TABLE tmp_my_table
from my_table p
I hereby claim:
To claim this, I am signing this object:
| #!/bin/bash | |
| ## usage | |
| # default: ./postgresql_backup.sh | |
| # load envs | |
| # Create a file .backup_envs | |
| # DB_NAME=mydb | |
| # DB_HOST=myhost | |
| # DB_PORT=5432 | |
| # DB_USER=my_user | |
| # DB_PASS="supersecretstring" |
| version: '3' | |
| services: | |
| database: | |
| image: 'mongo:3.6' | |
| command: --serviceExecutor adaptive | |
| container_name: 'mongodb-service' | |
| volumes: | |
| - mongo_data:/data/db |
| #!/bin/bash | |
| usage() | |
| { | |
| cat << EOF | |
| usage: $0 options | |
| This script set ownership for all table, sequence and views for a given database and schema. | |
| NOTES: |