| Lists: | pgsql-admin |
|---|
| From: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org> |
|---|---|
| To: | Lane Van Ingen <lvaningen(at)esncc(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Where to Get Version of PostgreSQL Installation |
| Date: | 2006-12-14 23:53:55 |
| Message-ID: | 3C11E96D86D2C687416C2C7E@ganymede.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
- --On Thursday, December 14, 2006 10:23:04 -0500 Lane Van Ingen
<lvaningen(at)esncc(dot)com> wrote:
>
> Can I tell what version of the server I am running FOR SURE by using the
> command ‘psql --version’ ??
>
> I am running 8.0.? on Windows 2003.
try:
psql -c "select version();" template1
I believe 'psql --version' gives you version of psql, not the server itself,
while select version(); wil give you the server ...
- ----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . scrappy(at)hub(dot)org MSN . scrappy(at)hub(dot)org
Yahoo . yscrappy Skype: hub.org ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (FreeBSD)
iD8DBQFFgeQU4QvfyHIvDvMRAvMyAKCKaSTPUhPLZ/O+eABd2p8198ZK+wCcC/pr
Bql8Tvpl06xVbloVJvrhn90=
=87Nu
-----END PGP SIGNATURE-----
| From: | Lane Van Ingen <lvaningen(at)esncc(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | PostgreSQL Log Messages |
| Date: | 2006-12-15 18:48:12 |
| Message-ID: | TWMAILDBdg3KjxpAShW00000043@twmail.ESNCC.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
We are running on Windows 2003, version 8.0.4.
Database is up and running, but we are noticing (usually, on a twice a week
basis) the following error message:
Could not receive data from client: No connection could be made because
client machine actively refused it.
| From: | Lane Van Ingen <lvaningen(at)esncc(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | PostgreSQL Log Messages |
| Date: | 2006-12-15 18:50:52 |
| Message-ID: | TWMAILvaWwIXLEivYi800000044@twmail.ESNCC.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
We are running on Windows 2003, version 8.0.4.
Database is up and running, but we are noticing (usually, on a twice a week
basis) the following error message:
Could not receive data from client: No connection could be made because
client machine actively refused it.
Can anyone tell me what might be causing this?
| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Lane Van Ingen <lvaningen(at)esncc(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL Log Messages |
| Date: | 2006-12-15 19:03:46 |
| Message-ID: | 1166209426.3243.203.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
On Fri, 2006-12-15 at 12:50, Lane Van Ingen wrote:
> We are running on Windows 2003, version 8.0.4.
>
> Database is up and running, but we are noticing (usually, on a twice a week
> basis) the following error message:
>
> Could not receive data from client: No connection could be made because
> client machine actively refused it.
>
> Can anyone tell me what might be causing this?
More than likely either a port scanner or some program that checks
postgresql for life is simply hitting the port and then dropping the
connection when it sees the answer. For instance, if I telnet to my
pgsql server / port, I see this for a disconnect:
LOG: incomplete startup packet
and this for typing in gobbledly gook:
LOG: invalid length of startup packet