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 615C29DC806 for ; Thu, 9 Mar 2006 05:38:13 -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 22141-02 for ; Thu, 9 Mar 2006 05:38:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id EFECA9DC82E for ; Thu, 9 Mar 2006 05:38:04 -0400 (AST) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k299RsH5022157; Thu, 9 Mar 2006 14:58:01 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 88A54332670; Thu, 9 Mar 2006 14:57:45 +0530 (IST) Message-ID: <008701c6435d$4eede1b0$cd00000a@sandhyar> From: "sandhya" To: "Mohamed Fazil" Cc: "Postgres" References: <20060309091619.57798.qmail@web31015.mail.mud.yahoo.com> Subject: Re: pls help me Date: Thu, 9 Mar 2006 15:08:49 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0082_01C6438B.602A2E10" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.102 required=5 tests=[AWL=0.100, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.102 X-Spam-Level: X-Archive-Number: 200603/94 X-Sequence-Number: 20851 This is a multi-part message in MIME format. ------=_NextPart_000_0082_01C6438B.602A2E10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thank you Fazil..... Is there any specific reason that we need to go c:\WINDOWS\system32 I have already user existing for this Postgres.....But when i open psql = to template1 it is clsoing the window..?Why is this happening so? What happened to the user already we created... U mean to say i have to give this at command prompt. ----- Original Message -----=20 From: Mohamed Fazil=20 To: sandhya=20 Sent: Thursday, March 09, 2006 2:46 PM Subject: Re: [ADMIN] pls help me Hi, I am not an expert in PG, still i can help u to some extend as i have = successfully deployed pg8.1.1 using both installer and no installer on = Win XP,2K,2003. To solve your issue=20 1. cretae a user on your local system. 2. Use runas to run pg_ctl using the user created Eg batch file: @echo off chdir c:\WINDOWS\system32 runas /user:SYSNAME\postgres "\pgsql\bin\pg_ctl.exe start -D = ""\pgsql\data" -l ""\pgsql\pg_log.txt"" | "\sanur pwd pause In the above eg sanur is a utility used myself for piping the pwd into = runas as it will ask externally. You can download it from = http://www.commandline.co.uk/sanur_unsupported/index.html Also go through the Following FAQ link f or ur further queries http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html#1.1 Also u have to copy libpq.dll either in %system32% or in PG bin = folder. Regards Mohamed Fazil sandhya wrote: My Postgres server is not connecting now.I am working on windows . I am getting the following error message. E:\PostgreSql\bin>Execution of PostgreSQL by a user with = administrative permissi ons 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. and when i tried to start from the service..i am getting the = following message box. Pls help me..I need it very much Thanks&Regards, Sandhya -------------------------------------------------------------------------= ----- Yahoo! Mail Use Photomail to share photos without annoying attachments. ------=_NextPart_000_0082_01C6438B.602A2E10 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Thank you Fazil.....
Is there any specific reason that we need to = go
c:\WINDOWS\system32
I have already user existing for this = Postgres.....But when i=20 open psql to template1 it is clsoing the window..?Why is this happening=20 so?
What happened to the user already we = created...
U mean to say i have to give this at command=20 prompt.
 
 
----- Original Message -----
From:=20 Mohamed=20 Fazil
To: sandhya
Sent: Thursday, March 09, 2006 = 2:46=20 PM
Subject: Re: [ADMIN] pls help = me

Hi,
 
I am not an expert in PG, still i can help u to some extend as i = have=20 successfully deployed pg8.1.1 using both installer and no installer on = Win=20 XP,2K,2003.
 
To solve your issue
1. cretae a user on your local system.
2. Use runas to run pg_ctl using the user created
Eg batch file:
@echo off
chdir c:\WINDOWS\system32
runas /user:SYSNAME\postgres=20 "<path>\pgsql\bin\pg_ctl.exe start -D ""<path>\pgsql\data" = -l=20 ""<path>\pgsql\pg_log.txt"" | "<path>\sanur = pwd
pause
 
In the above eg sanur is a utility used myself for piping the pwd = into=20 runas as it will ask externally. You can download it from http:/= /www.commandline.co.uk/sanur_unsupported/index.html
 
Also go through the Following FAQ link f or ur further = queries
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html#1.1
 
Also u have to copy libpq.dll either in %system32% or in PG bin=20 folder.
 
Regards
Mohamed Fazil
 
 


sandhya <sandhyar@amiindia.co.in>=20 wrote:
 
My Postgres server is not connecting now.I am = working on=20 windows .
I am getting the following error = message.

E:\PostgreSql\bin>Execution of PostgreSQL by a user with = administrative permissi
ons is not
permitted.
The server = must be=20 started under an unprivileged user ID to prevent
possible system = security=20 compromises.  See the documentation for
more information on = how to=20 properly start the server.
and when i tried to start from the service..i am getting the = following=20 message box.
Pls help me..I need it very much
 
3D""
 
Thanks&Regards,
Sandhya


Yahoo! Mail
Use=20 Photomail to share photos without annoying=20 attachments. ------=_NextPart_000_0082_01C6438B.602A2E10--