Skip to content

Instantly share code, notes, and snippets.

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.
@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
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
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 / 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