| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Colin Stagner | 2004-07-24 19:40:43 | PG crashes MacOS 10.3.4 |
| Previous Message | mike g | 2004-07-24 03:21:02 | Re: Profiling |