Hi, Thomas Karcher <thkarcher@xxxxxx> wrote: > Hi, > > > this one is still open when I run pg_stop_backup(), so I want to trigger the > > archive_command to be sure that I don't miss anything. > > I guess what you want is pg_switch_xlog() (see > http://www.postgresql.org/docs/8.2/static/functions-admin.html) this is exactly what I am looking for > which became available with PG 8.2 ... unfortunately right now I am stuck to PG 8.1.4. I hope I can manage to upgrade without too much hassle, it seems meanwhile I have to use my workaround. thanks a lot Sebastian ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
