Re: pls help me(How to start Postgres) - Mailing list pgsql-admin

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

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