答复: [GENERAL] Unable to start server - winxp

Well, you mean you don’t know how to start the server on your WinXP?

I think you could install your postgresql on linux or unix instead of windows.

To start the server , you can use postmaster –D database –U <name>. U can use your user name replace the <name>.

Also,I think you can read Howtos and use command line ‘man postmaster’ for help.

_____

发件人: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] 代表 Joost Kuckartz
发送时间: 2006年12月22日 17:14 MARK
收件人: Richard Huxton
抄送: pgsql-general@postgresql.org
主题: Re: [GENERAL] Unable to start server - winxp

Hello all,

I changed port 80 again, so localhost is now running on that.

I checked all the manuals, which were mostly written for linux and unix based systems. The only command I found was "postmaster -D database". When I try that, I'm getting the following error:
"Execution of PostgreSQL by a user with administrative permissions is not permitted.
The server must be started under an unprivileged user ID to prevent possible system security compromises. See the documentation for more information on how to properly start the server."

Well, the documentation doesn't say anything on how to start the server as another user. I only have one user account on my winxp (if it's that one PostgreSQL is looking at) and I don't want to switch to another user (create even one) to start the postgres server. If it's a user account at the postgres system, how do I create a new user there if the server can't start? Does anyone know how I do start the server?

Please help, Thanks,
Joost

_____

Date: Wed, 20 Dec 2006 07:11:58 +0000
From: dev@archonet.com
To: jkuckartz1984@hotmail.com
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unable to start server - winxp

Joost Kuckartz wrote:

Hello,

After a huge amount of trying out (I'm new at running webservers, I
had a lot of problems installing apache too) I finally was able to
install postpresql 8.2 (latest version) on my computer. What I want
to do in the end is have a local webserver running. I installed ms4w
(package with php, mapserver, apache) and I had to change the
httpd.conf port to 81 (80 is in use by I-don't-know-what, I can't see
that)

Stop. Find out what is on port 80 and how to disable it before going
further. If you don't know what your computer is doing, how can you hope
to run a reliable system?

You probably want to read up on "netstat" and "process explorer" and
"IIS" to start with.

Well, I installed the .msi, and I had no idea that the "account"
settings had to be left intact. First I thought I could change it,
but then it installed and always gave the error "user already exists"
(while in the install was asked to create the new user...)

Hmm - does the manual not cover details about why PostgreSQL wants to
run as a separate user?

Ok, so I left all ok, left the computer name there, and created the
new standard username "postgres". Now I can't start the server, it
will say I have to start it not as administrator. Well, I only have
one useraccount here and I'm not planning on switching useraccounts
just to run postgresql, or change my account so I don't have admin
rights anymore.

You can start it as anyone, but you should run it as a non-administrator
account. Do you understand how user-accounts and services on Windows work?

How do I start it? After that the problems of configuring it with
Apache will follow, but first this.

You don't. PostgreSQL will NOT run as an administrator account. It
doesn't need to and it's a security hole if it does so. You should be
able to start the service as an administrator just fine.

I can't compile, and I'm not planning to either. If I had a dedicated
server I probably would run linux or unix or something which can
handle better with webservers anyway. Can somebody help me? Thanks!

I think you're mis-reading the error message. You can start it as an
administrator, and it should run as user "postgres". The only thing I
can think is that user "postgres" somehow has some administrator rights
and that is why its complaining.

In any case, to get a more accurate answer you'll need to provide the
exact error message and what you were doing when it happened.

PS - you can hire "virtual" linux servers quite cheaply which will let
you play around with setting up all sort of packages.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

_____

Met MSN Spaces kun je per e-mail je weblog bijwerken. Publiceer leuke verhalen, foto's en meer! Het is gratis! Het is gratis! <http://clk.atdmt.com/MSN/go/msnnksac0030000001msn/direct/01/?href=http://www.imagine-msn.com/spaces&gt;