Troubles with starting postgresql

Поиск
Список
Период
Сортировка
От Alex. N. Karpov
Тема Troubles with starting postgresql
Дата
Msg-id 44980E1C.3020705@spy.isp.nsc.ru
обсуждение исходный текст
Ответы Re: Troubles with starting postgresql  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hello!

I have troubles with starting postmaster...

> spy:/etc/init.d# ./postgresql
> Starting PostgreSQL database server: postmaster(FAILED)
> ERROR: ERROR: PostgreSQL postmaster did not start because of an
> unknown reason.
> PostgreSQL's init script (/etc/init.d/postgresql) attempted
> to start the postmaster, however, this failed because of an unknown
> reason.
>
> This should not happen and is a serious problem. Please examine the
> situation (please take a look at the log files). If you know the
> reason why it failed and, then please file a bug report to Debian
> (unless the reason is something obvious like a full disk).
>
> Debian PostgreSQL
1) Disks are not full
2) Daemon doesn't write logs into logfile, although I have these keys in
/etc/postgresql/postgresql.conf:
> syslog = 1 # range 0-2; 0=stdout; 1=both; 2=syslog
> syslog_ident = 'postgres'
> client_min_messages = debug5
> log_min_messages = debug5
> log_error_verbosity = defaul
> log_min_error_statement = debug5
> log_min_duration_statement = 0
> silent_mode = false
I check all files in /var/log/. The only thing it write to
/var/log/postgresql/postgres.log is:
> FATAL:  XX000: failed to initialize lc_messages to ""
> LOCATION:  InitializeGUCOptions, guc.c:1867
Before installing postgresql from packages I has removed all postgres
dirs that I found:
/etc/postgresql/
/usr/lib/postgresql/
/usr/share/postgresql/

System: debian sarge
Kernel: 2.6.9

I have tried with psql versions 7.4.7 and 7.4.13-3. I also tried
8.1.4-1, but not heavily (my unsaved database was created by psql 7.4)

I don't know what I have to do next. What I do wrong?

---------
Thank you
      Alex. Karpov

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

Предыдущее
От: "Sriram Dandapani"
Дата:
Сообщение: Re: truncate partitioned table locking
Следующее
От: Tom Lane
Дата:
Сообщение: Re: free space map