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@xxxxxxxxx>
To: G. P. <pagomen2001@xxxxxxxx>
Sent: Wed, May 18, 2011 1:05:38 AM
Subject: Re: re-install postgres/postGIS without Loosing data??
Have a look on
Regards
From: G. P. <pagomen2001@xxxxxxxx>
To: pgsql-general@xxxxxxxxxxxxxx
Sent: Tuesday, May 17, 2011 11:54 PM
Subject: 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