Re: Recovery Assistance

[Brian Mills <brian@xxxxxxxxxxxxxx>]

Yes, its the last one in the directory, pg_xlog directory 

...more files...

-rw-------  1 postgres postgres 16777216 Jan 21 10:05 0000000100000005000000A1

-rw-------  1 postgres postgres 16777216 Jan 22 21:29 0000000100000005000000A2

-rw-------  1 postgres postgres 16777216 Jan 24 02:08 0000000100000005000000A3

Brian Mills

CTO

Mob: 0410660003

Melbourne 03 9012 3460 or 03 8376 6327 |  Sydney 02 8064 3600 |  Brisbane 07 3173 1570

Level 1 |  600 Chapel Street | South Yarra|  VIC |  3141 |  Australia 

  

On 29 January 2017 at 08:18, rob stone <floriparob@xxxxxxxxx> wrote:

Hello Brian,
On Sun, 2017-01-29 at 07:16 +1100, Brian Mills wrote:
> Hi,
>
> No, it hasn't changed since the first time I looked at it. 
>
> root@atlassian:/home/tbadmin# ps ax | grep post
>  1364 ?        Ss     0:00 /usr/lib/postfix/master
>  5198 pts/3    S      0:00 su postgres
>  5221 pts/3    S      0:00 /usr/lib/postgresql/9.3/bin/postgres -D
> /etc/postgresql/9.3/main
>  5222 ?        Ss     0:10 postgres: startup process   recovering
> 0000000100000005000000A3
> 11161 pts/4    S+     0:00 grep --color=auto post
>


Does this WAL file exist "0000000100000005000000A3"?

Cheers,
Rob