Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: pls help me(How to start Postgres)

Re: pls help me(How to start Postgres)

From
"sandhya"
Date:
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"<path>\bin\pg_ctl.exe start -D""<pat
h>\PostgreSql\data" -l "<path>\sanur pwd
Enter password for SANDHYAR\Postgres<path>\bin\pg_ctl.exe start -D"<path>\Postgr
eSql\data -l <path>\sanur:
Attempting to start "pwd" as user "SANDHYAR\Postgres<path>\bin\pg_ctl.exe start
-D"<path>\PostgreSql\data -l <path>\sanur"...
RUNAS ERROR:  Unable to run - pwd
1326: Logon failure: unknown user name or bad password.
 
Sandhya
----- Original Message -----
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
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 "<path>\pgsql\bin\pg_ctl.exe start -D ""<path>\pgsql\data" -l ""<path>\pgsql\pg_log.txt"" | "<path>\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
 
Also u have to copy libpq.dll either in %system32% or in PG bin folder.
 
Regards
Mohamed Fazil
 
 


sandhya <sandhyar@amiindia.co.in> 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.

Re: pls help me(How to start Postgres)

From
Mohamed Fazil
Date:
Hi,
You made a mistake while typing syntax
E:\PostgreSql>runas /user:SANDHYAR\Postgres"<path>\bin\pg_ctl.exe start -D""<path>\PostgreSql\data" -l "<path>\sanur pwd
E:\PostgreSql>runas /user:SANDHYAR\Postgres"<path>\bin\pg_ctl.exe start -D ""<path>\pgsql\data" -l "<path>\pgsql\pg_log.txt"" |(pipe, Press shift and press backslash button) <path>\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" <path>\bin\pg_ctl.exe start -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 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 <sandhyar@amiindia.co.in> 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"<path>\bin\pg_ctl.exe start -D""<pat
h>\PostgreSql\data" -l "<path>\sanur pwd
Enter password for SANDHYAR\Postgres<path>\bin\pg_ctl.exe start -D"<path>\Postgr
eSql\data -l <path>\sanur:
Attempt ing to start "pwd" as user "SANDHYAR\Postgres<path>\bin\pg_ctl.exe start
-D"<path>\PostgreSql\data -l <path>\sanur"...
RUNAS ERROR:  Unable to run - pwd
1326: Logon failure: unknown user name or bad password.
 
Sandhya
----- Original Message -----
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
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 "<path>\pgsql\bin\pg_ctl.exe start -D ""<path>\pgsql\data" -l ""<path>\pgsql\pg_log.txt"" | "<path>\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
 
Also u have to copy libpq.dll either in %system32% or in PG bin folder.
 
Regards
Mohamed Fazil
 
 


sandhya <sandhyar@amiindia.co.in> 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.

Re: pls help me(How to start Postgres)

From
"sandhya"
Date:
hi...
Even now facing the same problem......help me pls
 
E:\PostgreSql\bin>runas /user:SANDHYAR\postgres"<path>\bin\pg_ctl.exe start -D""<path>\PostgreSql\data"-l "<path>\PostgreSql\pg_log.txt"" | <path>/sanur pwd
Enter password for SANDHYAR\postgres<path>\bin\pg_ctl.exe start -D"<path>\PostgreSql\data-l<path>\PostgreSql\pg_log.txt|<path>/sanur:
Attempting to start "pwd" as user "SANDHYAR\postgres<path>\bin\pg_ctl.exe start -D"<path>\PostgreSql\data-l<path>\PostgreSql\pg_log.txt|<path>/sanur"...
RUNAS ERROR:  Unable to run - pwd
1326: Logon failure: unknown user name or bad password.
 
 
 
 
 

----- Original Message -----
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"<path>\bin\pg_ctl.exe start -D""<path>\PostgreSql\data" -l "<path>\sanur pwd
E:\PostgreSql>runas /user:SANDHYAR\Postgres"<path>\bin\pg_ctl.exe start -D ""<path>\pgsql\data" -l "<path>\pgsql\pg_log.txt"" |(pipe, Press shift and press backslash button) <path>\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" <path>\bin\pg_ctl.exe start -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 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 <sandhyar@amiindia.co.in> 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"<path>\bin\pg_ctl.exe start -D""<pat
h>\PostgreSql\data" -l "<path>\sanur pwd
Enter password for SANDHYAR\Postgres<path>\bin\pg_ctl.exe start -D"<path>\Postgr
eSql\data -l <path>\sanur:
Attempt ing to start "pwd" as user "SANDHYAR\Postgres<path>\bin\pg_ctl.exe start
-D"<path>\PostgreSql\data -l <path>\sanur"...
RUNAS ERROR:  Unable to run - pwd
1326: Logon failure: unknown user name or bad password.
 
Sandhya
----- Original Message -----
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
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 "<path>\pgsql\bin\pg_ctl.exe start -D ""<path>\pgsql\data" -l ""<path>\pgsql\pg_log.txt"" | "<path>\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
 
Also u have to copy libpq.dll either in %system32% or in PG bin folder.
 
Regards
Mohamed Fazil
 
 


sandhya <sandhyar@amiindia.co.in> 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.

Re: pls help me(How to start Postgres)

From
"sandhya"
Date:
The following is the Problem i am facing pls help me....
 
How can i start my Postgresql  with out any loss of data?
E:\PostgreSql\bin>pg_ctl start -D E:\PostgreSql\data
postmaster starting
 
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 preventpossible system security compromises.  See the documentation for more information on how to properly start the server.
 
Thank you,
Sandhya