pg.ddx.io pgsql-admin@postgresql.org mailing list archive help / color / mirror / Atom feed From: Ray Stell <stellr@cns.vt.edu>
To: pgsql-admin@postgresql.org
Subject: Re: standby waiting for what?
Date: Wed, 4 Mar 2009 15:14:51 -0500
Message-ID: <20090304201451.GB25611@cns.vt.edu> (raw )
In-Reply-To: <20090304200612.GA25611@cns.vt.edu >
References: <20090304200612.GA25611@cns.vt.edu >
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: <20090304201451.GB25611@cns.vt.edu>
Permalink: ../20090304201451.GB25611@cns.vt.edu/
Also on: postgresql.org/message-id/20090304201451.GB25611@cns.vt.edu
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: stellr@cns.vt.edu
Subject: Re: standby waiting for what?
In-Reply-To: <20090304201451.GB25611@cns.vt.edu>
* 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