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

Поиск
Список
Период
Сортировка
От G. P.
Тема Re: re-install postgres/postGIS without Loosing data??
Дата
Msg-id 257750.66552.qm@web29612.mail.ird.yahoo.com
обсуждение исходный текст
Ответ на Re: re-install postgres/postGIS without Loosing data??  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: re-install postgres/postGIS without Loosing data??
Список pgsql-general
Hi Craig,All

when i try from the service control panel

I  get an 
1053 error : the service did not respond to restart or control request in a timely fashion

Additionally no log is produced @ 
C:/Program Files/PostgreSQL/9.0/data/pg_log

I suspect a mesh with the postgres account. Can I re-install this account?

thx
george

From: Craig Ringer <craig@postnewspapers.com.au>
To: G. P. <pagomen2001@yahoo.gr>
Cc: salah jubeh <s_jubeh@yahoo.com>; pgsql-general@postgresql.org
Sent: Wed, May 18, 2011 3:52:07 AM
Subject: Re: [GENERAL] re-install postgres/postGIS without Loosing data??

On 18/05/2011 7:13 AM, G. P. wrote:

> 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"

> */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/*

You cannot restart postgresql using pg_ctl running under your normal user account if it was originally set up as a Windows service running as the "postgres" user. You must use runas.exe to run pg_ctl as user "postgres", or just use the service control panel (services.msc) or "net service" command to control it.

Rather than trying to reinstall, which might make the problem worse rather than better, stop trying to change things and think for a moment. Restart the computer, then check the services control panel and see if postgresql is shown as running there. If it is not, try to start it. If it does not start, examine the system event logs ("Event Viewer" in the start menu) to see if there are any error messages from the service. Also check the PostgreSQL logs, which will be in

  C:/Program Files/PostgreSQL/9.0/data/pg_log

to see if there are any informative error messages at the bottom of the most recent log file.

Once you've done that, you'll have some idea what's wrong and what to do next.

-- Craig Ringer

Tech-related writing at http://soapyfrogs.blogspot.com/

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

Предыдущее
От: satoshi.nagayasu@gmail.com
Дата:
Сообщение: Re: Memcached for Database server
Следующее
От: Thierry Hauchard
Дата:
Сообщение: Re: re-install postgres/postGIS without Loosing data??