Greg Donald : database Tag

Reorder Rails database migrations files

November 26, 2023

On new Rails apps, that are not in production yet, I sometimes like to reorder my database migrations. I wrote a small Ruby script to automate things.

rails (4) database (2)

PostgreSQL Backup Script

March 28, 2021

#!/bin/sh

DB_NAME=mydatabase
DATE=`date +%Y%m%d%H%M%S`
DIR=/backups/pgsql
PG_DUMP=/usr/bin/pg_dump

$PG_DUMP $DB_NAME | bzip2 > $DIR/$DB_NAME_$DATE.sql.bz2

find $DIR -mtime +7 -exec rm {} \;

postgresql (3) database (2) backup (1)

About

Author, software maker, RC airplane enthusiast, player of strung instruments, bibliophile.

Reorder Rails database migrations files

PostgreSQL Backup Script

About

Social

Archives