Package: postgresql-common Version: 87 Severity: normal Terminal excerpt: --------------------------------------------- # cp -a /oldvar/lib/postgresql/8.1/main /var/lib/postgresql/8.1/wheat # chown -R postgres:postgres /var/lib/postgresql/8.1/wheat # pg_createcluster -d /var/lib/postgresql/8.1/wheat 8.1 wheat Configuring already existing cluster (configuration: /etc/postgresql/8.1/wheat, data: /var/lib/postgresql/8.1/wheat, owner: 107:122) Error: move_conffile: required configuration file /var/lib/postgresql/8.1/wheat/postgresql.conf does not exist ------------------------------------------------
The directory in /oldvar was from a disk on a system that died. /etc/postgresql/8.1/wheat did not exist after the previous steps. pg_createcluster includes the lines ------------------------------------------------ # move conffiles, setup permissions move_conffile "$datadir/postgresql.conf", $confdir, $owneruid, $ownergid, '644'; move_conffile "$datadir/pg_hba.conf", $confdir, $owneruid, $ownergid, '640', 'hba_file'; move_conffile "$datadir/pg_ident.conf", $confdir, $owneruid, $ownergid, '640', 'ident_file'; ------------------------------------------------ None of these files are present in the data directory; I do not see them in other clusters I have set up either. I may be misunderstanding something, but is the code trying to move some files that are only created by db_init for new clusters? How can I make this work? The data are for taxes which are due in 2 days! I'm hoping to pg_upgradecluster or pg_dump to move them to 8.3 on my current system. As I understand it, I first need to get 8.1 running for the old databases to get the information out. -- System Information: Debian Release: lenny/sid APT prefers testing APT policy: (990, 'testing'), (990, 'stable'), (50, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.18-6-686 (SMP w/2 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages postgresql-common depends on: ii adduser 3.107 add and remove users and groups ii debconf [debconf-2.0] 1.5.20 Debian configuration management sy ii lsb-base 3.1-24 Linux Standard Base 3.1 init scrip ii postgresql-client-common 87 manager for multiple PostgreSQL cl ii procps 1:3.2.7-6 /proc file system utilities ii ssl-cert 1.0.17 simple debconf wrapper for OpenSSL postgresql-common recommends no packages. -- debconf information: * postgresql-common/obsolete-major: postgresql-common/untransitioned: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]