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
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
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
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
"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
""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
> 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
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
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
