pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFwd: Postgresql
6+ messages / 5 participants
[nested] [flat]
* Fwd: Postgresql
@ 2003-02-03 13:51 Gary Stainburn <gary.stainburn@ringways.co.uk>
0 siblings, 1 reply; 6+ messages in thread
From: Gary Stainburn @ 2003-02-03 13:51 UTC (permalink / raw)
To: pgsql-admin
Hi folks,
This was posted to one of the redhat lists and it got me thinking.
I would imagine that there is some sort of limit otherwise stale connections
could be left hanging around forever. However, PHP supports persistant
connections where it can go days without anyone accessing a page.
So what is the answer to the question below?
---------- Forwarded Message ----------
Subject: Postgresql
Date: Fri, 31 Jan 2003 08:10:53 -0600
From: "Delao, Darryl W" <ddelao@ou.edu>
To: "'redhat-list@redhat.com'" <redhat-list@redhat.com>
Anyone know if postgres has a connections limit by default? I see a
connections limit in my conf file but it is commented out..Just curious what
the default limit is, if any.
Darryl
--
redhat-list mailing list
unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list
-------------------------------------------------------
--
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fwd: Postgresql
@ 2003-02-03 15:28 Gary Stainburn <gary.stainburn@ringways.co.uk>
parent: Gary Stainburn <gary.stainburn@ringways.co.uk>
0 siblings, 1 reply; 6+ messages in thread
From: Gary Stainburn @ 2003-02-03 15:28 UTC (permalink / raw)
To: Egon Reetz <reetz@usco.de>; +Cc: pgsql-admin
On Monday 03 February 2003 2:39 pm, you wrote:
> > Anyone know if postgres has a connections limit by default? I see a
> > connections limit in my conf file but it is commented out..Just curious
> > what the default limit is, if any.
>
> 32, compile with --with-maxbackends=N, where N is your max. connection
> number.
>
> Egon
Thanks for that Egon.
I didn't read the OP properly. I thought it was asking how Postgresql handled
STALE connections.
The specific situation I have in mind is that inside my firewall's DMZ I have
an Apache server running PHP. This PHP opens a persistant connection through
the firewall to a postgresql service in another DMZ. If I reboot the
firewall, the PHP connection is lost and to get my PHP working again I have
to restart Apache (If anyone can suggest how I can either get round of
automate this I'd appreciate it).
How does Postgresql handle this? I would hope that it would notice the loss
of the IP connection and close the link gracefully, and not just leave the
connectino dangling.
Can anyone confirm this?
--
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fwd: Postgresql
@ 2003-02-03 15:50 Tom Lane <tgl@sss.pgh.pa.us>
parent: Gary Stainburn <gary.stainburn@ringways.co.uk>
0 siblings, 0 replies; 6+ messages in thread
From: Tom Lane @ 2003-02-03 15:50 UTC (permalink / raw)
To: Gary Stainburn <gary.stainburn@ringways.co.uk>; +Cc: Egon Reetz <reetz@usco.de>; pgsql-admin
Gary Stainburn <gary.stainburn@ringways.co.uk> writes:
> How does Postgresql handle this? I would hope that it would notice the loss
> of the IP connection and close the link gracefully, and not just leave the
> connectino dangling.
The backend runs the connection with TCP_KEEPALIVE set. The kernel
should recognize the loss of connectivity after awhile ("awhile" means
an hour or more if your kernel does this in an RFC-compliant fashion)
and inform the backend, which will roll back any open transaction and
then shut down.
If connectivity was lost while active data transfer was going on,
it will probably only take a few minutes for the kernel to declare
connection loss. But if you were sitting idle, nothing will happen
until the kernel issues a KEEPALIVE probe, which it shouldn't do very
often.
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Postgresql
@ 2004-12-20 09:57 007117 <007117@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: 007117 @ 2004-12-20 09:57 UTC (permalink / raw)
To: pgsql-admin
Respected Sir.
This is srinivas.
I have more enhusiasm to work with Postgresql. Since i have good
exposure on Rdbms packages such as Oracle, Sql Server and so on.
Now my interest is turned to Postgresql.I have created some tables with
constraints. Now i have startd write functions in plpgsql and
successfully created it.
But i have a few doubts while using the Refcursor, Which are
1. Not able to add string varaible(contains the Sql query) to the Refcursor.
Open Refcursor for SqlString;
2. I want to print the String variable which contains the Sql Query To
ensure the
value assigned to the string.
Please revert to me with possible solutions for the above.
I would appreciate if you could expediate your reply.
Kindly suggested me the useful books or URL.
Thank you
Best Regards
Srinivas
^ permalink raw reply [nested|flat] 6+ messages in thread
* PostgreSQL
@ 2010-12-30 07:55 nextage Tech <natseo.tech@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: nextage Tech @ 2010-12-30 07:55 UTC (permalink / raw)
To: pgsql-admin
How good are certmagic.com practice exams for PostgreSQL
exam? My friends told me they are pretty good and he has passed many
exams with their material. Let me know guys!
^ permalink raw reply [nested|flat] 6+ messages in thread
* PostgreSQL
@ 2014-12-17 16:22 Shayra Sharma <Shayra.Sharma@Mastech.com>
0 siblings, 0 replies; 6+ messages in thread
From: Shayra Sharma @ 2014-12-17 16:22 UTC (permalink / raw)
To: pgsql-admin
Hi,
Please post below job.
This is with one of our direct client. If anyone is interested and need more details about below project we have can contact me back at 877-884-8834 Extns:2193 or email me at shayra.sharma@mastech.com<mailto:shayra.sharma@mastech.com>.
Also if you can refer me anyone for the role that will be really a great help.
Job Title : PostgreSQL
Location : Denver, CO
Duration : 1 Year
SysAdmin / PostgreSQL Resources Staffing Request
Description: Assist the client in configuration, administering, and maintaining multiple development environments across their customer care portal footprint. This resource will be responsible for CentOS Linux and server configuration; using Puppet Labs; and providing PostgreSQL High Availability environment maintenance and support.
Time Frame: Jan 2015 - Dec 2015
Key Skills / Experience
* Introducing new computer systems into current setups for optimum IT functions
* Troubleshooting IT systems when there is an issue reported by users
* Performing a check to make sure all systems are working fine and up to date
* Carrying out data backups and administration
* Installing and maintaining software updates periodically
* Linux System Administration
o CentOS
o Server Visualization (VMware)
o Apache Web Server
o Puppet Configuration
* PostgreSQL data base administration and maintenance
o PostgreSQL data base administration
o PostgreSQL HA environment maintenance
Educational Qualifications
* A bachelor's degree in computer science
* Certificate courses in software, hardware and networking
Please see latest jobs on "Mastech Jobs" on Linkedin
http://www.linkedin.com/groups/Mastech-Jobs-4995749/about
Regards
Shayra Sharma
Recruiter
[Description: Description: Mastech logo_small4]
Mastech, Inc., 1305 Cherrington Parkway
Building 210, Suite 400 Moon Township, PA 15108
877.884.8834 Extension 2193 ; Mail: shayra.sharma@mastech.com<mailto:shayra.sharma@mastech.com> / www.mastech.com<https://mail.apptix.net/owa/redir.aspx?C=94eeceeabc8d4e3c9b643cd2ad806b66&URL=http%3a%2f%2fwww.m...;
About Mastech (NYSE MKT: MHH): Mastech is a trusted talent partner for IT staffing, matching IT professionals with new opportunities and companies with the talent they need to grow.
Please consider the environment and do not print this email unless absolutely necessary.
Attachments:
image002.png (image/png, 7.1K) download
view image
end of thread, other threads:[~2014-12-17 16:22 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-03 13:51 Fwd: Postgresql Gary Stainburn <gary.stainburn@ringways.co.uk>
2003-02-03 15:28 ` Gary Stainburn <gary.stainburn@ringways.co.uk>
2003-02-03 15:50 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-12-20 09:57 Postgresql 007117 <007117@gmail.com>
2010-12-30 07:55 PostgreSQL nextage Tech <natseo.tech@gmail.com>
2014-12-17 16:22 PostgreSQL Shayra Sharma <Shayra.Sharma@Mastech.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox