Karl Wright <[EMAIL PROTECTED]> writes:
> (a) How do I get around the "out of memory" error for pg_restore?
Does this table have foreign key constraints? I imagine you're running
out of space for the deferred-trigger list.
> (b) How can I get the restore performance up to the level where it take
Tom Lane wrote:
Karl Wright <[EMAIL PROTECTED]> writes:
and then I installed 8.1, and attempted the following:
pg_restore --file dbsnapshot --format=t --table=ingeststatus -a
But, I get the following error:
pg_restore: [tar archiver] could not find header for file toc.dat in tar
archive
Oh, I
Karl Wright <[EMAIL PROTECTED]> writes:
> and then I installed 8.1, and attempted the following:
> pg_restore --file dbsnapshot --format=t --table=ingeststatus -a
> But, I get the following error:
> pg_restore: [tar archiver] could not find header for file toc.dat in tar
> archive
Oh, I'm overthi
Karl Wright wrote:
Tom Lane wrote:
Karl Wright <[EMAIL PROTECTED]> writes:
But, I get the following error:
pg_restore: [tar archiver] could not find header for file toc.dat in
tar archive
Could we see "pg_restore -l" output for that dump file?
This looks a bit like some bugs we've seen befo
Tom Lane wrote:
Karl Wright <[EMAIL PROTECTED]> writes:
But, I get the following error:
pg_restore: [tar archiver] could not find header for file toc.dat in tar
archive
Could we see "pg_restore -l" output for that dump file?
This looks a bit like some bugs we've seen before, eg,
http://archi
Karl Wright <[EMAIL PROTECTED]> writes:
> But, I get the following error:
> pg_restore: [tar archiver] could not find header for file toc.dat in tar
> archive
Could we see "pg_restore -l" output for that dump file?
This looks a bit like some bugs we've seen before, eg,
http://archives.postgresql
Hi,
I'm trying to move a database from postgresql 7.4 to postgresql 8.1.
Unfortunately this is not going well. This is what I did:
pg_dump --file dbsnapshot --format=t -a -b
and then I installed 8.1, and attempted the following:
pg_restore --file dbsnapshot --format=t --table=ingeststatus -
