On 12/7/06, ron <bragustin@xxxxxxxxx> 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@xxxxxxxxx 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