Frederiko Costa <frederiko@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
