pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
backup problem
4+ messages / 4 participants
[nested] [flat]

* backup problem
@ 2006-05-04 15:11  Rodrigo Sakai <rodrigo.sakai@zanthus.com.br>
  0 siblings, 1 reply; 4+ messages in thread

From: Rodrigo Sakai @ 2006-05-04 15:11 UTC (permalink / raw)
  To: pgsql-admin

  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!!

  Thanks in advance!

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: backup problem
@ 2006-05-04 15:27  Jyry Kuukkanen <jyry@neutech.fi>
  parent: Rodrigo Sakai <rodrigo.sakai@zanthus.com.br>
  0 siblings, 1 reply; 4+ messages in thread

From: Jyry Kuukkanen @ 2006-05-04 15:27 UTC (permalink / raw)
  To: Rodrigo Sakai <rodrigo.sakai@zanthus.com.br>; +Cc: 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|:-(



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: backup problem
@ 2006-05-04 15:46  renneyt@yahoo.com <renneyt@yahoo.com>
  parent: Jyry Kuukkanen <jyry@neutech.fi>
  0 siblings, 0 replies; 4+ messages in thread

From: renneyt@yahoo.com @ 2006-05-04 15:46 UTC (permalink / raw)
  To: Jyry Kuukkanen <jyry@neutech.fi>; +Cc: Rodrigo Sakai <rodrigo.sakai@zanthus.com.br>; pgsql-admin

Jyry Kuukkanen wrote:
> 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,
>   


I use the same but use the bzip2 '--best' parameter for best compression 
or is that the default? Also for the OP Rodrigo Sakai, have your tried 
Solaris 10 x86? It is a rock solid OS from Sun that I have used for 12 
years - 6 of them with Postgres. The two have coexisted together without 
incident. It can be d/led for free at the Sun site.

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: backup problem
@ 2006-05-04 18:34  Tomeh, Husam <htomeh@firstam.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Tomeh, Husam @ 2006-05-04 18:34 UTC (permalink / raw)
  To: renneyt@yahoo.com, "Jyry Kuukkanen" <jyry@neutech.fi>; +Cc: Rodrigo Sakai <rodrigo.sakai@zanthus.com.br>; pgsql-admin

If your backup file still hit that limit even after being compressed,
you may want to use the split command to split it into chunks with the
desired size that suit your O/S.
Check out this PostgreSQL doc page on handling large databases:
http://www.postgresql.org/docs/8.1/interactive/backup.html
 
----
 
    Husam 
   http://firstdba.googlepages.com
 

________________________________

From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of renneyt@yahoo.com
Sent: Thursday, May 04, 2006 8:46 AM
To: Jyry Kuukkanen
Cc: Rodrigo Sakai; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] backup problem


Jyry Kuukkanen wrote: 

	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,
	  



I use the same but use the bzip2 '--best' parameter for best compression
or is that the default? Also for the OP Rodrigo Sakai, have your tried
Solaris 10 x86? It is a rock solid OS from Sun that I have used for 12
years - 6 of them with Postgres. The two have coexisted together without
incident. It can be d/led for free at the Sun site. 






**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged.  If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited.  If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

                                   FADLD Tag
**********************************************************************

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2006-05-04 18:34 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-04 15:11 backup problem Rodrigo Sakai <rodrigo.sakai@zanthus.com.br>
2006-05-04 15:27 ` Jyry Kuukkanen <jyry@neutech.fi>
2006-05-04 15:46   ` renneyt@yahoo.com <renneyt@yahoo.com>
2006-05-04 18:34 Re: backup problem Tomeh, Husam <htomeh@firstam.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox