From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Aaron Brown <abrown(at)bzzagent(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_restore failing with "ERROR: out of memory" |
Date: | 2008-03-19 19:17:01 |
Message-ID: | 17818.1205954221@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Aaron Brown <abrown(at)bzzagent(dot)com> writes:
> Yes, it kind of needs to be data only since I am pulling from a slonized
> database. My experience has been if you dont load the schema first with a
> schema from slony1_extract_schema.sh, we end up with all the slony triggers
> and crap in the dump. If there is a better way of doing this, Im
> definitely all ears.
Well, you'd need to take that up on the Slony lists, but I'd say that
Slony definitely ought to provide a better export mechanism than forcing
you to use a standard data-only dump. At minimum they should teach that
script to emit two separate files: one to load before the data and one
after. Building the indexes and FK constraints on already-loaded data
is a heck of a lot faster.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Aaron Brown | 2008-03-19 19:27:00 | Re: pg_restore failing with "ERROR: out of memory" |
Previous Message | Aaron Brown | 2008-03-19 19:08:59 | Re: pg_restore failing with "ERROR: out of memory" |