From davide.negri@zeropiu.it Fri Oct  22 07:03:51 2004
X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id B745D32AC2B;
	Fri, 22 Oct 2004 08:03:51 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 14164-02; Fri, 22 Oct 2004 07:03:37 +0000 (GMT)
Received: from piragna.zeropiu.it (piragna.zeropiu.it [62.152.101.33])
	by svr1.postgresql.org (Postfix) with ESMTP id 10D7732A06E;
	Fri, 22 Oct 2004 08:03:40 +0100 (BST)
Received: from davide (bigw.zeropiu.it [62.152.101.30])
	by piragna.zeropiu.it (Zeropiu) with ESMTP
	id 534EE36CF1; Fri, 22 Oct 2004 09:03:42 +0200 (CEST)
From: "Davide Negri" <davide.negri@zeropiu.it>
To: <pgsql-bugs@postgresql.org>
Subject: Question on the 8.0Beta Version
Date: Fri, 22 Oct 2004 08:59:56 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0017_01C4B815.80E67F30"
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Thread-Index: AcS4BLzaqu32DdwwReyaVD8FHnOX1Q==
Message-Id: <20041022070342.534EE36CF1@piragna.zeropiu.it>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=HTML_50_60,
	HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200410/219
X-Sequence-Number: 9682

This is a multi-part message in MIME format.

------=_NextPart_000_0017_01C4B815.80E67F30
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit

Hello, 

i have installed postgres 8.0 beta3 as a program on my pc on windows xp. I
have read on the installation note file that postgres server will not run
with administrative permissions. I have read on your forum that this
happened because i have installed the beta version: is it true that this
happen only with the beta version? When will you plan to release the
production version? 

 

Thanks You

 

Negri Davide


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.779 / Virus Database: 526 - Release Date: 19/10/2004
 

------=_NextPart_000_0017_01C4B815.80E67F30
Content-Type: text/html;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc=
hemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3DWindows-1=
252">


<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.StileMessaggioDiPostaElettronica17
	{mso-style-type:personal-compose;
	font-family:Arial;
	color:windowtext;}
@page Section1
	{size:595.3pt 841.9pt;
	margin:70.85pt 2.0cm 2.0cm 2.0cm;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DIT link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB style=
=3D'font-size:
10.0pt;font-family:Arial'>Hello, <o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB style=
=3D'font-size:
10.0pt;font-family:Arial'>i have installed postgres 8.0 beta3 as a program =
on
my pc on windows xp. I have read on the installation note file that postgres
server will not run with administrative permissions. I have read on your fo=
rum
that this happened because i have installed the beta version: is it true th=
at
this happen only with the beta version? When will you plan to release the
production version? <o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB style=
=3D'font-size:
10.0pt;font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB style=
=3D'font-size:
10.0pt;font-family:Arial'>Thanks You<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB style=
=3D'font-size:
10.0pt;font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'>Negri Davide<o:p></o:p></span></font></p>

</div>

</body>

</html>
<BR>

<P><FONT SIZE=3D2>---<BR>
Outgoing mail is certified Virus Free.<BR>
Checked by AVG anti-virus system (http://www.grisoft.com).<BR>
Version: 6.0.779 / Virus Database: 526 - Release Date: 19/10/2004<BR>
</FONT> </P>

------=_NextPart_000_0017_01C4B815.80E67F30--




From mendola@bigfoot.com Sat Oct  23 22:21:11 2004
X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id CAFDE3A2B19
	for <pgsql-bugs-postgresql.org@localhost.postgresql.org>;
	Sat, 23 Oct 2004 23:21:11 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 63087-01
	for <pgsql-bugs-postgresql.org@localhost.postgresql.org>;
	Sat, 23 Oct 2004 22:20:50 +0000 (GMT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by svr1.postgresql.org (Postfix) with ESMTP id 97CD83A2B12
	for <pgsql-bugs@postgresql.org>; Sat, 23 Oct 2004 23:21:09 +0100 (BST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.12.9/8.12.9) with ESMTP id i9NMKnJ7063283
	for <pgsql-bugs@postgresql.org>; Sat, 23 Oct 2004 22:20:49 GMT
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.12.9/8.12.9/Submit) id i9NM83Lc059760
	for pgsql-bugs@postgresql.org; Sat, 23 Oct 2004 22:08:03 GMT
From: Gaetano Mendola <mendola@bigfoot.com>
X-Newsgroups: comp.databases.postgresql.bugs
Subject: Re: Question on the 8.0Beta Version
Date: Sun, 24 Oct 2004 00:08:22 +0200
Organization: PYRENET Midi-pyrenees Provider
Lines: 20
Message-ID: <417AD656.8090608@bigfoot.com>
References: <20041022070342.534EE36CF1@piragna.zeropiu.it>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@pyrenet.fr
To: Davide Negri <davide.negri@zeropiu.it>
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
X-Accept-Language: en-us, en
In-Reply-To: <20041022070342.534EE36CF1@piragna.zeropiu.it>
X-Enigmail-Version: 0.86.1.0
X-Enigmail-Supports: pgp-inline, pgp-mime
To: pgsql-bugs@postgresql.org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200410/221
X-Sequence-Number: 9684

Davide Negri wrote:
> Hello,
> 
> i have installed postgres 8.0 beta3 as a program on my pc on windows xp. 
> I have read on the installation note file that postgres server will not 
> run with administrative permissions. I have read on your forum that this 
> happened because i have installed the beta version: is it true that this 
> happen only with the beta version? 

Don't you think that is evil run a service like a database with administrator
permissions ? I think this will remain true also in the final release.

> When will you plan to release the production version?

When is ready, fortunatelly postgresql is not a "time to market" slave.


Regards
Gaetano Mendola




From smarlowe@qwest.net Sun Oct  24 01:04:02 2004
X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id BBA993A2BC7
	for <pgsql-bugs-postgresql.org@localhost.postgresql.org>;
	Sun, 24 Oct 2004 02:04:02 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 97095-03
	for <pgsql-bugs-postgresql.org@localhost.postgresql.org>;
	Sun, 24 Oct 2004 01:03:40 +0000 (GMT)
Received: from mpls-qmqp-01.inet.qwest.net (mpls-qmqp-01.inet.qwest.net
	[63.231.195.112])
	by svr1.postgresql.org (Postfix) with SMTP id 386013A2BB6
	for <pgsql-bugs@postgresql.org>; Sun, 24 Oct 2004 02:04:00 +0100 (BST)
Received: (qmail 550 invoked by uid 0); 24 Oct 2004 01:04:05 -0000
Received: from unknown (63.231.195.1)
	by mpls-qmqp-01.inet.qwest.net with QMQP; 24 Oct 2004 01:04:05 -0000
Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37)
	by mpls-pop-01.inet.qwest.net with SMTP; 24 Oct 2004 01:04:05 -0000
Date: Sat, 23 Oct 2004 19:06:21 -0600
Message-Id: <1098579981.21035.112.camel@localhost.localdomain>
From: "Scott Marlowe" <smarlowe@qwest.net>
To: "Davide Negri" <davide.negri@zeropiu.it>
Cc: pgsql-bugs@postgresql.org
Subject: Re: [GENERAL] Question on the 8.0Beta Version
In-Reply-To: <20041022070342.534EE36CF1@piragna.zeropiu.it>
References: <20041022070342.534EE36CF1@piragna.zeropiu.it>
Content-Type: text/plain
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200410/235
X-Sequence-Number: 9698

On Fri, 2004-10-22 at 00:59, Davide Negri wrote:
> Hello, 
> 
> i have installed postgres 8.0 beta3 as a program on my pc on windows
> xp. I have read on the installation note file that postgres server
> will not run with administrative permissions. I have read on your
> forum that this happened because i have installed the beta version: is
> it true that this happen only with the beta version? When will you
> plan to release the production version? 

I think you may have misunderstood the docs.  PostgreSQL doesn't run
under any account that has machine admin / root privelages because that
makes any small security issue in postgresql into a root level exploit,
and that's a bad thing.




From haraldarminmassa@gmail.com Sun Oct  24 10:19:28 2004
X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id C0D473A3EF5
	for <pgsql-bugs-postgresql.org@localhost.postgresql.org>;
	Sun, 24 Oct 2004 11:19:28 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 99579-07
	for <pgsql-bugs-postgresql.org@localhost.postgresql.org>;
	Sun, 24 Oct 2004 10:19:03 +0000 (GMT)
Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.197])
	by svr1.postgresql.org (Postfix) with ESMTP id 8159D3A3EDF
	for <pgsql-bugs@postgresql.org>; Sun, 24 Oct 2004 11:19:26 +0100 (BST)
Received: by rproxy.gmail.com with SMTP id 73so332616rnk
	for <pgsql-bugs@postgresql.org>; Sun, 24 Oct 2004 03:19:31 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
	b=YhKRYfVgrAqUIVAs+KD/vEXz3UgymT+KwJZ8nWF1AWnVLfcfSGnjkI2/epajzFdG1beGtgJ1u271jIftbTZuTcJ8ySQKXAKEfs6vFMSUn0LCqkjb6FqXNmxcCGPi1zURtUSqN6Dvq0DhblV+XUs97owUJt8szz+X4B6IyqRBigM=
Received: by 10.38.218.39 with SMTP id q39mr391177rng;
	Sun, 24 Oct 2004 03:19:31 -0700 (PDT)
Received: by 10.38.149.4 with HTTP; Sun, 24 Oct 2004 03:19:31 -0700 (PDT)
Message-ID: <7be3f35d041024031935c3fbee@mail.gmail.com>
Date: Sun, 24 Oct 2004 12:19:31 +0200
From: Harald Armin Massa <haraldarminmassa@gmail.com>
Reply-To: Harald Armin Massa <haraldarminmassa@gmail.com>
To: Gaetano Mendola <mendola@bigfoot.com>
Subject: Re: Question on the 8.0Beta Version
Cc: Davide Negri <davide.negri@zeropiu.it>, pgsql-bugs@postgresql.org
In-Reply-To: <417AD656.8090608@bigfoot.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <20041022070342.534EE36CF1@piragna.zeropiu.it>
	<417AD656.8090608@bigfoot.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200410/227
X-Sequence-Number: 9690

> > I have read on the installation note file that postgres server will not
> > run with administrative permissions. I have read on your forum that this
> > happened because i have installed the beta version: is it true that this
> > happen only with the beta version?

It is written by the core developers that "running postgres with admin
privileges" will never be possible. (at least with the official
sources)

It has been discussed in detail; with pro and cons and it was a very
informed decission.

You can read it wihtin the PSQL-Hackers list.

Harald



From adrian.maier@gmail.com Tue Oct  26 06:14:06 2004
X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 7DB7A3A430B
	for <pgsql-bugs-postgresql.org@localhost.postgresql.org>;
	Tue, 26 Oct 2004 07:14:06 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 21180-04
	for <pgsql-bugs-postgresql.org@localhost.postgresql.org>;
	Tue, 26 Oct 2004 06:13:58 +0000 (GMT)
Received: from mproxy.gmail.com (mproxy.gmail.com [216.239.56.243])
	by svr1.postgresql.org (Postfix) with ESMTP id BC7973A3B28
	for <pgsql-bugs@postgresql.org>; Tue, 26 Oct 2004 07:13:58 +0100 (BST)
Received: by mproxy.gmail.com with SMTP id u33so171776cwc
	for <pgsql-bugs@postgresql.org>; Mon, 25 Oct 2004 23:13:54 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
	b=j9ioECoKeR0tvUE+b/fWzTG006+ciZ1msnalE1CSQhlaa5BfFi8MQ4ecTa1jj4Shg08vdeP3gIY9Hry6Rpllkm8qXFjTXrwGCa3LO9keJ3POkweJ/ccZklEPesANS3IQTND+S8Bef0fMQkReay4tf9PJVjveBG9J4wuwbFCTyKk=
Received: by 10.11.122.9 with SMTP id u9mr177727cwc;
	Mon, 25 Oct 2004 23:13:54 -0700 (PDT)
Received: by 10.11.100.50 with HTTP; Mon, 25 Oct 2004 23:13:54 -0700 (PDT)
Message-ID: <cd30ef8c04102523134b9870f0@mail.gmail.com>
Date: Tue, 26 Oct 2004 09:13:54 +0300
From: Adrian Maier <adrian.maier@gmail.com>
Reply-To: Adrian Maier <adrian.maier@gmail.com>
To: Davide Negri <davide.negri@zeropiu.it>
Subject: Re: [HACKERS] Question on the 8.0Beta Version
Cc: pgsql-bugs@postgresql.org
In-Reply-To: <20041022070342.534EE36CF1@piragna.zeropiu.it>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <20041022070342.534EE36CF1@piragna.zeropiu.it>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200410/272
X-Sequence-Number: 9735

On Fri, 22 Oct 2004 08:59:56 +0200, Davide Negri
<davide.negri@zeropiu.it> wrote:
> Hello, 
> i have installed postgres 8.0 beta3 as a program on my pc on windows xp. I
> have read on the installation note file that postgres server will not run
> with administrative permissions. I have read on your forum that this
> happened because i have installed the beta version: is it true that this
> happen only with the beta version? When will you plan to release the
> production version? 

Hello,
The fact that postgres cannot be run by Administrator is not a
"limitation" of the beta version. This is the intended behaviour
and i don't think that it would change. In UNIX, postgres
reacts the same way: it refuses to start when run by root
(root is the admin user) because it is a bad practice to start
services as root - for security reasons. This idea might be
unfamiliar for the windows users who are used to run 
everything with admin rights...
(In fact, we are talking about a feature: a user does not need 
to be administrator in order to run PostgreSQL).

Best wishes,
Adrian Maier