Re: Backup - Mailing list pgsql-admin

From mike g
Subject Re: Backup
Date
Msg-id 1090639403.11436.4.camel@localhost.localdomain
Whole thread Raw
In response to Backup  ("Eduardo S. Fontanetti" <dufuzzy@yahoo.com.br>)
List 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 antivírus grátis!
> http://br.info.mail.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

pgsql-admin by date:

Previous
From: mike g
Date:
Subject: Re: Profiling
Next
From: Simon Riggs
Date:
Subject: Re: [HACKERS] Point in Time Recovery