| From: | Benjamin Arai <barai(at)cs(dot)ucr(dot)edu> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Running with fsync=off |
| Date: | 2005-12-22 07:30:15 |
| Message-ID: | 43AA5607.20000@cs.ucr.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sandhya | 2005-12-22 07:46:31 | Fw: How to get OID return value(pls help me) |
| Previous Message | Richard Huxton | 2005-12-22 07:27:23 | Re: [GENERAL] PostgreSQL crashing |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Dean | 2005-12-22 07:31:04 | Is CREATE TYPE an alias for CREATE DOMAIN? |
| Previous Message | Richard Huxton | 2005-12-22 07:27:23 | Re: [GENERAL] PostgreSQL crashing |