Debian Bug report logs - #705337
postgresql: Error: Could not create log file (fails to start)

Toggle useless messages

Message #5 received at submit@bugs.debian.org (full text, mbox, reply):

From: David M Smith <sidicas2@gmail.com>

To: Debian Bug Tracking System <submit@bugs.debian.org>

Subject: postgresql: Error: Could not create log file (fails to start)

Date: Sat, 13 Apr 2013 18:03:20 +0800

Package: postgresql-9.1
Version: 9.1.9-1
Severity: important

Hello,


I have my /var/log stored on ramdisk/tmpfs so that everytime I reboot, my logs
get wiped Normally that isn't a problem, but for postgresql, it is as
postgresql will not start automatically after reboot..


Aya:/home/david# /etc/init.d/postgresql start
[FAIL] Starting PostgreSQL 9.1 database server: main[....] Error: Could not
create log file /var/log/postgresql/postgresql-9.1-main.log ... failed!
 failed!
Aya:/home/david# mkdir /var/log/postgresql
Aya:/home/david# /etc/init.d/postgresql start
[ ok ] Starting PostgreSQL 9.1 database server: main.
Aya:/home/david#


So everytime I reboot, I need to make a directory for postgres to store it's
log files, not fun!



-- System Information:
Debian Release: 7.0
  APT prefers testing
  APT policy: (500, 'testing'), (2, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.6-trunk-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages postgresql-9.1 depends on:
ii  libc6                  2.13-38
ii  libcomerr2             1.42.5-1.1
ii  libgssapi-krb5-2       1.10.1+dfsg-5
ii  libkrb5-3              1.10.1+dfsg-5
ii  libldap-2.4-2          2.4.31-1
ii  libpam0g               1.1.3-7.1
ii  libpq5                 9.1.9-1
ii  libssl1.0.0            1.0.1e-2
ii  libxml2                2.8.0+dfsg1-7+nmu1
ii  locales                2.13-38
ii  postgresql-client-9.1  9.1.9-1
ii  postgresql-common      134wheezy3
ii  ssl-cert               1.0.32
ii  tzdata                 2013b-2

postgresql-9.1 recommends no packages.

Versions of packages postgresql-9.1 suggests:
pn  locales-all             <none>
pn  oidentd | ident-server  <none>

Message #12 received at 705337-done@bugs.debian.org (full text, mbox, reply):

From: Christoph Berg <myon@debian.org>

To: David M Smith <sidicas2@gmail.com>, 705337-done@bugs.debian.org

Subject: Re: Bug#705337: postgresql: Error: Could not create log file (fails to start)

Date: Fri, 26 Apr 2013 21:12:54 +0200

[Message part 1 (text/plain, inline)]

Version: 140

Re: David M Smith 2013-04-13 <20130413100320.6144.17185.reportbug@MrQ>
> I have my /var/log stored on ramdisk/tmpfs so that everytime I reboot, my logs
> get wiped Normally that isn't a problem, but for postgresql, it is as
> postgresql will not start automatically after reboot..

Hi,

thanks for the report.

This was already fixed in the postgresql-common version in
experimental. As wheezy is close to the release, we won't make changes
to the package in there anymore, so this will unfortunately remain
unfixed there.

As a wheezy user, you can install the package from experimental to get
the fix, or install it from apt.postgresql.org.

For a hotfix, you can edit /etc/init.d/postgresql to add a mkdir call.

(Fwiw, /var/log is not among the directories that strictly need to
support being on volatile storage (see /var/run), so this problem
isn't an FHS/policy violation.)

Christoph
-- 
cb@df7cb.de | http://www.df7cb.de/

[signature.asc (application/pgp-signature, inline)]

Send a report that this bug log contains spam.