Michael Paesold wrote: > Tom Lane wrote: > > > Bruce Momjian wrote: > >> OK, makes sense. Could we give them a command to archive it before they > >> shut down? That would make sense. > > > > Not if the idea is to be certain you got everything ... I think what we > > have to do is document a manual procedure for archiving the last XLOG > > file. > > What Bruce would want is a way to "stop new transactions, archive and > shutdown", which would do this atomically. Then we could have another > shutdown switch for pg_ctl.
Yea, probably a separate switch, or an additional switch to pg_clt would be best, but then we have to add to pg_ctl. > But yea, a documentation for a manual procedure would be ok, too, just not > as user friendly. Right. I just hate the 'do this, do that' instructions to PITR. When they get too long/complex, I get worried. I used to use Informix's ontape, which was a bad user interface because the admin had to be sure it was always running. Anyway, when you control-C'ed the process, it would flush out any partially written wal file and you knew you had everything. I am thinking a special pg_ctl flag, and disabling -W for that so you have to wait for the success message. Of course we then have to document the use of the pg_ctl flag then. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
