X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6D8399DCD1E for ; Fri, 23 Dec 2005 02:02:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48839-04 for ; Fri, 23 Dec 2005 02:02:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web31011.mail.mud.yahoo.com (web31011.mail.mud.yahoo.com [68.142.201.69]) by postgresql.org (Postfix) with SMTP id 2A19D9DCD1D for ; Fri, 23 Dec 2005 02:02:31 -0400 (AST) Received: (qmail 38457 invoked by uid 60001); 23 Dec 2005 06:02:32 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=FKgCyFHDfDeJbSA+h7I4wIg6j1xH3Pi9AWZa4jotRvexlAqIwORsJF27UuTX5Pf6iIg2BERyWkd4SAJOBUCt1Kt+czFomTZZ4bTBa1+cCK9tUjT6pGXJHUjRDTADyFIFU7RMaRt4xfOob5nAaenK1UC4yp+gFlxyy+K2lw1qM90= ; Message-ID: <20051223060231.38455.qmail@web31011.mail.mud.yahoo.com> Received: from [220.227.114.194] by web31011.mail.mud.yahoo.com via HTTP; Thu, 22 Dec 2005 22:02:31 PST Date: Thu, 22 Dec 2005 22:02:31 -0800 (PST) From: Mohamed Fazil Subject: Re: How to implement PGSQL8.0 no-installer in Windows 2k,XP & NT ? To: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-966754806-1135317751=:36331" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.716 required=5 tests=[AWL=0.236, DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] X-Spam-Score: 0.716 X-Spam-Level: X-Archive-Number: 200512/294 X-Sequence-Number: 20014 --0-966754806-1135317751=:36331 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 possible 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 --0-966754806-1135317751=:36331 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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 --0-966754806-1135317751=:36331--