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
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 |