pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: sandhya <sandhyar@amiindia.co.in>
To: Mohamed Fazil <mohdfazil_p_a@yahoo.com>
Cc: Postgres <pgsql-admin@postgresql.org>
Subject: Re: pls help me
Date: Thu, 9 Mar 2006 15:08:49 +0530
Message-ID: <008701c6435d$4eede1b0$cd00000a@sandhyar> (raw)
References: <20060309091619.57798.qmail@web31015.mail.mud.yahoo.com>

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 ----- 
  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.

view thread (5+ messages)  latest in thread

Message-ID: <008701c6435d$4eede1b0$cd00000a@sandhyar>
Permalink:  ../008701c6435d$4eede1b0$cd00000a@sandhyar/
Also on:    postgresql.org/message-id/008701c6435d$4eede1b0$cd00000a@sandhyar

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: sandhyar@amiindia.co.in, mohdfazil_p_a@yahoo.com
  Subject: Re: pls help me
  In-Reply-To: <008701c6435d$4eede1b0$cd00000a@sandhyar>
  References: <20060309091619.57798.qmail@web31015.mail.mud.yahoo.com> <008701c6435d$4eede1b0$cd00000a@sandhyar>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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