Francisco : Would you tell me what problem did you face when you try to restore the database from backup filesystem?
Fushan -----Original Message----- From: Francisco Solari [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 5:41 AM To: Leong, Fushan Cc: '[EMAIL PROTECTED]' Subject: Re: [ADMIN] backup file system 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
