Postgres Pro
Downloads
Home   >   mailing lists

Thread: TODO question and claim

TODO question and claim

From
Chris Humphries
Date:
Hello All,    For those on IRC, i am drauku/slipjack/chrish.
    First i would like to start off by coding a feature that DarcyB, nick from IRC, suggested as a starting point for
me.A max connections settable limit. Since Bruce said that in 7.2 the pg_hda.conf gets reloaded into cache on a SIGHUP,
iguess i could stick it in there and keep it backwards compatable? thoughts?
 

    Second, on this TODO item:      * Point-in-time data recovery using backup and write-ahead log
    This is like journaling but with a database? Can someone please give me info on this? Thanks.
    Also, can anyone point out any "newbie" items that i could do to get started learning this api and system from the
interalsviewpoint? I am commited to coding for this project, and wanna get alot of stuff done so i will be at a place
wherei can help out with replication and all it's madness :)
 

Thanks,
Chris

Re: TODO question and claim

From
Tom Lane
Date:
Chris Humphries <chumphries@devis.com> writes:
>      First i would like to start off by coding a feature that DarcyB,
>   nick from IRC, suggested as a starting point for me. A max connections
>   settable limit.

Uh, how is that different from MaxBackends?
        regards, tom lane

Re: TODO question and claim

From
Chris Humphries
Date:
sorry, i misunderstood what he said. since maxbackends is global,
would like something that isnt global, like relative to a db. here
is his messages:

--snip--

<DarcyB> maxbackends is GLOBAL, not specific to a DB and/or 
Authentication methood
<DarcyB> For example if you have a postgresinstall, with a maxbackends of 64
<chrish> authentication method?
<DarcyB> but that postmaster has 3 DB's in it.. (accounting, crm, demo)
<DarcyB> and you want to allow 32 connections to accounting 24 to crm 
and 8 to demo
<DarcyB> ....
<chrish> right, makes sence
<DarcyB> as per auth methood, I want to allow only 2 "remote" 
connections via SSL, and 16 via straight unix domain  and 14 via 
standatd TCP

--snip--

sorry for the communication error.

-chris


Tom Lane wrote:

> Chris Humphries <chumphries@devis.com> writes:
> 
>>     First i would like to start off by coding a feature that DarcyB,
>>  nick from IRC, suggested as a starting point for me. A max connections
>>  settable limit.
>>
> 
> Uh, how is that different from MaxBackends?
> 
>             regards, tom lane
>