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

Re: Backup

From: mike g <mike(at)thegodshalls(dot)com>
To: "Eduardo S(dot) Fontanetti" <dufuzzy(at)yahoo(dot)com(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backup
Date: 2004-07-24 03:23:23
Message-ID: 1090639403.11436.4.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-admin
If you stop the postmaster service before copying the database directory
yes.

See http://www.postgresql.org/docs/7.4/static/backup-file.html

Mike
On Fri, 2004-07-23 at 07:24, Eduardo S. Fontanetti wrote:
> I have a question.
> 
> I am getting trouble to dump my database with LO
> (Large Object), but exactly at restoring.
> 
> Then I ask: If I just copy the data directory from
> pgsql directory, I can restore the databases just
> copying this directory back from a backup?
> 
> Thanks
> 
> Eduardo
> 
> 
> 	
> 	
> 		
> _______________________________________________________
> Yahoo! Mail agora com 100MB, anti-spam e antivrus grtis!
> http://br.info.mail.yahoo.com/
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to

  • Backup at 2004-07-23 12:24:06 from Eduardo S. Fontanetti

pgsql-admin by date

Next:From: Colin StagnerDate: 2004-07-24 19:40:43
Subject: PG crashes MacOS 10.3.4
Previous:From: mike gDate: 2004-07-24 03:21:02
Subject: Re: Profiling

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