Re: Upgrading from 7.1 - Mailing list pgsql-general

From Chris Travers
Subject Re: Upgrading from 7.1
Date
Msg-id 42E855DF.7050305@metatrontech.com
Whole thread Raw
In response to Re: Upgrading from 7.1  ("Jonathan Villa" <jvilla@innovativesource.net>)
List pgsql-general
Hi All;

Actually, as I am remembering how I worked through this problem...

I ended up withh a simple shell script something like:

#!/bin/bash
dumpfile="dump.pgsql"
pg_dump -s dbname > $dumpfile
for a in table1 table2 table3 table4 table5 table5 table6
do
   pg_dump -a -t $a >> $dumpfile
done

Hope this helps,
Chris Travers
Metatron Technology Consulting



Attachment

pgsql-general by date:

Previous
From: Ezequiel Tolnay
Date:
Subject: pg_get_serial_sequence and inheritance
Next
From: Dorine Periolat
Date:
Subject: Trigger ad mutli database