| From: | Jyry Kuukkanen <jyry(at)neutech(dot)fi> |
|---|---|
| To: | Rodrigo Sakai <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: backup problem |
| Date: | 2006-05-04 15:27:01 |
| Message-ID: | Pine.LNX.4.58L.0605041822330.17141@cyclone.neutech.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, 4 May 2006, Rodrigo Sakai wrote:
> Hi, I'm trying to do a backup of a database that is larger then 4 GB. But it gets an error when the file size gets 1.2 GB! I think its an Operational System problem (linux)! So, I want to know if exists some solution to backup my database??
>
> The command that I used was=
>
> pg_dump -U postgres -d dbdeveloper -a -v -D -f 'backup.sql'
>
> The operational system is linux with etx filesystem, and the version of postgres is 7.4!!
You can try:
pg_dump -U postgres -d dbdeveloper -a -v -D |bzip2 -c >backup.sql.bz2
bzip2 compresses better than gzip.
Restoration:
bzcat backup.sql.bz2|psql - postgres -d dbdeveloper
Cheers,
--
--Jyry
C|:-( C|:-/ C|========8-O C|8-/ C|:-(
| From | Date | Subject | |
|---|---|---|---|
| Next Message | renneyt@yahoo.com | 2006-05-04 15:46:15 | Re: backup problem |
| Previous Message | Rodrigo Sakai | 2006-05-04 15:11:27 | backup problem |