Please help me to implement PGSQL8.0 no-installer in Windows 2k,XP & NT ?

Mohamed Fazil <mohdfazil_p_a@xxxxxxxxx> · Fri, 23 Dec 2005 02:35:34 -0800 (PST)

Hi,

  With this i enclosed my requirement. Along with this i would like to know your suggestion and the way to impliment the same as a service. Please note that i am using PGSQL 8.0 no-installer in Windows. One of the member had came up with the suggestion that it is related to Windows impersonalisation. Those who knows about this please come forward to help me out.

  Thanking You
  Mohamed Fazil 

Yahoo! for Good - 
Make a difference this year. --- Begin Message ---

Subject: Re: [ADMIN] How to implement PGSQL8.0 no-installer in Windows 2k,XP & NT ?
From: Mohamed Fazil <mohdfazil_p_a@xxxxxxxxx>
Date: Thu, 22 Dec 2005 22:02:31 -0800 (PST)
Authentication-results: mta169.mail.dcn.yahoo.com  from=postgresql.org; domainkeys=fail (bad syntax)
In-reply-to: <doff8o$11lr$1@xxxxxxxxxxxx>

Sender: pgsql-admin-owner@xxxxxxxxxxxxxx

Thank You. No, I had this doc already. Here it explains only how to install using an installer. What i am trying is to incorporate Postgres using the packages available in postgresql-8.0.5-binaries-no-installer.zip. I am able to start the database after the following conditions.
  1. copied libpq.dll in \system32 in a login grook\gat (domain\username)
  2.  Now tried to start pg_ctl.exe by passing the parameter of data table in the aove mentioned login.
  3. Then it shows me the following error ...
      postmaster starting
    Execution of PostgreSQL by a user with administrative permissions is not
    permitted.The server must be started under an unprivileged user ID to prevent
    po
 ssible
 system security compromises.  See the documentation for
    more information on how to properly start the server.
  4. After this message i logged in as different user that does not have administartor rights and it started. 
  What i want to know is how to start the application without logging out and re log. Any provision to create a user only for postgres and to start the application in that user.
  Eg: If i have logged in as  grook\gat (domain\username) and installed the database in this log in and start the database using mac12\postgre(domain\username) from the login grook\dat. 
  The thing i want to know whether the process mentioned in the above eg is possible or not?. If yes, how and what are the steps to go for it. Please help me to solve this.........

  Thanking You

 Mohamed Fazil

Yahoo! Shopping

Find Great Deals on Holiday Gifts at Yahoo! Shopping 
--- End Message ---