Hallo Anreas, sorry for the delay!
Andreas Koch [2006-05-29 13:46 +0200]: > [layout on other PC] > Orion:/etc/postgresql/7.4# ls -l > insgesamt 4 > drwxr-xr-x 2 root root 4096 2005-10-13 10:03 main > > Orion:/etc/postgresql/7.4# ls -l main/ > insgesamt 24 > lrwxrwxrwx 1 root root 46 2005-10-13 10:03 autovacuum_log -> > /var/log/postgresql/pg_autovacuum-7.4-main.log > lrwxrwxrwx 1 root root 43 2005-10-13 10:03 log -> > /var/log/postgresql/postgresql-7.4-main.log > lrwxrwxrwx 1 root root 19 2005-10-13 10:03 pgdata -> > /home/postgres/data > -rw-r----- 1 postgres postgres 4986 2005-10-13 10:03 pg_hba.conf > -rw-r----- 1 postgres postgres 1441 2005-10-13 10:03 pg_ident.conf > -rw-r--r-- 1 postgres postgres 9085 2006-05-02 15:28 postgresql.conf This looks fine, that's how it's supposed to be. > gatekeeper:/home$ ls -l /etc/postgresql/7.4 > insgesamt 12 > drwxr-xr-x 2 root root 4096 2006-05-29 12:33 legacy > drwxr-xr-x 2 root root 4096 2006-05-29 12:33 main > drwxr-xr-x 2 root root 4096 2006-05-29 12:33 transition > > gatekeeper:/home$ ls -l /etc/postgresql/7.4/legacy/ > insgesamt 4 > lrwxrwxrwx 1 root root 20 2006-05-29 12:33 pgdata -> /home/server/db_data > -rw-r--r-- 1 root root 378 2006-05-29 12:33 start.conf > > gatekeeper:/home$ ls -l /etc/postgresql/7.4/main/ > insgesamt 0 > lrwxrwxrwx 1 root root 46 2006-05-24 15:14 autovacuum_log -> > /var/log/postgresql/pg_autovacuum-7.4-main.log > lrwxrwxrwx 1 root root 43 2006-05-24 15:14 log -> > /var/log/postgresql/postgresql-7.4-main.log > lrwxrwxrwx 1 root root 20 2006-05-24 15:14 pgdata -> /home/server/db_data > > gatekeeper:/home$ ls -l /etc/postgresql/7.4/transition/ > insgesamt 32 > lrwxrwxrwx 1 root root 52 2006-05-29 12:33 autovacuum_log -> > /var/log/postgresql/pg_autovacuum-7.4-transition.log > -rw-r--r-- 1 root root 316 2006-05-29 12:33 environment > lrwxrwxrwx 1 root root 49 2006-05-29 12:33 log -> > /var/log/postgresql/postgresql-7.4-transition.log > lrwxrwxrwx 1 root root 20 2006-05-29 12:33 pgdata -> > /home/server/db_data > -rw-r----- 1 postgres postgres 4957 2006-05-29 12:33 pg_hba.conf > -rw-r----- 1 postgres postgres 1441 2006-05-29 12:33 pg_ident.conf > -rw-r--r-- 1 postgres postgres 9085 2006-05-29 12:33 postgresql.conf > -rw-r--r-- 1 root root 378 2006-05-29 12:33 start.conf > > gatekeeper:/home$ ls -l /home/postgres/data/ > insgesamt 24 > drwx------ 18 postgres postgres 4096 2006-04-05 17:37 base > drwx------ 2 postgres postgres 4096 2006-05-29 12:33 global > drwx------ 2 postgres postgres 4096 2006-04-06 15:13 pg_clog > -rw------- 1 postgres postgres 4 2006-01-02 09:31 PG_VERSION > drwx------ 2 postgres postgres 4096 2006-05-27 20:11 pg_xlog > -rw------- 1 postgres postgres 116 2006-05-29 12:33 postmaster.opts This indeed looks severely wrecked. It looks like you attempted the upgrade three times (first it created the 'main' cluster, then 'legacy', then 'transition'), and all three failed at some point. Now 'main' and 'legacy' are bogus clusters and 'transition' actually looks good, but the symlinks in /home/postgres/data/ to the configuration files in /etc/postgresql/7.4/transition/ are missing (please add them to get it working again). Can you please describe me how you attempted the first upgrade and what failed? Any recipe for reproducing this? Thank you! Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org In a world without walls and fences, who needs Windows and Gates?
signature.asc
Description: Digital signature
