Re: Recovery Assistance

From: Brian Mills <brian(at)trybooking(dot)com>
To: rob stone <floriparob(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Recovery Assistance
Date: 2017-01-28 21:55:46
Message-ID: CAK+gLv9C4L-xgQxnMrGfbCMmRwLZA+S9OMMA4OqnB=vcG3mFvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

<https://www.facebook.com/TryBooking/> <https://twitter.com/trybooking>
<https://www.linkedin.com/company/trybooking-com>

On 29 January 2017 at 08:18, rob stone <floriparob(at)gmail(dot)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(at)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-01-28 22:18:17 Re: Recovery Assistance
Previous Message rob stone 2017-01-28 21:18:10 Re: Recovery Assistance