Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> I see your point. New text is:
>
> 4 Again connect to the database as a superuser, and issue the command
>
> SELECT pg_stop_backup();
>
> This should return successfully.
>
> 5 Once the WAL segment files used during the backup are archived as
> part of normal database activity, you are done.
>
> > sure that they get a good base backup. It actually seems like something
> > that maybe pg_stop_backup() should do in the future.
>
> Yes, I added that to the TODO list:
>
> * Force archiving of partially-full WAL files when pg_stop_backup() is
> called or the server is stopped
You could even make pg_stop_backup() hang until that's complete.
--
greg