Re: re-install postgres/postGIS without Loosing data??

Hi salah,

I tried

C:\Program Files\PostgreSQL\9.0\bin>pg_ctl.exe -U postgres restart
pg_ctl: PID file "C:/Program Files/PostgreSQL/9.0/data/postmaster.pid" does not
exist
Is server running?
starting server anyway
server starting

but i get the following error:

2011-05-18 02:09:26 EEST LOG: database system was shut down at 2011-05-17
22:45:00 EEST
2011-05-18 02:09:36 EEST LOG: could not remove cache file
"base/32803/pg_internal.init": Permission denied
2011-05-18 02:09:36 EEST PANIC: could not open file
"pg_xlog/000000010000000000000002" (log file 0, segment 2): Permission denied

This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.

2011-05-18 02:09:36 EEST LOG: startup process (PID 5636) exited with exit code
3
2011-05-18 02:09:36 EEST LOG: aborting startup due to startup process failure

Thats why i am considering to re-install postgres....

________________________________
From: salah jubeh <s_jubeh(at)yahoo(dot)com>
To: G. P. <pagomen2001(at)yahoo(dot)gr>
Sent: Wed, May 18, 2011 1:05:38 AM
Subject: Re: [GENERAL] re-install postgres/postGIS without Loosing data??

Have a look on
http://www.postgresql.org/docs/current/static/app-pg-ctl.html

Regards

________________________________
From: G. P. <pagomen2001(at)yahoo(dot)gr>
To: pgsql-general(at)postgresql(dot)org
Sent: Tuesday, May 17, 2011 11:54 PM
Subject: [GENERAL] re-install postgres/postGIS without Loosing data??

Hi,

I have installed postres/postgis 9 in win7.
I tried to edit pg_hba.conf not as postgres user and although i cancelled all
changes I can start my postgres any more......

Now I am thinking of re-installing postgresql but for sure i dont loose my data
...
Any ideas ?

Thx
George