Lost access after upgrading from pg_8.1 to 8.3 on (Debian/Lenny) powerpc - Mailing list pgsql-novice

Hi all!

I had a working postgresql_8.1 version but having switched to
'Debian/Lenny (testing), decided to install the newer one; so I did:
# apt-get install postgresql
Then made various attempts to upgrade the clusters (as I could not clearly
 understand the suggestion made by the install dialog):
# pg_upgradecluster
# pg_upgradecluster -v 8.3
# man pg_upgradecluster
# pg_upgradecluster postgresql-8.3
# ls /var/lib/post*/8.3/main
# ls /var/lib/post*/8.1/main
# pg_upgradecluster -v postgresql-8.3 postgresql-8.1 8.3/main /var/lib/postgresql
# pg_upgradecluster -v postgresql-8.3 postgresql-8.1 8.3 /var/lib/postgresql
# pg_upgradecluster -v postgresql-8.3 postgresql-8.1  /var/lib/postgresql/8.3/main
# reboot
# pg_upgradecluster -v postgresql-8.3 postgresql-8.1
# pg_upgradecluster -v postgresql-8.3 postgresql-8.1  /var/lib/postgresql/8.3
# pg_upgradecluster -v postgresql-8.3 postgresql-8.1  /var/lib/postgresql/8.3/main
# pg_upgradecluster 8.3 main
# pg_dropcluster 8.1 main

_and finally, the correct one_:

# pg_dropcluster 8.1 main --stop

[There was no output information/warnings on the console and, after
googling a while, I think there should be some]

At this point, on the assumption (after running partially my own script) that
everything worked as before, I removed old 8.1:

# apt-get remove postgresql-8.1 postgresql-client-8.1

I shouldn't have done that, because when I tried again to connect to my databse
I got strange warnings like:

2008-02-11 18:43:00 CET LOG:  could not load root certificate file "root.crt":
  no SSL error reported 2008-02-11 18:43:00 CET DETAIL:  Will not verify client
  certificates.
2008-02-11 18:43:00 CET LOG:  database system was shut down at 2008-02-11
  18:41:01 CET 2008-02-11 18:43:00 CET LOG:  incomplete startup packet
2008-02-11 18:43:00 CET LOG:  autovacuum launcher started
2008-02-11 18:43:00 CET LOG:  database system is ready to accept connections
2008-02-11 20:02:02 CET LOG:  incomplete startup packet
2008-02-12 01:34:17 CET FATAL:  Ident authentication failed for user "ennio"
2008-02-12 15:02:02 CET LOG:  incomplete startup packet
......
2008-02-12 18:51:08 CET LOG:  incomplete startup packet
2008-02-12 18:59:17 CET FATAL:  Ident authentication failed for user "ennio"
2008-02-12 19:11:09 CET FATAL:  Ident authentication failed for user "finanza"
2008-02-12 19:11:19 CET FATAL:  Ident authentication failed for user "root"
2008-02-12 19:11:47 CET FATAL:  database "finanza" does not exist
2008-02-12 19:14:47 CET FATAL:  database "ennio" does not exist
2008-02-12 19:14:54 CET FATAL:  database "finanza" does not exist
2008-02-12 19:21:34 CET LOG:  incomplete startup packet
2008-02-12 19:24:55 CET LOG:  incomplete startup packet
2008-02-12 19:30:36 CET FATAL:  database "finanza" does not exist
2008-02-12 19:30:42 CET FATAL:  database "ennio" does not exist
2008-02-12 19:30:57 CET FATAL:  database "mydb" does not exist
2008-02-12 20:02:02 CET LOG:  incomplete startup packet
......
2008-02-13 15:07:44 CET LOG:  incomplete startup packet
2008-02-13 15:07:45 CET LOG:  received fast shutdown request
2008-02-13 15:07:45 CET LOG:  aborting any active transactions
2008-02-13 15:07:45 CET LOG:  autovacuum launcher shutting down
2008-02-13 15:07:45 CET LOG:  shutting down
2008-02-13 15:07:45 CET LOG:  database system is shut down

Now the situation is as follows:

# ls -a /var/lib/postgresql/8.3/main

total 44
4 base/     4 pg_multixact/  4 pg_twophase/  4 postmaster.opts  0 server.crt@
4 global/   4 pg_subtrans/   4 PG_VERSION    4 postmaster.pid   0 server.key@
4 pg_clog/  4 pg_tblspc/     4 pg_xlog/      0 root.crt@

# ls -a /var/lib/postgresql/8.3/main/base

total 28
4 1/  4 11510/  4 11511/  4 16385/  4 16386/  4 16387/  4 16388/

# ls -a /var/lib/postgresql/8.3/main/global

total 288
 8 1136  16 1233  16 2397   8 2694   8 2843   4 pg_auth
16 1137   8 1260  16 2671   8 2695   0 2844   8 pg_control
 8 1213   0 1261  16 2672  16 2697   8 2845   4 pg_database
 8 1214   8 1262  16 2676  16 2698   0 2846  24 pgstat.stat
16 1232   8 2396  16 2677   0 2842   8 2847

so I suspect my data are still there, but wouldn't make things worse trying to
access them not knowing exactly how to do that, if possible!

Could you give me some hints?

Thanks for your attention.
Regards,

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.   \\?//
 Fa' qualche cosa di cui non sei capace!"  (diceva Henry Miller) ]    (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that.              )=(
 Do something you aren't good at!" (as Henry Miller used to say) ]