Bug#314585: postgresql-8.0: postgresql does not start at installation

2005-06-17 Thread Erwan David
Package: postgresql-8.0
Version: 8.0.3-5
Severity: important


When installing postgresql-8.0 I get the following errors :

sh: /var/log/postgresql/postgresql-8.0-main.log: Permission non accorde
The PostgreSQL server failed to start. Please check the log output:
Error: Could not open log file /var/log/postgresql/postgresql-8.0-main.log
invoke-rc.d: initscript postgresql-8.0, action start failed

Same message error for the action autovac-start triggered by
postgresql-contrib-8.0

-- System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.11-1-k7
Locale: LANG=C, [EMAIL PROTECTED] (charmap=ISO-8859-15)

Versions of packages postgresql-8.0 depends on:
ii  libc6   2.3.2.ds1-22 GNU C Library: Shared libraries an
ii  libcomerr2  1.37+1.38-WIP-0509-1 common error description library
ii  libkrb531.3.6-3  MIT Kerberos runtime libraries
ii  libpam0g0.76-22  Pluggable Authentication Modules l
ii  libpq4  8.0.3-5  PostgreSQL C client library
ii  libreadline55.0-10   GNU readline and history libraries
ii  libssl0.9.7 0.9.7g-1 SSL shared libraries
ii  postgresql-client-8 8.0.3-5  front-end programs for PostgreSQL 
ii  postgresql-common   17   manager for PostgreSQL database cl
ii  zlib1g  1:1.2.2-4compression library - runtime

postgresql-8.0 recommends no packages.

Versions of packages postgresql-8.0 is related to:
ii  reportbug 3.13   reports bugs in the Debian distrib
pn  totem-gstreamer   none (no description available)

-- no debconf information



Bug#314585: postgresql-8.0: postgresql does not start at installation

2005-06-17 Thread Martin Pitt
Hi!

Erwan David [2005-06-17 11:30 +0200]:
 When installing postgresql-8.0 I get the following errors :
 
 sh: /var/log/postgresql/postgresql-8.0-main.log: Permission non accorde
 The PostgreSQL server failed to start. Please check the log output:
 Error: Could not open log file /var/log/postgresql/postgresql-8.0-main.log
 invoke-rc.d: initscript postgresql-8.0, action start failed
 
 Same message error for the action autovac-start triggered by
 postgresql-contrib-8.0

Can you please show me the output of

$ id postgres
$ ls -la /var/log/postgresql
$ ls -l /etc/postgresql/8.0/main
$ pg_lsclusters

Thanks!

Martin
-- 
Martin Pitthttp://www.piware.de
Ubuntu Developer   http://www.ubuntu.com
Debian Developer   http://www.debian.org


signature.asc
Description: Digital signature


Bug#314585: postgresql-8.0: postgresql does not start at installation

2005-06-17 Thread Erwan David
Le 17.06.2005 12:00, Martin Pitt a crit:
 Hi!
 
 Erwan David [2005-06-17 11:30 +0200]:
 
When installing postgresql-8.0 I get the following errors :

sh: /var/log/postgresql/postgresql-8.0-main.log: Permission non accorde
The PostgreSQL server failed to start. Please check the log output:
Error: Could not open log file /var/log/postgresql/postgresql-8.0-main.log
invoke-rc.d: initscript postgresql-8.0, action start failed

Same message error for the action autovac-start triggered by
postgresql-contrib-8.0
 
 
 Can you please show me the output of
 
 $ id postgres

uid=118(postgres) gid=118(postgres) groups=118(postgres)

 $ ls -la /var/log/postgresql

drwxrwx---   2   31   32 4096 Jun 17 11:24 .
drwxr-xr-x  15 root root 4096 Jun 17 06:27 ..
-rw-r--r--   1   31   320 Jun  1 06:27 autovacuum_log
-rw-r--r--   1   31   32 2594 Jun  1 06:27 autovacuum_log.1
-rw-r--r--   1   31   32  341 Apr 13 06:25 autovacuum_log.10.gz
-rw-r--r--   1   31   32  340 Jun  1 06:27 autovacuum_log.2.gz
-rw-r--r--   1   31   32  341 May 23 06:27 autovacuum_log.3.gz
-rw-r--r--   1   31   32  340 May 17 06:26 autovacuum_log.4.gz
-rw-r--r--   1   31   32  664 May  9 06:26 autovacuum_log.5.gz
-rw-r--r--   1   31   32  341 May  3 06:27 autovacuum_log.6.gz
-rw-r--r--   1   31   32  340 Apr 27 06:27 autovacuum_log.7.gz
-rw-r--r--   1   31   32  341 Apr 18 06:27 autovacuum_log.8.gz
-rw-r--r--   1   31   32  341 Apr 15 06:25 autovacuum_log.9.gz
-rw-rw   1 postgres postgres0 Jun 17 11:24
pg_autovacuum-8.0-main.log
-rw-rw   1 postgres postgres0 Jun 17 11:24 postgresql-8.0-main.log


 $ ls -l /etc/postgresql/8.0/main

 ls -l /etc/postgresql/8.0/main
total 20
lrwxrwxrwx  1 root root46 Jun 17 11:24 autovacuum_log -
/var/log/postgresql/pg_autovacuum-8.0-main.log
lrwxrwxrwx  1 root root43 Jun 17 11:24 log -
/var/log/postgresql/postgresql-8.0-main.log
-rw-r-  1 postgres postgres  3588 Jun 17 11:24 pg_hba.conf
-rw-r-  1 postgres postgres  1460 Jun 17 11:24 pg_ident.conf
lrwxrwxrwx  1 root root28 Jun 17 11:24 pgdata -
/var/lib/postgresql/8.0/main
-rw-r--r--  1 postgres postgres 11020 Jun 17 11:24 postgresql.conf




 $ pg_lsclusters

Version Cluster   Port Status OwnerData directory
8.0 main  5432 down   postgres /var/lib/postgresql/8.0/main

Log File
/var/log/postgresql/postgresql-8.0-main.log


Ok,  I see this 31-32 in /var/log/postgresql.

It may come I used to have postgresql 7.4 which I purged some time ago.

-- 
Erwan