Re: [GENERAL] Recovery Assistance
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
Level 1 | 600 Chapel Street | South Yarra| VIC | 3141 | Australia
On 29 January 2017 at 08:18, rob stone <floriparob@gmail.com> 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
В списке pgsql-general по дате отправления: