pg.ddx.io pgsql-admin@postgresql.org mailing list archive help / color / mirror / Atom feed From: Yauheni Labko <yyl@chappy.com>
To: pgsql-admin@postgresql.org
Subject: Re: standby waiting for what?
Date: Wed, 4 Mar 2009 15:41:06 -0500
Message-ID: <200903041541.06149.yyl@chappy.com> (raw )
In-Reply-To: <20090304201451.GB25611@cns.vt.edu >
References: <20090304200612.GA25611@cns.vt.edu >
<20090304201451.GB25611@cns.vt.edu >
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?
view thread (14+ messages) latest in thread
Message-ID: <200903041541.06149.yyl@chappy.com>
Permalink: ../200903041541.06149.yyl@chappy.com/
Also on: postgresql.org/message-id/200903041541.06149.yyl@chappy.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: yyl@chappy.com
Subject: Re: standby waiting for what?
In-Reply-To: <200903041541.06149.yyl@chappy.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox