Skip site navigation (1) Skip section navigation (2)

Upgrade problems

From: Roy Souther <roy(at)silicontao(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Upgrade problems
Date: 2001-07-26 20:23:47
Message-ID: 0107261423470A.02987@UtopiaPlanitia (view raw or flat)
Thread:
Lists: pgsql-admin
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 


pgsql-admin by date

Next:From: Roy SoutherDate: 2001-07-26 22:54:04
Subject: psql error: file to large!
Previous:From: Robert.FarrugiaDate: 2001-07-26 05:34:27
Subject: Re: Requirements for a database server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group