Re: standby waiting for what? - Mailing list pgsql-admin

For some reason it is looking for 00000002000000000000001C.00512178.backup
file which is not the WAL file.

Are you sure that you made initial recovery properly?

Yauheni Labko (Eugene Lobko)
Junior System Administrator
Chapdelaine & Co.
(212)208-9150


On Wednesday 04 March 2009 03:14:51 pm Ray Stell wrote:
> On Wed, Mar 04, 2009 at 03:06:12PM -0500, Ray Stell wrote:
> > Testing pg_standby in 8.3.6.  I've gotten this standby into some sort of
> > bind.  It seems like it may be waiting for some WAL.   How can I tell
> > what it is waiting on?  I don't really know how this works, so I may
>
> say something silly.  The standby log says:
>
> ,2512,,2009-03-04 12:23:01.483 EST,49aeb8f5.9d0,1,2009-03-04 12:23:01
> EST,0, LOG:  database system was interrupted; last known up at 2009-03-04
> 12:20:29 EST ,2512,,2009-03-04 12:23:01.483 EST,49aeb8f5.9d0,2,2009-03-04
> 12:23:01 EST,0, LOG:  starting archive recovery ,2512,,2009-03-04
> 12:23:01.484 EST,49aeb8f5.9d0,3,2009-03-04 12:23:01 EST,0, LOG:
> restore_command = '/usr/local/pgsql/bin/pg_standby
> /data/pgsql/wals/alerts_oamp %f %p %r >>
> /home/postgresql/log/alerts_oamp/recovery.log'
>
>
> alerts_oamp]$ cat postmaster.pid
> 2510
> /data/pgsql/alerts_oamp
>   5498001   4194312
>
> alerts_oamp]$ ps -ef | grep 1005
> 1005       903   901  0 10:10 ?        00:00:00 sshd: postgresql@pts/0
> 1005       904   903  0 10:10 pts/0    00:00:00 -bash
> 1005      1016  1013  0 10:21 ?        00:00:00 sshd: postgresql@pts/1
> 1005      1017  1016  0 10:21 pts/1    00:00:00 -bash
> 1005      2510     1  0 12:23 pts/0    00:00:00
> /usr/local/pgsql836/bin/postgres -D /data/pgsql/alerts_oamp 1005      2511
> 2510  0 12:23 ?        00:00:00 postgres: logger process 1005      2512
> 2510  0 12:23 ?        00:00:00 postgres: startup process 1005      2520
> 2512  0 12:23 ?        00:00:00 sh -c /usr/local/pgsql/bin/pg_standby
> /data/pgsql/wals/alerts_oamp 00000002000000000000001C.00512178.backup
> pg_xlog/RECOVERYHISTORY 000000000000000000000000 >>
> /home/postgresql/log/alerts_oamp/recovery.log 1005      2521  2520  0 12:23
> ?        00:00:00 /usr/local/pgsql/bin/pg_standby
> /data/pgsql/wals/alerts_oamp 00000002000000000000001C.00512178.backup
> pg_xlog/RECOVERYHISTORY 000000000000000000000000 1005      2615  1017  0
> 12:27 pts/1    00:00:00 tail -f alerts_oamp-2009-03-04_122301.log 1005
> 3271   904  0 15:11 pts/0    00:00:00 ps -ef
> 1005      3272   904  0 15:11 pts/0    00:00:00 grep 1005
>
> alerts_oamp]$ ls -l /data/pgsql/wals/alerts_oamp/
> total 114828
> -rw------- 1 postgresql postgresql 16777216 Mar  4 11:28
> 00000002000000000000001A -rw------- 1 postgresql postgresql 16777216 Mar  4
> 11:29 00000002000000000000001B -rw------- 1 postgresql postgresql 16777216
> Mar  4 12:24 00000002000000000000001C -rw------- 1 postgresql postgresql
> 16777216 Mar  4 12:25 00000002000000000000001D -rw------- 1 postgresql
> postgresql 16777216 Mar  4 12:26 00000002000000000000001E -rw------- 1
> postgresql postgresql 16777216 Mar  4 14:45 00000002000000000000001F
> -rw------- 1 postgresql postgresql 16777216 Mar  4 14:45
> 000000020000000000000020
>
> any ideas what this guy is hurt by?