Hi,
I’m using PSQL-7.2.4 on Solaries.
Consider the following:
I opened 5 connections to
the Postgres
Server and did not use those
connections at
all.i.e. I did not perform any activity
on the any databases.
What happens to
those connections?
Are they still
Active after
long duration? Or
is there any way to see what statements/queries are currently being passed
on to the database?
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
> is there any way to see what statements/queries are currently being passed
> on to the database?
Yes - I haven't got around to installing it yet but 'pgmonitor' over
at http://gborg.postgresql.org/project/pgmonitor/projdisplay.php sounds
like what your after.
Here's the overview:
"This is a Tcl
""Ramil Sagum"" <[EMAIL PROTECTED]> wrote:
>
>
> is there any way to see what statements/queries are currently being passed
> on to the database?
select * from pg_stat_activity;
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 1: subscribe
"Anagha Joshi" <[EMAIL PROTECTED]> writes:
> Consider the following:
> I opened 5 connections to the Postgres Server and did not use those
> connections at all.i.e. I did not perform any activity on the any
> databases.
> What happens to those connections? Are they still Active after long
> duratio
At 02:21 AM 8/16/2003 , Gregory S. Williamson wrote:
>I had a similar problem recently and in the end it seems to have been me
>not restarting the postmaster; changes to the pg_hba.conf file weren't
>seen until then (I am sure this is documented but I managed to overlook it;
The file was read on
My company is currently developing an integrated database solution. Part
of this is linking ACT! To an access database. Part of our software takes the
current contact from ACT! and adds their details to the access database using
ODBC. This is not a problem on two of our PCs but on the other
I think the connections are kept alive all
long.
""Anagha Joshi"" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]...
Hi,
I’m using PSQL-7.2.4 on
Solaries.
Consider
the following:
I opened 5
connections
to the
Postgres Server and did
not use
thos
Where does postgres come in to all this?
On Mon, 18 Aug 2003, Jean Michel Gaudel wrote:
> My company is currently developing an integrated database solution.
> Part of this is linking ACT! To an access database. Part of our
> software takes the current contact from ACT! and adds their details to
