pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: pls help me(How to start Postgres)
4+ messages / 2 participants
[nested] [flat]

* Re: pls help me(How to start Postgres)
@ 2006-03-13 05:53  sandhya <sandhyar@amiindia.co.in>
  0 siblings, 1 reply; 4+ messages in thread

From: sandhya @ 2006-03-13 05:53 UTC (permalink / raw)
  To: Mohamed Fazil <mohdfazil_p_a@yahoo.com>; +Cc: pgsql-admin

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 ----- 
  From: Mohamed Fazil 
  To: sandhya 
  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
  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 <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.

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: pls help me(How to start Postgres)
@ 2006-03-13 06:09  Mohamed Fazil <mohdfazil_p_a@yahoo.com>
  parent: sandhya <sandhyar@amiindia.co.in>
  0 siblings, 2 replies; 4+ messages in thread

From: Mohamed Fazil @ 2006-03-13 06:09 UTC (permalink / raw)
  To: sandhya <sandhyar@amiindia.co.in>; +Cc: pgsql-admin

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:
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 ----- 
  From: Mohamed Fazil 
  To: sandhya 
  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
  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 <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.


Mohamed Fazil.P.A
CRISIL
Mumbai

Mob : 9869520774
		
---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail  makes sharing a breeze. 

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: pls help me(How to start Postgres)
@ 2006-04-13 07:51  sandhya <sandhyar@amiindia.co.in>
  parent: Mohamed Fazil <mohdfazil_p_a@yahoo.com>
  1 sibling, 0 replies; 4+ messages in thread

From: sandhya @ 2006-04-13 07:51 UTC (permalink / raw)
  To: Mohamed Fazil <mohdfazil_p_a@yahoo.com>; +Cc: pgsql-admin

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 ----- 
  From: Mohamed Fazil 
  To: sandhya 
  Cc: pg-admin postgre 
  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 ----- 
      From: Mohamed Fazil 
      To: sandhya 
      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
      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 <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. 

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: pls help me(How to start Postgres)
@ 2006-04-13 07:56  sandhya <sandhyar@amiindia.co.in>
  parent: Mohamed Fazil <mohdfazil_p_a@yahoo.com>
  1 sibling, 0 replies; 4+ messages in thread

From: sandhya @ 2006-04-13 07:56 UTC (permalink / raw)
  To: Mohamed Fazil <mohdfazil_p_a@yahoo.com>; pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2006-04-13 07:56 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-13 05:53 Re: pls help me(How to start Postgres) sandhya <sandhyar@amiindia.co.in>
2006-03-13 06:09 ` Mohamed Fazil <mohdfazil_p_a@yahoo.com>
2006-04-13 07:51   ` sandhya <sandhyar@amiindia.co.in>
2006-04-13 07:56   ` sandhya <sandhyar@amiindia.co.in>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox