Backup

[Eduardo S. Fontanetti]

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

[mike g]

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

Post by Eduardo S. Fontanetti
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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster