Adding pg_extract.sh
1 files changed, 6 insertions(+), 0 deletions(-) A => bin/pg_extract.sh
A => bin/pg_extract.sh +6 -0
@@ 0,0 1,6 @@ +#!/bin/bash +# Extract specific db from pg_dumpall file. +# IE: pg_extract.sh dump.sql dbname > dbname.sql +[ $# -lt 2 ] && { echo "Usage: $0 <postgresql dump> <dbname>"; exit 1; } +#sed "/connect.*$2/,\$!d" $1 | sed "/PostgreSQL database dump complete/,\$d" +sed -r "/\\\\connect\\s+$2/,\$!d" $1 | sed "/PostgreSQL database dump complete/,\$d"