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_ju...@yahoo.com> To: G. P. <pagomen2...@yahoo.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. <pagomen2...@yahoo.gr> To: pgsql-general@postgresql.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
