Обсуждение: Troubles with starting postgresql

Поиск
Список
Период
Сортировка

Troubles with starting postgresql

От
"Alex. N. Karpov"
Дата:
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

Re: Troubles with starting postgresql

От
Tom Lane
Дата:
"Alex. N. Karpov" <ank@spy.isp.nsc.ru> writes:
> 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

Sounds a lot like
http://archives.postgresql.org/pgsql-general/2005-11/msg01354.php
although the specific missing packages might be different for Debian.

Another possibility is that you have an incorrect setting of LANG
in the postmaster's environment.

            regards, tom lane