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 210F29DCDE3 for ; Mon, 13 Mar 2006 03:46:48 -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 66180-09-2 for ; Mon, 13 Mar 2006 03:46:43 -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 AD1F39DCD68 for ; Mon, 13 Mar 2006 03:46:17 -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 k2D7e1H6000853; Mon, 13 Mar 2006 13:10:07 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 8398A33268A; Mon, 13 Mar 2006 13:09:59 +0530 (IST) Message-ID: <004401c65ecf$160315e0$cd00000a@sandhyar> From: "sandhya" To: "Mohamed Fazil" Cc: "pg-admin postgre" References: <20060313060911.99227.qmail@web31008.mail.mud.yahoo.com> Subject: Re: pls help me(How to start Postgres) Date: Thu, 13 Apr 2006 13:21:32 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0041_01C65EFD.2F59A9E0" 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=1.047 required=5 tests=[AWL=-0.843, DATE_IN_FUTURE_96_XX=1.888, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 1.047 X-Spam-Level: * X-Archive-Number: 200603/107 X-Sequence-Number: 20864 This is a multi-part message in MIME format. ------=_NextPart_000_0041_01C65EFD.2F59A9E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi... Even now facing the same problem......help me pls E:\PostgreSql\bin>runas /user:SANDHYAR\postgres"\bin\pg_ctl.exe = start -D""\PostgreSql\data"-l "\PostgreSql\pg_log.txt"" | = /sanur pwd Enter password for SANDHYAR\postgres\bin\pg_ctl.exe start = -D"\PostgreSql\data-l\PostgreSql\pg_log.txt|/sanur: Attempting to start "pwd" as user = "SANDHYAR\postgres\bin\pg_ctl.exe start = -D"\PostgreSql\data-l\PostgreSql\pg_log.txt|/sanur"... RUNAS ERROR: Unable to run - pwd 1326: Logon failure: unknown user name or bad password. ----- Original Message -----=20 From: Mohamed Fazil=20 To: sandhya=20 Cc: pg-admin postgre=20 Sent: Monday, March 13, 2006 11:39 AM Subject: Re: [ADMIN] pls help me(How to start Postgres) Hi, You made a mistake while typing syntax E:\PostgreSql>runas /user:SANDHYAR\Postgres"\bin\pg_ctl.exe = start -D""\PostgreSql\data" -l "\sanur pwd E:\PostgreSql>runas /user:SANDHYAR\Postgres"\bin\pg_ctl.exe = start -D ""\pgsql\data" -l "\pgsql\pg_log.txt"" |(pipe, = Press shift and press backslash button) \sanur pwd For using sanur you have to download. First you try without using that using that utility. For this use the = following syntax Step1: runas /user:SANDHYAR\Postgres" \bin\pg_ctl.exe start -D = "\PostgreSql\data"" Step2: Type the password of the user postgres Note: You can use -l "text file path" if u req a log file. It will = create if the log file mentioned is not available. Also go thru = http://www.postgresql.org/docs/8.1/interactive/app-pg-ctl.html to find = out the proper syntax Try this Regards Mohamed Fazil sandhya wrote: Hi Fazil,,, When i tried to did what u said..I faced the following = problem.Please tell me how to solve this. E:\PostgreSql>runas /user:SANDHYAR\Postgres"\bin\pg_ctl.exe = start -D""\PostgreSql\data" -l "\sanur pwd Enter password for SANDHYAR\Postgres\bin\pg_ctl.exe start = -D"\Postgr eSql\data -l \sanur: Attempt ing to start "pwd" as user = "SANDHYAR\Postgres\bin\pg_ctl.exe start -D"\PostgreSql\data -l \sanur"... RUNAS ERROR: Unable to run - pwd 1326: Logon failure: unknown user name or bad password. Sandhya ----- 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 F ollowing 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 on s 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. Mohamed Fazil.P.A CRISIL Mumbai Mob : 9869520774 -------------------------------------------------------------------------= ----- Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze. ------=_NextPart_000_0041_01C65EFD.2F59A9E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hi...
Even now facing the same problem......help = me=20 pls
 
E:\PostgreSql\bin>runas=20 /user:SANDHYAR\postgres"<path>\bin\pg_ctl.exe start=20 -D""<path>\PostgreSql\data"-l = "<path>\PostgreSql\pg_log.txt"" |=20 <path>/sanur pwd
Enter password for=20 SANDHYAR\postgres<path>\bin\pg_ctl.exe start=20 -D"<path>\PostgreSql\data-l<path>\PostgreSql\pg_log.txt|<p= ath>/sanur:
Attempting to start "pwd" as user=20 "SANDHYAR\postgres<path>\bin\pg_ctl.exe start=20 -D"<path>\PostgreSql\data-l<path>\PostgreSql\pg_log.txt|<p= ath>/sanur"...
RUNAS=20 ERROR:  Unable to run - pwd
1326: Logon failure: unknown user name or bad=20 password.
 
 
 
 
 

----- Original Message -----
From:=20 Mohamed=20 Fazil
To: sandhya
Sent: Monday, March 13, 2006 = 11:39=20 AM
Subject: Re: [ADMIN] pls help = me(How to=20 start Postgres)

Hi,
You made a mistake while typing syntax
E:\PostgreSql>runas=20 /user:SANDHYAR\Postgres"<path>\bin\pg_ctl.exe start=20 -D""<path>\PostgreSql\data" -l "<path>\sanur pwd
E:\PostgreSql>runas=20 /user:SANDHYAR\Postgres"<path>\bin\pg_ctl.exe start -D=20 ""<path>\pgsql\data" -l "<path>\pgsql\pg_log.txt"" |(pipe, Press shift and press backslash button)=20 <path>\sanur pwd
 
For using sanur you have to download.
First you try without using that using that utility. For this use = the=20 following syntax
Step1: runas /user:SANDHYAR\Postgres" <path>\bin\pg_ctl.exe = start=20 -D "<path>\PostgreSql\data""
Step2: Type the password of the user postgres
 
Note: You can use -l "text file path" if u req a log file. It = will create=20 if the log file mentioned is not available.
Also go thru h= ttp://www.postgresql.org/docs/8.1/interactive/app-pg-ctl.html to= =20 find out the proper syntax
Try this
 
Regards
Mohamed Fazil

sandhya=20 <sandhyar@amiindia.co.in> wrote:
Hi Fazil,,,
 
When i tried to did what u said..I faced the = following=20 problem.Please tell me how to solve this.
E:\PostgreSql>runas=20 /user:SANDHYAR\Postgres"<path>\bin\pg_ctl.exe start=20 -D""<pat
h>\PostgreSql\data" -l "<path>\sanur = pwd
Enter=20 password for SANDHYAR\Postgres<path>\bin\pg_ctl.exe start=20 -D"<path>\Postgr
eSql\data -l = <path>\sanur:
Attempt ing to=20 start "pwd" as user "SANDHYAR\Postgres<path>\bin\pg_ctl.exe=20 start
-D"<path>\PostgreSql\data -l = <path>\sanur"...
RUNAS=20 ERROR:  Unable to run - pwd
1326: Logon failure: unknown = user name=20 or bad password.
 
Sandhya
----- Original Message ----- =
From:=20 Mohamed Fazil
To: sandhya
Sent: Thursday, March 09, = 2006 2:46=20 PM
Subject: Re: [ADMIN] pls = help=20 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=20 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 F ollowing 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> = wrote:
 
My Postgres server is not connecting now.I = am working=20 on windows .
I am getting the following error = message.

E:\PostgreSql\bin>Execution of PostgreSQL by a user = with=20 administrative permissi
on s is not
permitted.
The = server must=20 be started under an unprivileged user ID to prevent
possible = system=20 security compromises.  See the documentation for
more=20 information on how to properly start the server.
and when i tried to start from the service..i am getting = the=20 following 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.



Mohamed=20 Fazil.P.A
CRISIL
Mumbai

Mob : 9869520774


Yahoo! Mail
Bring photos to life! New=20 PhotoMail makes sharing a breeze. ------=_NextPart_000_0041_01C65EFD.2F59A9E0--