Password for postgresql superuser?

Is there any security risk in the postgresql superuser having a password?

I installed a Linux distro recently and had it install Postgresql. It automatically set up the postgres account; the account was set up with no password.

I could of course create a password, but it's not clear to me that's a good thing from a security standpoint.
>From pgsql-general-owner(at)postgresql(dot)org Thu Jun 8 11:57:55 2006
X-Original-To: pgsql-general-postgresql(dot)org(at)postgresql(dot)org
Received: from localhost (mx1.hub.org [200.46.208.251])
by postgresql.org (Postfix) with ESMTP id C44869FA5C8
for <pgsql-general-postgresql(dot)org(at)postgresql(dot)org>; Thu, 8 Jun 2006 11:57:54 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
with ESMTP id 63882-05 for <pgsql-general-postgresql(dot)org(at)postgresql(dot)org>;
Thu, 8 Jun 2006 11:57:45 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191])
by postgresql.org (Postfix) with ESMTP id 2A0A89F9EF3
for <pgsql-general(at)postgresql(dot)org>; Thu, 8 Jun 2006 11:57:44 -0300 (ADT)
Received: by nf-out-0910.google.com with SMTP id l37so368341nfc
for <pgsql-general(at)postgresql(dot)org>; Thu, 08 Jun 2006 07:57:42 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
s=beta; d=gmail.com;
h=received:message-id:date:from:to:subject:mime-version:content-type;
b=RZ1De92wne3Q4HJaDkJgml1gZ7NtQMWKYujG1mKUJ4N+ZyoyLshgf1pKAkyJ2eB8aEwD2+pO8LLwkQX9fnHx+prlz0ibUhUT3LFTuMI60HquXF96BNdNgePVd35EZVx4OAM0VKvYx/0MAjco3rfcjP6Wu28mJq8gIh30IxVZGs8=
Received: by 10.48.238.3 with SMTP id l3mr1525650nfh;
Thu, 08 Jun 2006 07:57:42 -0700 (PDT)
Received: by 10.48.231.12 with HTTP; Thu, 8 Jun 2006 07:57:42 -0700 (PDT)
Message-ID: <7be3f35d0606080757h3e5db37fqe3c1dd20663d4e7d(at)mail(dot)gmail(dot)com>
Date: Thu, 8 Jun 2006 16:57:42 +0200
From: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Out of Memory Error on Postgresql 8.1.3. on win32
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_Part_258_23266422.1149778662809"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/268
X-Sequence-Number: 96640

------=_Part_258_23266422.1149778662809
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello,

today postgresql 8.1.3 on win32 died:

2006-06-08 16:33:09 LOG: autovacuum: processing database "ibox"
TopMemoryContext: 84400 total in 7 blocks; 12696 free (22 chunks); 71704
used
Operator class cache: 8192 total in 1 blocks; 4936 free (0 chunks); 3256
used
TopTransactionContext: 8192 total in 1 blocks; 7552 free (10 chunks); 640
used
MessageContext: 8192 total in 1 blocks; 7368 free (1 chunks); 824 used
smgr relation table: 8192 total in 1 blocks; 3904 free (0 chunks); 4288 use=
d
Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used
PortalMemory: 8192 total in 1 blocks; 8040 free (0 chunks); 152 used
PortalHeapMemory: 15360 total in 4 blocks; 15160 free (543 chunks); 200 use=
d
Vacuum: 8192 total in 1 blocks; 6600 free (0 chunks); 1592 used
Relcache by OID: 8192 total in 1 blocks; 3896 free (0 chunks); 4296 used
CacheMemoryContext: 253952 total in 5 blocks; 13264 free (2 chunks); 240688
used
pg_index_indrelid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632
used
pg_type_typname_nsp_index: 1024 total in 1 blocks; 328 free (0 chunks); 696
used
pg_type_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 328 free (0
chunks); 696 used
pg_statistic_relid_att_index: 1024 total in 1 blocks; 328 free (0 chunks);
696 used
pg_auth_members_member_role_index: 1024 total in 1 blocks; 328 free (0
chunks); 696 used
pg_auth_members_role_member_index: 1024 total in 1 blocks; 328 free (0
chunks); 696 used
pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 328 free (0 chunks);
696 used
pg_proc_proname_args_nsp_index: 1024 total in 1 blocks; 256 free (0 chunks)=
;
768 used
pg_proc_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
pg_operator_oprname_l_r_n_index: 1024 total in 1 blocks; 192 free (0
chunks); 832 used
pg_operator_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 use=
d
pg_opclass_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
pg_opclass_am_name_nsp_index: 1024 total in 1 blocks; 256 free (0 chunks);
768 used
pg_namespace_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632
used
pg_namespace_nspname_index: 1024 total in 1 blocks; 392 free (0 chunks); 63=
2
used
pg_language_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 use=
d
pg_language_name_index: 1024 total in 1 blocks; 392 free (0 chunks); 632
used
pg_inherits_relid_seqno_index: 1024 total in 1 blocks; 328 free (0 chunks);
696 used
pg_index_indexrelid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632
used
pg_authid_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
pg_authid_rolname_index: 1024 total in 1 blocks; 392 free (0 chunks); 632
used
pg_database_datname_index: 1024 total in 1 blocks; 392 free (0 chunks); 632
used
pg_conversion_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632
used
pg_conversion_name_nsp_index: 1024 total in 1 blocks; 328 free (0 chunks);
696 used
pg_conversion_default_index: 1024 total in 1 blocks; 192 free (0 chunks);
832 used
pg_class_relname_nsp_index: 1024 total in 1 blocks; 328 free (0 chunks); 69=
6
used
pg_class_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 used
pg_cast_source_target_index: 1024 total in 1 blocks; 328 free (0 chunks);
696 used
pg_attribute_relid_attnum_index: 1024 total in 1 blocks; 328 free (0
chunks); 696 used
pg_attribute_relid_attnam_index: 1024 total in 1 blocks; 328 free (0
chunks); 696 used
pg_amproc_opc_proc_index: 1024 total in 1 blocks; 256 free (0 chunks); 768
used
pg_amop_opr_opc_index: 1024 total in 1 blocks; 328 free (0 chunks); 696 use=
d
pg_amop_opc_strat_index: 1024 total in 1 blocks; 256 free (0 chunks); 768
used
pg_aggregate_fnoid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632
used
MdSmgr: 8192 total in 1 blocks; 8032 free (0 chunks); 160 used
LockTable (locallock hash): 8192 total in 1 blocks; 3912 free (0 chunks);
4280 used
Timezones: 48408 total in 2 blocks; 5968 free (0 chunks); 42440 used
ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
2006-06-08 16:33:12 ERROR: out of memory
2006-06-08 16:33:12 DETAIL: Failed on request of size 16777212.

what scares me: up to the error there is allways "free", "free", "free"...

what is wrong?

Harald

--=20
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstra=DFe 202b
70197 Stuttgart
0173/9409607
-
on different matter:
did you ever dream of visiting CERN? The place where the antimatter for
exploding Vatican is created? To eat in cantinas
with the worlds highest propability to stand in queue with future or past
Nobel Prize Winners? To talk about Web 2.5 at the place where Web 0.1 up to
Web 1.0 were developed? register at www.europython.org!

------=_Part_258_23266422.1149778662809
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello,<br><br>today postgresql 8.1.3 on win32 died:<br><br>2006-06-08 16:33=
:09 LOG:&nbsp; autovacuum: processing database &quot;ibox&quot;<br>TopMemor=
yContext: 84400 total in 7 blocks; 12696 free (22 chunks); 71704 used<br>Op=
erator class cache: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used
<br>TopTransactionContext: 8192 total in 1 blocks; 7552 free (10 chunks); 6=
40 used<br>MessageContext: 8192 total in 1 blocks; 7368 free (1 chunks); 82=
4 used<br>smgr relation table: 8192 total in 1 blocks; 3904 free (0 chunks)=
; 4288 used
<br>Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used<br=
>PortalMemory: 8192 total in 1 blocks; 8040 free (0 chunks); 152 used<br>Po=
rtalHeapMemory: 15360 total in 4 blocks; 15160 free (543 chunks); 200 used
<br>Vacuum: 8192 total in 1 blocks; 6600 free (0 chunks); 1592 used<br>Relc=
ache by OID: 8192 total in 1 blocks; 3896 free (0 chunks); 4296 used<br>Cac=
heMemoryContext: 253952 total in 5 blocks; 13264 free (2 chunks); 240688 us=
ed
<br>pg_index_indrelid_index: 1024 total in 1 blocks; 392 free (0 chunks); 6=
32 used<br>pg_type_typname_nsp_index: 1024 total in 1 blocks; 328 free (0 c=
hunks); 696 used<br>pg_type_oid_index: 1024 total in 1 blocks; 392 free (0 =
chunks); 632 used
<br>pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 328 free (0 ch=
unks); 696 used<br>pg_statistic_relid_att_index: 1024 total in 1 blocks; 32=
8 free (0 chunks); 696 used<br>pg_auth_members_member_role_index: 1024 tota=
l in 1 blocks; 328 free (0 chunks); 696 used
<br>pg_auth_members_role_member_index: 1024 total in 1 blocks; 328 free (0 =
chunks); 696 used<br>pg_rewrite_rel_rulename_index: 1024 total in 1 blocks;=
328 free (0 chunks); 696 used<br>pg_proc_proname_args_nsp_index: 1024 tota=
l in 1 blocks; 256 free (0 chunks); 768 used
<br>pg_proc_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 use=
d<br>pg_operator_oprname_l_r_n_index: 1024 total in 1 blocks; 192 free (0 c=
hunks); 832 used<br>pg_operator_oid_index: 1024 total in 1 blocks; 392 free=
(0 chunks); 632 used
<br>pg_opclass_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 =
used<br>pg_opclass_am_name_nsp_index: 1024 total in 1 blocks; 256 free (0 c=
hunks); 768 used<br>pg_namespace_oid_index: 1024 total in 1 blocks; 392 fre=
e (0 chunks); 632 used
<br>pg_namespace_nspname_index: 1024 total in 1 blocks; 392 free (0 chunks)=
; 632 used<br>pg_language_oid_index: 1024 total in 1 blocks; 392 free (0 ch=
unks); 632 used<br>pg_language_name_index: 1024 total in 1 blocks; 392 free=
(0 chunks); 632 used
<br>pg_inherits_relid_seqno_index: 1024 total in 1 blocks; 328 free (0 chun=
ks); 696 used<br>pg_index_indexrelid_index: 1024 total in 1 blocks; 392 fre=
e (0 chunks); 632 used<br>pg_authid_oid_index: 1024 total in 1 blocks; 392 =
free (0 chunks); 632 used
<br>pg_authid_rolname_index: 1024 total in 1 blocks; 392 free (0 chunks); 6=
32 used<br>pg_database_datname_index: 1024 total in 1 blocks; 392 free (0 c=
hunks); 632 used<br>pg_conversion_oid_index: 1024 total in 1 blocks; 392 fr=
ee (0 chunks); 632 used
<br>pg_conversion_name_nsp_index: 1024 total in 1 blocks; 328 free (0 chunk=
s); 696 used<br>pg_conversion_default_index: 1024 total in 1 blocks; 192 fr=
ee (0 chunks); 832 used<br>pg_class_relname_nsp_index: 1024 total in 1 bloc=
ks; 328 free (0 chunks); 696 used
<br>pg_class_oid_index: 1024 total in 1 blocks; 392 free (0 chunks); 632 us=
ed<br>pg_cast_source_target_index: 1024 total in 1 blocks; 328 free (0 chun=
ks); 696 used<br>pg_attribute_relid_attnum_index: 1024 total in 1 blocks; 3=
28 free (0 chunks); 696 used
<br>pg_attribute_relid_attnam_index: 1024 total in 1 blocks; 328 free (0 ch=
unks); 696 used<br>pg_amproc_opc_proc_index: 1024 total in 1 blocks; 256 fr=
ee (0 chunks); 768 used<br>pg_amop_opr_opc_index: 1024 total in 1 blocks; 3=
28 free (0 chunks); 696 used
<br>pg_amop_opc_strat_index: 1024 total in 1 blocks; 256 free (0 chunks); 7=
68 used<br>pg_aggregate_fnoid_index: 1024 total in 1 blocks; 392 free (0 ch=
unks); 632 used<br>MdSmgr: 8192 total in 1 blocks; 8032 free (0 chunks); 16=
0 used
<br>LockTable (locallock hash): 8192 total in 1 blocks; 3912 free (0 chunks=
); 4280 used<br>Timezones: 48408 total in 2 blocks; 5968 free (0 chunks); 4=
2440 used<br>ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16=
used
<br>2006-06-08 16:33:12 ERROR:&nbsp; out of memory<br>2006-06-08 16:33:12 D=
ETAIL:&nbsp; Failed on request of size 16777212.<br><br>what scares me: up =
to the error there is allways &quot;free&quot;, &quot;free&quot;, &quot;fre=
e&quot;...
<br><br>what is wrong?<br><br>Harald<br><br><br clear=3D"all"><br>-- <br>GH=
UM Harald Massa<br>persuadere et programmare<br>Harald Armin Massa<br>Reins=
burgstra=DFe 202b<br>70197 Stuttgart<br>0173/9409607<br>-<br>on different m=
atter:=20
<br>did you ever dream of visiting CERN? The place where the antimatter for=
exploding Vatican is created? To eat in cantinas<br>with the worlds highes=
t propability to stand in queue with future or past Nobel Prize Winners? To=
talk about Web=20
2.5 at the place where Web 0.1 up to Web 1.0 were developed? register at <a=
href=3D"http://www.europython.org">www.europython.org</a>!

------=_Part_258_23266422.1149778662809--