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
H
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Wed, Jul 27, 2005 at 05:13:01PM -0700, Chris Travers wrote:
>> Thomas F. O'Connell wrote:
>>> I'm not sure why you're getting errors. Is there a reason you did the
>>> schema dump separately from the data dump rather than a monolithic
>>> dump/res
Interesting, How would I specify the order of the tables on the commandline
To Thomas: I decided to separate the schema/data export/import to make sure the
schema was at least being created correctly...
How can I export one table by itself? Not just table, but a view/trigger,
etc... Is
it eve
On Wed, Jul 27, 2005 at 05:13:01PM -0700, Chris Travers wrote:
> Thomas F. O'Connell wrote:
>
> >The implicit indexes are no big deal; they're just a sign of indexes
> >getting created by PRIMARY KEYs on your tables.
> >
> >I'm not sure why you're getting errors. Is there a reason you did the
Thomas F. O'Connell wrote:
Jonathan,
The implicit indexes are no big deal; they're just a sign of indexes
getting created by PRIMARY KEYs on your tables.
I'm not sure why you're getting errors. Is there a reason you did the
schema dump separately from the data dump rather than a monolit
On Jul 27, 2005, at 3:43 PM, Jonathan Villa wrote:
My approach will be/has been as follows:
I've used pg_dump of 7.4 to do
pgsql-7.4 $>pg_dump --schema-only dbName > schema.sql
Aside from some tweaking, the import seemed to work fine.
Now, I'm attempting the following
pgsql-7.4 $> pg_dump
My approach will be/has been as follows:
I've used pg_dump of 7.4 to do
pgsql-7.4 $>pg_dump --schema-only dbName > schema.sql
Aside from some tweaking, the import seemed to work fine.
Now, I'm attempting the following
pgsql-7.4 $> pg_dump --data-only --inserts dbName > data.sql
and when I a
Jonathan Villa wrote:
I've been googling a little bit and appears that 7.1 pretty old.
What steps are advised to upgrade from 7.1 to 7.4?
1. Dump the old db using 7.4's pg_dump.
2. Read the release notes for the in-between versions to make sure
nothing will impact your behaviour. Keep a close
On Wednesday 27 July 2005 11:41 am, Jonathan Villa wrote:
> I've been googling a little bit and appears that 7.1 pretty old.
Very.
> What steps are advised to upgrade from 7.1 to 7.4?
Unless there is some reason you really need 7.4, just go straight to
8.0.3.
Instructions start on page 230 of
On Wed, 2005-07-27 at 13:41, Jonathan Villa wrote:
> I've been googling a little bit and appears that 7.1 pretty old. What steps
> are
> advised to upgrade from 7.1 to 7.4?
The best way, in my humble opinion, is to build a new machine, and
install 7.4 or 8.0 on it. Backup the old 7.1 machine us
10 matches
Mail list logo
