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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
