Обсуждение: Re: Where to Get Version of PostgreSQL Installation

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



- --On Thursday, December 14, 2006 10:23:04 -0500 Lane Van Ingen
<lvaningen@esncc.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@hub.org                              MSN . scrappy@hub.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-----

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.

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?

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