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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
