Can't start service but works from command line

From: "Dejan" <kolufild(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can't start service but works from command line
Date: 2009-05-23 23:19:57
Message-ID: gva0ar$1ues$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Computer which hosted a database crashed, but I managed to save "data"
folder. I copied it to another computer and pointed postgres to that folder
(stopping the service first). But, the service cannot start. Progress bar
just goes for awhile, and then a pop-up tells me that the service stopped.

I found in Services that command for starting the service is this

"C:\Program Files\PostgreSQL\8.2\bin\pg_ctl.exe" runservice -w -N
"pgsql-8.2" -D "f:\PostgreSQL\data\"

I tried to start it from command line with

"C:\Program Files\PostgreSQL\8.2\bin\pg_ctl.exe" start -w -D
"f:\PostgreSQL\data\"

and it works. The server starts and I can connect to it and access all
tables. But I need it to start as a service. Any help? I'm using version
8.2.5 on WinXP Pro SP2.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lew 2009-05-24 00:22:36 Re: Code tables, conditional foreign keys?
Previous Message Conrad Lender 2009-05-23 22:43:33 Re: Code tables, conditional foreign keys?