Package: postgresql
Version: 7.4.7-6sarge1
Severity: grave
Justification: renders package unusable
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
Note re postgresql error:
Got this error after rebooting. Prior to rebooting had done a backup
which had dump_all'd the database and that file looks fine.
Copied the log to the working directory, don't see anything amiss.
Try starting again, still get the error message. The FATAL log message
is repeated every time I try to start postgresql; note that no time is
logged.
The shutdown started, according to syslog at 18:05:45, and kernel log daemon
exited at 18:06:04, restarting at 18:12:00. (after full file system check).
Here's the output from mount and df:
/dev/hda5 on / type ext3 (rw,errors=remount-ro)
proc on /proc type proc (rw)
sysfs on /sys type sysfs (rw)
devpts on /dev/pts type devpts (rw,gid=5,mode=620)
tmpfs on /dev/shm type tmpfs (rw)
/dev/hda1 on /boot type ext3 (rw)
/dev/hda6 on /home type reiserfs (rw)
/dev/hdc1 on /tmp type reiserfs (rw)
/dev/hdc5 on /usr type reiserfs (rw)
/dev/hdc6 on /var type reiserfs (rw)
usbfs on /proc/bus/usb type usbfs (rw)
bulwark:/var/mail on /var/mail type nfs
(rw,fg,hard,intr,rsize=8192,wsize=8192,addr=192.168.1.1)
bulwark:/usr on /mnt/bulwark/usr type nfs
(rw,noexec,nosuid,nodev,bg,hard,intr,rsize=8192,wsize=8192,addr=192.168.1.1)
Filesystem Size Used Avail Use% Mounted on
/dev/hda5 96M69M23M 75% /
tmpfs 32M 032M 0% /dev/shm
/dev/hda1 16M 8.0M 7.3M 53% /boot
/dev/hda6 1.2G 133M 1.1G 12% /home
/dev/hdc1 1.1G34M 987M 4% /tmp
/dev/hdc5 2.1G 1.4G 702M 66% /usr
/dev/hdc6 3.4G 885M 2.5G 27% /var
bulwark:/var/mail 189M62M 128M 33% /var/mail
bulwark:/usr 131M86M45M 66% /mnt/bulwark/usr
I didn't sit and watch the file system check.
Try shutdown -hF (maybe its a power thing) and watch the boot up.
No help. Check debian web site for bug reporting stuff.
installing report bug. Checking aptitude, we have postgresql
7.4.7-6sarge1
Here's the log file:
2006-01-17 09:53:19 [16457] LOG: connection received: host=[local] port=
2006-01-17 09:53:19 [16457] LOG: connection authorized: user=postgres
database=template1
2006-01-17 09:53:23 [16460] LOG: connection received: host=[local] port=
2006-01-17 09:53:23 [16460] LOG: connection authorized: user=postgres
database=house
2006-01-17 09:53:33 [16463] LOG: connection received: host=[local] port=
2006-01-17 09:53:34 [16463] LOG: connection authorized: user=postgres
database=template1
2006-01-17 10:02:05 [16689] LOG: connection received: host=[local] port=
2006-01-17 10:02:05 [16689] LOG: connection authorized: user=postgres
database=template1
2006-01-17 10:02:08 [16699] LOG: connection received: host=[local] port=
2006-01-17 10:02:08 [16699] LOG: connection authorized: user=postgres
database=template1
2006-01-17 10:02:08 [16700] LOG: connection received: host=[local] port=
2006-01-17 10:02:08 [16700] LOG: connection authorized: user=postgres
database=house
2006-01-17 10:02:43 [16714] LOG: connection received: host=[local] port=
2006-01-17 10:02:44 [16714] LOG: connection authorized: user=postgres
database=template1
2006-01-17 15:02:02 [17499] LOG: connection received: host=[local] port=
2006-01-17 15:02:02 [17499] LOG: connection authorized: user=postgres
database=template1
2006-01-17 15:02:04 [17509] LOG: connection received: host=[local] port=
2006-01-17 15:02:04 [17509] LOG: connection authorized: user=postgres
database=template1
2006-01-17 15:02:04 [17510] LOG: connection received: host=[local] port=
2006-01-17 15:02:04 [17510] LOG: connection authorized: user=postgres
database=house
2006-01-17 15:02:16 [17511] LOG: connection received: host=[local] port=
2006-01-17 15:02:16 [17511] LOG: connection authorized: user=postgres
database=template1
2006-01-17 18:05:58 [2081] LOG: received fast shutdown request
2006-01-17 18:05:58 [18431] LOG: shutting down
2006-01-17 18:06:01 [18431] LOG: database system is shut down
FATAL: XX000: failed to initialize lc_messages to
LOCATION: InitializeGUCOptions, guc.c:1867
FATAL: XX000: failed to initialize lc_messages to
LOCATION: InitializeGUCOptions, guc.c:1867
FATAL: XX000: failed to initialize lc_messages to
LOCATION: InitializeGUCOptions, guc.c:1867
FATAL: XX000: failed to initialize lc_messages to