I want to be able to do large updates on an existing backed up database with fsync=off but at the end of the updates how do I ensure that the data gets synced?

Somebody said running "sync ; sync; sync" from the console. This seems reasonable but why not just "sync" or is there another command I should ruyn after the update either in postgres or the console?

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to