pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Troubles with starting postgresql
2+ messages / 2 participants
[nested] [flat]

* Troubles with starting postgresql
@ 2006-06-20 15:02 Alex. N. Karpov <ank@spy.isp.nsc.ru>
  2006-06-20 16:59 ` Re: Troubles with starting postgresql Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Alex. N. Karpov @ 2006-06-20 15:02 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Troubles with starting postgresql
  2006-06-20 15:02 Troubles with starting postgresql Alex. N. Karpov <ank@spy.isp.nsc.ru>
@ 2006-06-20 16:59 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2006-06-20 16:59 UTC (permalink / raw)
  To: Alex. N. Karpov <ank@spy.isp.nsc.ru>; +Cc: pgsql-admin

"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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-06-20 16:59 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-20 15:02 Troubles with starting postgresql Alex. N. Karpov <ank@spy.isp.nsc.ru>
2006-06-20 16:59 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox