Lost access after upgrading from pg_8.1 to 8.3 on (Debian/Lenny) powerpc

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: Lost access after upgrading from pg_8.1 to 8.3 on (Debian/Lenny) powerpc
Date: 2008-02-18 18:27:55
Message-ID: 20080218182754.GA9616@deby.ei.hnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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) ]

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2008-02-18 18:55:32 Re: postgres 8.3 & ident authentication
Previous Message Vishal Mailinglist 2008-02-18 15:49:46 Using Regular expresion