Skip to content

Instantly share code, notes, and snippets.

@fike
fike / load_csv.sh
Created August 14, 2012 21:44
Loading multiple files csv in postgresql
#!/bin/sh
for i in $(ls *.csv)
do psql -U postgres -c "COPY carga FROM '/tmp/$i' WITH DELIMITER ',' CSV HEADER" test;
done
pgvm install 9.2.2
downloading 'http://ftp.postgresql.org/pub/source/v9.2.2/postgresql-9.2.2.tar.gz', please be patient... done.
checking 'postgresql-9.2.2.tar.gz' integrity... done.
extracting postgresql-9.2.2.tar.gz ... done.
configuring PostgreSQL Version: 9.2.2 ... done.
compiling ... ERRO: can not compile PostgreSQL 9.2.2, see make.error.log for details.
@fike
fike / syslinux_debian.sh
Last active December 14, 2015 02:59
Syslinux Debian installation
dd if=/ sr/lib/syslinux/mbr.bin of= /dev/sdb
syslinux /dev/sdb1
mount /dev/sdb1 /mnt/pendrive
cp /usr/lib/syslinux/menu.c32 /mnt/pendrive
mkdir /mnt/pendrive/debian64
mkdir /mnt/pendrive/rh64
wget http://ftp.debian.org/debian/dists/lenny/main/installer-amd64/current/images/hd-media/boot.img.gz
@fike
fike / syslinux_rh.sh
Created February 22, 2013 23:50
Syslinux Red Hat like installation
dd if=/usr/lib/syslinux/mbr.bin of=/dev/sdb
syslinux /dev/sdb1
mount /dev/sdb1 /mnt/pendrive
cp /usr/lib/syslinux/menu.c32 /mnt/pendrive
mkdir /mnt/pendrive/debian64
mkdir /mnt/pendrive/rh64
mount -o loop rhel-5.2-server-x86_64-dvd.iso /mnt/temp
fike@klatoon:~$ LDFLAGS="-Wl,--as-needed" pgvm install 9.2.2
downloading 'http://ftp.postgresql.org/pub/source/v9.2.2/postgresql-9.2.2.tar.gz', please be patient... done.
checking 'postgresql-9.2.2.tar.gz' integrity... done.
extracting postgresql-9.2.2.tar.gz ... done.
configuring PostgreSQL Version: 9.2.2 ... done.
compiling ... done.
installing ... done.
#!/bin/bash
#
# Simple script to length image optimization.
# Fernando Ike - fike@midstorm.org.
#
#
#
DIR=$HOME/d/octopress/source/images
CONVERT=$(which convert)
@fike
fike / gist:5030235
Last active December 14, 2015 04:39
Show pgvm errors
pgvm install 9.2.2
downloading 'http://ftp.postgresql.org/pub/source/v9.2.2/postgresql-9.2.2.tar.gz', please be patient... done.
checking 'postgresql-9.2.2.tar.gz' integrity... done.
extracting postgresql-9.2.2.tar.gz ... done.
configuring PostgreSQL Version: 9.2.2 ... done.
compiling ... ERRO: can not compile PostgreSQL 9.2.2, see make.error.log for details.
@fike
fike / sqlite2pg.sh
Last active December 14, 2015 12:58 — forked from eclubb/sqlite2pg.sh
#!/bin/sh
# This script will migrate schema and data from a SQLite3 database to PostgreSQL.
# Schema translation based on http://stackoverflow.com/a/4581921/1303625.
# Some column types are not handled (e.g blobs).
SQLITE_DB_PATH=$1
PG_DB_NAME=$2
PG_USER_NAME=$3
function addBlankTargetForLinks () {
$('a[href^="http"]'||'a[href^="https"]').each(function(){
$(this).attr('target', '_blank');
});
}
$(document).bind('DOMNodeInserted', function(event) {
addBlankTargetForLinks();
});
@fike
fike / recovery_octopress_p.rb
Last active March 30, 2021 01:11
Recovery Octopress post to markdown
#!/usr/bin/env ruby
# This script (recovery_octopress_p.rb) convert Octopress post, more specific the body in
# Octopress markdown files and it need that pages stay in local computer.
# Its license is LGPL-2.1 and more details, you can look this FSF link:
# - https://www.gnu.org/licenses/old-licenses/lgpl-2.1.html
#
# It was developed for Fernando Ike de Oliveira <fike@midstorm.org>.
#
# Some bugs knows:
# - A problem to convert "." in title to dot word. Octopress was do much better