Re: archived WALL files question

Frederiko Costa <frederiko@gmail.com> wrote:
> I have seen new 16 MB segments files created in pg_xlog directory
> as time goes on. Honestly, I did not understand why it got
> created, because I was running it on a VM and there was no
> activity. I got several new segments.
>
> If I run the command you asked, this is the output. Neither
> segment is copied, nor a new segment file gets created:
>
>   select pg_switch_xlog();
>   pg_switch_xlog
> ----------------
>   0/81000088
> (1 row)

What version of PostgreSQL is this?

What do you see if you run?:

show archive_command;
show archive_mode;
show archive_timeout;

Check your log file from the time you ran pg_switch_xlog to look for
any messages which might give a clue to what's happening.

-Kevin