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

Поиск
Список
Период
Сортировка
От G. P.
Тема Re: re-install postgres/postGIS without Loosing data??
Дата
Msg-id 148000.58781.qm@web29611.mail.ird.yahoo.com
обсуждение исходный текст
Ответ на re-install postgres/postGIS without Loosing data??  ("G. P." <pagomen2001@yahoo.gr>)
Ответы Re: re-install postgres/postGIS without Loosing data??
Список pgsql-general
Дерево обсуждения
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@yahoo.com>
To: G. P. <pagomen2001@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 

Regards
 

From: G. P. <pagomen2001@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  


В списке pgsql-general по дате отправления:

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: Query to return every 1st Sat of a month between two dates
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Infinity dates in RoR was How to handle bogus nulls from ActiveRecord