Help with pg_restore

From: "dan" <dan(at)webfolks(dot)us>
To: pgsql-novice(at)postgresql(dot)org
Subject: Help with pg_restore
Date: 2003-08-20 19:41:01
Message-ID: 20030820194101.25683.qmail@home.mahoneys.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm having some problems running pg_rstore, and reading the documentation
hasn't helped.

We've got a large database system (several 10s of gigabytes). We have a copy
of our database that was generated by db_dump. We had our RAID array crash a
week ago, and just finished repairing it, so I now have to restore the
database.

The db_dump output was split into 3 files; let's call them file1, file2, and
file3.

I created the data directory, then ran initdb to do the intial setup. I next
ran:
cat file1 file2 file3 | pg_restore --clean --create
It churned for a while and generated a lot of output (file1 and file 2 are
just over a gigabyte each, and file3 is about 300 MB). But when I ran psql,
none of the tables had been created. What am I doing wrong?

Just for giggles I specified "--file=reload.sql" and ran it again, thinking
I could build a file that I could then feed into psql to do the restore. But
that died with a "maximum file size exceeded" error. I'm assuming that's
because of how pg_restore was compiled (we've for some pretty massive files
(well over 2 GB) on disk, so our install of Linux obviously supports files
larger than 2 GB).

What do I need to do to get our database back? I am not able to get any
useful work done until I can get access to the database again.

HELP!

--------------------------
Dan Mahoney
dan(at)webfolks(dot)us
AA6GF

"How you behave towards cats here below determines your status in Heaven."
Robert Heinlein

"There are two means of refuge from the miseries of
life - music and cats" - Albert Schweitzer

Browse pgsql-novice by date

  From Date Subject
Next Message Brian G. Huber 2003-08-20 19:58:17 Pls help - Limiting query results by percentage of results
Previous Message Tom Lane 2003-08-20 18:24:28 Re: Installing plpgsql proc language