I had the same problem, but backing up the filesystem isn't the solution. I did it and when I tried to restore the database was impossible. If anyone knows how to solve this problem please let me know
"Leong, Fushan" wrote: > Hi : > > I am very new in postgres and hope someone can give me some suggestions > > I am working on a shell script to backup my postgres database. Compared > with pg_dump and pg_dumpall, I would > like to backup the file system instead of dump the database because I can > shutdown the database server in > midnight for a few hours. I also can sure I will have a stable backup. ( No > user is doing anything at the same time ) > > I search internet but did not find anyone mention this method. Did I miss > anything? I plan to backup all > files under data directory. Is that enough? > > thanks > Fushan > DBA > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html
begin:vcard n:Solari;Francisco J. tel;work:(011) 4378-4257 x-mozilla-html:FALSE org:Provincia Salud S.A.;Sistemas adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] title:Analista de Sistemas fn:Francisco J. Solari end:vcard
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
