TODO question and claim

Started by Chris Humphriesalmost 24 years ago3 messages
#1Chris Humphries
chumphries@devis.com

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, i guess 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 interals viewpoint?
I am commited to coding for this project, and wanna get alot of stuff
done so i will be at a place where i can help out with replication
and all it's madness :)

Thanks,
Chris

#2Chris Humphries
chumphries@devis.com
In reply to: Chris Humphries (#1)
Re: TODO question and claim

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:

Show quoted text

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

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Chris Humphries (#1)
Re: TODO question and claim

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