psql error: file to large!
От | Roy Souther |
---|---|
Тема | psql error: file to large! |
Дата | |
Msg-id | 0107261654040I.02987@UtopiaPlanitia обсуждение исходный текст |
Список | 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@silicontao.com> 01100010 10101110 11000110 11010110 00000100 10110010 10010110 11000110 01001110 11110110 11001110 00010110 10010110 00101110 10000100 10000100
В списке pgsql-admin по дате отправления: