From: | Weiping He <laser(at)zhengmai(dot)com(dot)cn> |
---|---|
To: | Roy Souther <roy(at)silicontao(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: psql error: file to large! |
Date: | 2001-07-27 15:16:12 |
Message-ID: | 3B6185BC.60981A15@zhengmai.com.cn |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Roy Souther wrote:
> 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?
>
The single file size in ext2 can't exceed 2G,
so I think you should use 'gzip' to compress the dump,
or use 'split' to split the large file, or use 'pg_dump -t table_name'
to dump only one table.
see:
http://www.postgresql.org/idocs/index.php?backup.html#BACKUP-DUMP-LARGE
would help.
regards laser
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-07-27 16:08:38 | Re: Full Case INSENSITIVE ... |
Previous Message | Roy Souther | 2001-07-27 14:42:54 | PG 7.1.2 table names? |