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
