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=20
wrote:

>
> Can I tell what version of the server I am running FOR SURE by using the
> command â€=98psql --versionâ€=99 ??
>
> 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=
,=20
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+wCc C/pr
Bql8Tvpl06xVbloVJvrhn90=3D
=3D87Nu
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

PostgreSQL Log Messages

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.



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

PostgreSQL Log Messages

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?


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: PostgreSQL Log Messages

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


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly