pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: ron <bragustin@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Problem starting up PostgreSQL 8.0 database service in Windows 2003 server
Date: Thu, 7 Dec 2006 22:44:15 +0530
Message-ID: <a97c77030612070914m635603d1nd1015bafc9604a62@mail.gmail.com> (raw)
In-Reply-To: <cdde6360612070855m3bfbb7aah1b03515127fe31a8@mail.gmail.com>
References: <cdde6360612070855m3bfbb7aah1b03515127fe31a8@mail.gmail.com>

On 12/7/06, ron <bragustin@gmail.com> wrote:
> Please kindly help me with this problem I am experiencing with starting up a
> PostgreSQL 8.0 db service in a Windows 2003 server.
>  Whenever I attempt to restart the service I always get the message: "The
> PostgreSQL Database Server 8.0  on Local Computer started and then stopped.
>  Some services stop automatically if they have no work to do, for example,
> the Performance Logs and Alerts service."
>
>  I tried running postgres in command line with:
> c:\...\PostgreSQL\8.0\bin\postgres -
> D:\Progra...\PostgreSQL\8.0\data template1 gives me:
>  "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. ..."

Go to Control Panel --> users --> L  ocate the user
you use to login. convert the account to a limited account.

OR

create a new user postgres and do not give administrative rights
while creating. Run postgres using that user.

I havent' run postgresql on windows yet so i cannot give very specific
instructions but i hope you got the point.

Regds
mallah





>
>  Need badly your help in dealing with this one.
>
>  Many thanks in advance.
>
>
>
> --
> R. Agustin
> - - - - - - - - - - - - - - - - - - - - - - - - - -
> E-mail: bragustin@gmail.com
> ICQ #: 146807041
> _______________________________________
> This email contains confidential information for the sole use of the
> intended
> recipient/s. If you are not the intended recipient, please contact
> the sender, delete this email and maintain the confidentiality of what
> you may have read.
>
> "It is a capital mistake to theorize before one has data."
> - Sherlock Holmes
>



view thread (3+ messages)  latest in thread

Message-ID: <a97c77030612070914m635603d1nd1015bafc9604a62@mail.gmail.com>
Permalink:  ../a97c77030612070914m635603d1nd1015bafc9604a62@mail.gmail.com/
Also on:    postgresql.org/message-id/a97c77030612070914m635603d1nd1015bafc9604a62@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: mallah.rajesh@gmail.com, bragustin@gmail.com
  Subject: Re: Problem starting up PostgreSQL 8.0 database service in Windows 2003 server
  In-Reply-To: <a97c77030612070914m635603d1nd1015bafc9604a62@mail.gmail.com>
  References: <cdde6360612070855m3bfbb7aah1b03515127fe31a8@mail.gmail.com> <a97c77030612070914m635603d1nd1015bafc9604a62@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox