| 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: | Whole Thread | Raw Message | 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.
| 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? |