Re: Install issues

On 03/22/11 9:33 AM, Alex wrote:
> Using Windows 7 64 bit. Tried to install 8.4 and 9.0and it fails right
> near the end when it tries to create or read the conf file. If I
> transfer my postgres 8.4 file over the upgrade takes but the postgres
> service doesn't exist so no communication occurs.
>
> Is there anyway to just install the postgres service? Or another
> solution?
>

to create a windows service manually, from the command line prompt, try...

  c:\> sc create postgresql-8.4 binpath=
'"D:/postgres/8.4/bin/pg_ctl.exe" runservice -N postgresql-8.4 -D
"D:/postgres/8.4/data" -w' type= own start= auto depend= RPCSS obj=
./postgres password= yerpgservicepassword


*(yes, thats all one long gnarly line... fix your binary path and data
path as you need...  and yes there's a space after each = and no space
before, this command was designed by aliens)

when you think you got it rigth...

C:\> sc qc postgresql-8.4

should output something like....


SERVICE_NAME: postgresql-8.4
         TYPE               : 10  WIN32_OWN_PROCESS
         START_TYPE         : 2   AUTO_START
         ERROR_CONTROL      : 1   NORMAL
         BINARY_PATH_NAME   : D:/postgres/8.4/bin/pg_ctl.exe runservice
-N "postgresql-8.4" -D "D:/postgres/8.4/data" -w
         LOAD_ORDER_GROUP   :
         TAG                : 0
         DISPLAY_NAME       : postgresql-8.4 - PostgreSQL Server 8.4
         DEPENDENCIES       : RPCSS
         SERVICE_START_NAME : .\postgres