Hi, People.
I have two questions:
1) How many concurrent connections to the same database can I make from
one process (which incidentally later fork()s)?
2) What's the most sure and/or fastest way to do backups?
L L Richi Plana 8^) ,-,-. ,-,-. ,-,-. ,-,-. ,-
ded shared object.
I tried PQreset()ing the connections after forking and then I'd try a
begin but I'd get the ff.:
NOTICE: BeginTransactionBlock and not in default state
What does that mean?
So, what's the deal with fork()ing and connectio
so far.
If anyone can give a better suggestion, I'm all ears. Also, if anyone
wants the code when it's done, try asking. ;^)
L L Richi Plana 8^) ,-,-. ,-,-. ,-,-. ,-,-. ,-
LL LL Systems Administrator / / \ \ / / \ \ / / \ \ / / \ \ / /
L Mosaic C
low it to execute one process
at a time via locking, that would probably slow the other processes down.
(ie. Should the waiting process block? If so, when will it try again? Are
the overheads to establishin a connection really that big?)
L L Richi Plana 8^)
Hi,
Does PostgreSQL 6.4.2 have a build in Unix crypt() function? Or has
someone implemented it that you'd like to share?
L L Richi Plana 8^) ,-,-. ,-,-. ,-,-. ,-,-. ,-
LL LL Systems Administrator / / \ \ / / \ \ / / \ \ / / \ \ / /
L Mosaic Communica
