From: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: does wal archiving block the current client connection? |
Date: | 2006-05-19 15:53:51 |
Message-ID: | Pine.LNX.4.64.0605190852160.7012@discord.home.frostconsultingllc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
On Fri, 19 May 2006, Tom Lane wrote:
> Jeff Frost <jeff(at)frostconsultingllc(dot)com> writes:
>> Do you think the postmaster on 5432 is trying to archive the other
>> postmaster's WAL files somehow?
>
> Not as long as they aren't in the same data directory ;-). What Simon
> was wondering about was whether an archiver process had somehow been
> left over from a previous incarnation of the test postmaster. The thing
> to do is look through "ps auxww" (or local equivalent) and see if you
> see more than one thing calling itself an archiver process.
>
> (Whether or not this explains Jeff's problem, it definitely seems like
> a failure mode that we need to guard against. We go to great lengths
> to prevent a new postmaster from starting when there are still live
> backends from a previous postmaster, but I don't think that interlock
> is effective for the archiver.)
Well now, will you look at this:
postgres 20228 1 0 May17 ? 00:00:00 postgres: archiver process
postgres 20573 1 0 May17 ? 00:00:00 postgres: archiver process
postgres 23817 23810 0 May17 pts/11 00:00:00 postgres: archiver process
23810 is the running postmaster:
postgres 23810 1 0 May17 pts/11 00:03:01 /usr/local/pgsql-8.1.3/bin/postm
do you think that got left around the last time I did a pg_ctl restart?
I guess I can stop my re-run of the test after stopping the /var/lib/pgsql
postmaster.
--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2006-05-19 15:56:49 | Re: does wal archiving block the current client connection? |
Previous Message | Tom Lane | 2006-05-19 15:49:18 | Re: does wal archiving block the current client connection? |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2006-05-19 15:56:49 | Re: does wal archiving block the current client connection? |
Previous Message | Andreas Pflug | 2006-05-19 15:52:02 | Re: [OT] MySQL is bad, but THIS bad? |