Skip to content

Instantly share code, notes, and snippets.

@valentinvieriu
valentinvieriu / README.MD
Last active May 26, 2024 10:12
Backup, restore postgres in docker container
  • make sure you mounted /var/lib/postgresql/data/ as a volume
  • to backup the database run this over docker exec replace tools_postgres_1 with the name of your postgres container
docker exec tools_postgres_1 bash -c "pg_dump --username=postgres --no-password --format=t db_name | gzip > /var/lib/postgresql/data/backup/backup_local_$(date +%Y-%m-%d).tar.gz"
  • restore the database using portainer console
docker exec tools_postgres_1 bash -c "pg_restore --username=postgres --no-password --dbname=db_name --verbose /var/lib/postgresql/data/backup/backup_local_29-01-2017.tar.gz"
  • to drop the old database use
@valentinvieriu
valentinvieriu / axios_promises_reduce.js
Last active August 22, 2017 12:34 — forked from tokland/promise_map.js
Sequential execution of axios get requests using reduce()
const axios = require('axios');
function random(min, max) {
return (Math.random() * ((max ? max : min) - (max ? min : 0) + 1) + (max ? min : 0)) | 0;
}
function wait(promise) {
const seconds = random(300, 2000);
return new Promise((resolve, reject) => {
setTimeout(() => resolve(promise()), seconds);
const request = function request(reqUrl,options = {}) {
// parse url to chunks
reqUrl = url.parse(reqUrl);
// http.request settings
let settings = {
protocol: reqUrl.protocol,
host: reqUrl.hostname,
path: reqUrl.path,
port: reqUrl.port ? reqUrl.port : (reqUrl.protocol === 'https:' ? 443 : 80),
headers: {

Keybase proof

I hereby claim:

  • I am valentinvieriu on github.
  • I am valentin_v (https://keybase.io/valentin_v) on keybase.
  • I have a public key whose fingerprint is 39AE A0F2 A885 A843 7BCE 36CC BDD4 2561 0960 69F1

To claim this, I am signing this object:

#!/bin/bash
width=60;
height=60;
x_offset=10;
y_offset=5;
filelist=`ls | grep '.jpg'`
for image_file in $filelist
do
preextensionfilename=`convert $image_file -format "%t" info:`
convert $image_file -crop ${width}x${height}+${x_offset}+${y_offset} \