Package: postgresql Version: 7.4.7-6sarge1 I was unable to install postgresql on Sarge. Reason: initdb: failed
When running initdb as user postgres the same error occured. initdb reports, that error occurs on line 700 of initdb script. There is SQL command creating trigger on pg_shadow relation. Messages from apt-get install postgresql <snip> Unpacking postgresql (from .../postgresql_7.4.7-6sarge1_i386.deb) ... Setting up postgresql (7.4.7-6sarge1) ... Creating config file /etc/postgresql/postmaster.conf with new version Creating missing home directory /var/lib/postgres for postgres The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale en_US.utf8. fixing permissions on existing directory /var/lib/postgres/data... ok creating directory /var/lib/postgres/data/base... ok creating directory /var/lib/postgres/data/global... ok creating directory /var/lib/postgres/data/pg_xlog... ok creating directory /var/lib/postgres/data/pg_clog... ok selecting default max_connections... 100 selecting default shared_buffers... 1000 creating configuration files... ok creating template1 database in /var/lib/postgres/data/base/1... ok initializing pg_shadow... /usr/lib/postgresql/bin/initdb: line 700: cannot create temp file for here document: Permission denied initdb: failed dpkg: error processing postgresql (--configure): subprocess post-installation script returned error exit status 1 Errors were encountered while processing: postgresql E: Sub-process /usr/bin/dpkg returned an error code (1) --- [EMAIL PROTECTED]:~$ uname -a Linux ringer 2.4.27-2-686-smp #1 SMP Mon May 16 16:55:31 JST 2005 i686 GNU/Linux --- All packages (libraries, programs, etc...) are installed using apt or dpkg from STABLE release. No self-compiled stuff on the machine. Regards, Martynas -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
