From: | Roy Souther <roy(at)silicontao(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | psql error: file to large! |
Date: | 2001-07-26 22:54:04 |
Message-ID: | 0107261654040I.02987@UtopiaPlanitia |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
This is a follow up to my previous post "Upgrade problems"
I compiled from source and have the same problem.
---------------------- My original post. ----------------------------------
I have a large database. I had PG 7.0. I did the data dump and got a 2.5 GB
file. But when I tried to run psql with the new 7.1.2 I get a file to large
error and nothing happens psql exits.
Is there a limit with psql? I am hoping it was compiled wrong. I insted from
the binary RPMS for Mandrake 8.0.
I will try compiling the source and see if that fixes the problem.
Is there some way I could dump to two files?
Do a dump on individual tables? pg_dumpall just does an SQL "COPY
<table_name> TO stdio" so is there and easy what I could write a bash script
to do a dump like this for each table? Then I could restore them one table
at a time right?
I have no large object in the tables. Every thing should go to text easy. How
would I get it back?
--
Roy Souther <roy(at)silicontao(dot)com>
01100010 10101110 11000110 11010110 00000100 10110010 10010110 11000110
01001110 11110110 11001110 00010110 10010110 00101110 10000100 10000100
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-07-27 05:07:30 | Re: Requirements for a database server |
Previous Message | Roy Souther | 2001-07-26 20:23:47 | Upgrade problems |