Re: naming of wal-archives

On 01/31/2013 01:48 AM, Neil Worden wrote:
>
> Btw, ps shows:
>

>
> The archiver process says "last was 000000010000006E00000034" and when i
> look into my wal-archive-directory i see:
>
> -rw------- 1 postgres postgres 16777216 Jan 31 10:24
> 000000010000006E00000033
> -rw------- 1 postgres postgres 16777216 Jan 31 10:24
> 000000010000006E00000034
> -rw------- 1 postgres postgres 16777216 Jan 29 16:03
> 000000010000008C0000008E
> -rw------- 1 postgres postgres 16777216 Jan 29 16:32
> 000000010000008C0000008F
>
> The 6E..34 file was just written by the archiver process. But further
> down at the same time this file was written:
>
> ...
> -rw------- 1 postgres postgres 16777216 Jan 31 10:24
> 000000010000008E00000054
>
> which seems to match the position of the streaming wal-senders .
>
> Any ideas ?

Yes, I think you are going to have to map this out for us.

Something like:

pg_receivexlog to ?
/
Machine A (Master) Archiving on ----> /some_archive_dir
\
Machine B (standby)
\
Machine C (standby)

I cannot follow what is going on from the written description.

>
> Thanks, Neil.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com