[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-31 Thread H H
@Martin Pitt >Note that the actual databases are in /var/lib/postgresql/. They >shouldn't have been lost during the upgrade, if you reinstall >postgresql-8.4 it should work just fine. My typo, I had looked for my lost databases in folder /var/lib/postgresql of course, not in /usr/lib/postgresql.

Re: [Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-31 Thread Martin Pitt
H H [2011-10-30 13:12 -]: > After upgrade folder /usr/lib/postgresql/9.1/main/base contains only 3 > databases - template0, template1, postgres. Note that the actual databases are in /var/lib/postgresql/. They shouldn't have been lost during the upgrade, if you reinstall postgresql-8.4 it sh

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-30 Thread H H
Kubuntu 32 bit, upgrade from Natty to Oneirc through do-upgrade. In contrary to previous posts it seems that I have lost 2 databases during upgrade from Natty to Oneiric. After upgrade folder /usr/lib/postgresql/9.1/main/base contains only 3 databases - template0, template1, postgres. There are

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-20 Thread Dmitry Shachnev
Fixed in 1:0.154. ** Changed in: update-manager (Ubuntu Precise) Status: In Progress => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/871893 Title: After upgrading postgresql-da

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-19 Thread Martin Pitt
** Changed in: update-manager (Ubuntu Oneiric) Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/871893 Title: After upgrading postgresql-databases are not a

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-19 Thread Jean-Baptiste Lallement
SRU verification for Oneiric: I have reproduced the problem with update-manager 1:0.152.25 in oneiric and have verified that the version of update-manager 1:0.152.25.4 in -proposed fixes the issue. Marking as verification-done ** Changed in: update-manager (Ubuntu Oneiric) Status: Fix R

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-19 Thread Launchpad Bug Tracker
This bug was fixed in the package update-manager - 1:0.152.25.4 --- update-manager (1:0.152.25.4) oneiric-proposed; urgency=low * DistUpgrade/removal_blacklist.cfg: - ensure that postgresql does not get removed (LP: #871893) update-manager (1:0.152.25.3) oneiric-proposed; urgen

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-19 Thread Martin Pitt
Hello Thomas, or anyone else affected, Accepted update-manager into oneiric-proposed, the package will build now and be available in a few hours. Please test and give feedback here. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to enable and use -proposed. Thank you in a

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-19 Thread Launchpad Bug Tracker
** Branch linked: lp:~ubuntu-core-dev/update-manager/oneiric -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/871893 Title: After upgrading postgresql-databases are not accessible any more To manage n

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-19 Thread Michael Vogt
** Changed in: update-manager (Ubuntu Precise) Status: Triaged => In Progress ** Changed in: update-manager (Ubuntu Oneiric) Status: Triaged => In Progress ** Changed in: update-manager (Ubuntu Oneiric) Assignee: (unassigned) => Michael Vogt (mvo) -- You received this bug not

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-18 Thread Martin Pitt
> Yes, the note is printed. But on a window 132x43 it takes half a second and it is scrolled out of sight. That also sounds weird. It is supposed to be a debconf note which stays on the screen forever until you press Enter. How exactly did you upgrade? With the graphical update program, apt-get, a

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-18 Thread Martin Pitt
Having postgresql-8.4 removed IS a problem indeed, that's not intended to work. It seems it was dropped from update-manager's ./DistUpgrade/removal_blacklist.cfg. Michael, can we please put that back and SRU it quickly? ** Package changed: postgresql-common (Ubuntu) => update-manager (Ubuntu) **

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-18 Thread Thomas Schweikle
>From comment #6 >> The problem is quite simple: while upgrading, postgres-8.4 is replaced by >> postgres-9.1. > > No, it's not. 9.1 gets installed in addition. Sometimes yes, sometimes no. In case of the server in question postgres-8.4 was removed, only the configuration files and databases rema

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-18 Thread Thomas Schweikle
>From comment #2 > The provided error messages are a little too vague. > Can you please give me the output of "pg_lsclusters"? > what happens if you try > > sudo -u postgres psql template1 > > Does this get you into the postgresql console? Since I could find what was going wrong, I managed to mig

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-18 Thread Migs de Villa
I experienced the same thing and freaked when I couldn't access the databases. Same thing, 11.04 upgrade to 11.10. Postgres 8.4 and postgres 9.1 got installed side-by-side. However, if you check the config at /etc/postgresql/9.1/main/postgresql.conf, it listens on port 5433 and postgres8.4 would

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-16 Thread Martin Pitt
> The problem is quite simple: while upgrading, postgres-8.4 is replaced by postgres-9.1. No, it's not. 9.1 gets installed in addition. > The migration described on the postgres project site are not working for Ubuntu: On upgrade you should have gotten a debconf note that describes how to do the

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-15 Thread Thomas Schweikle
The problem is quite simple: while upgrading, postgres-8.4 is replaced by postgres-9.1. The newly installed server ist then started, but without migrating the databases from 8.4 to 9.1 The migration described on the postgres project site are not working for Ubuntu: pg_upgrade is there, but pg_conf

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-14 Thread Dries Cox
I downgraded to 8.4 again sudo apt-get remove postgresql and installed 8.4 sudo apt-get install postgresql-8.4 Now it works perfect again. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/871893 Titl

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-14 Thread Dries Cox
Hello, I've got the same problem. If i do a sudo -u postgres psql template1 i get "psql: could not connect to server: Bestand of map bestaat niet Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?" It looks like the

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-11 Thread Martin Pitt
The provided error messages are a little too vague. Can you please give me the output of "pg_lsclusters"? what happens if you try sudo -u postgres psql template1 Does this get you into the postgresql console? If not, what's the output? ** Changed in: postgresql-common (Ubuntu) Status: N

[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

2011-10-10 Thread Thomas Schweikle
-- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/871893 Title: After upgrading postgresql-databases are not accessible any more To manage notifications about this bug go to: https://bugs.launchpad.net/