pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTroubles 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>
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 16:59 Tom Lane <tgl@sss.pgh.pa.us>
parent: Alex. N. Karpov <ank@spy.isp.nsc.ru>
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