[ale] perl/postgresql question

[Geoffrey Myers]

Jim Kinney wrote:
> More thought. 2 postmasters is ok as long as only is write capable.  If 
> you are pulling from read, filtering and pushing to write it should be 
> ok. Write attemp on read only side should error differently unless 
> attached user is db owner which always has write privs unless explicitly 
> blocked.

If both were connected to the same database, they were both capable of 
writing.

More things I don't know.

I was running multiple postmasters on different directories.  All we 
know is we had two postmasters running against a 'master' directory. 
Problem is, I had two different master directories with two different 
databases.  Still, we can not verify which directory the two different 
postmasters were running against as they both have been terminated 
since.  One with a regular pg_ctl stop, the other with a kill.  The 
thing is, something was wrong as the one that was killed would not stop 
with the pg_ctl command and there was no pid file for it.  Thus, we plan 
to reload the test databases from scratch and retest.

The upside is, maybe that's why my cleaning script was not working.
> 
> On Apr 5, 2011 8:34 AM, "Geoffrey Myers" <lists at serioustechnology.com 
> <mailto:lists at serioustechnology.com>> wrote:
>  > Jim Kinney wrote:
>  >>
>  >>
>  >> On Fri, Apr 1, 2011 at 8:59 AM, Geoffrey Myers
>  >> <lists at serioustechnology.com <mailto:lists at serioustechnology.com> 
> <mailto:lists at serioustechnology.com 
> <mailto:lists at serioustechnology.com>>> wrote:
>  >>
>  >>
>  >>
>  >> This is likely the approach I'll have to take, but searching for a hex
>  >> value in an ascii dump is questionable? Not sure what I'd be
>  >> searching for.
>  >>
>  >>
>  >> I don't think it's a real hex value. I think it's an ascii text string
>  >> that just happens to "look like" a hex value. I've seen that screw up
>  >> before but I can't recall the process. 10 years ago is pretty fuzzy...
>  >
>  > Quick update on this issue. It appears that the test database I was
>  > running against had to postmasters running against it. That would seem
>  > to guarantee database corruption, thus, I plan to reload the database
>  > from a known good production backup and revisit this issue.
>  >
>  >> --
>  >> --
>  >> James P. Kinney III
>  >> I would rather stumble along in freedom than walk effortlessly in 
> chains.
>  >>
>  >>
>  >>
>  >> ------------------------------------------------------------------------
>  >>
>  >> _______________________________________________
>  >> Ale mailing list
>  >> Ale at ale.org <mailto:Ale at ale.org>
>  >> http://mail.ale.org/mailman/listinfo/ale
>  >> See JOBS, ANNOUNCE and SCHOOLS lists at
>  >> http://mail.ale.org/mailman/listinfo
>  >
>  >
>  > --
>  > Until later, Geoffrey
>  >
>  > "I predict future happiness for America if they can prevent
>  > the government from wasting the labors of the people under
>  > the pretense of taking care of them."
>  > - Thomas Jefferson
>  > _______________________________________________
>  > Ale mailing list
>  > Ale at ale.org <mailto:Ale at ale.org>
>  > http://mail.ale.org/mailman/listinfo/ale
>  > See JOBS, ANNOUNCE and SCHOOLS lists at
>  > http://mail.ale.org/mailman/listinfo
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo


-- 
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson