Postgres 8.2 binary for ubuntu 6.10?

On 10.07.2007 03:09, novnov wrote:

I have postgres 8.1 installed on ubuntu 6.10 via synapic package manager. I
would like to install 8.2, but it's not offered in the list. I think 8.2 is
offered on 7.x ubuntu, and I wonder if 8.2 will be offered on 6.10? Probably
the recommondation will be to compile 8.2 on 6.10, but I've only used binary
installations on linux and am not eager to open up another can of worms.

I might be missing something, but why can't you just grab the package
from sites like this:

http://rpmseek.com/rpm-pl/postgresql-8.2.html?hl=de&cx=824%3AP%3A0%3A0%3A0%3A0%3A0&qDnStr=109&qArStr=1&qRtStr=2

and install it?

--
Regards,
Hannes Dorbath

On 10 Jul 2007 at 9:13, Hannes Dorbath wrote:

On 10.07.2007 03:09, novnov wrote:

I have postgres 8.1 installed on ubuntu 6.10 via synapic package manager. I
would like to install 8.2, but it's not offered in the list. I think 8.2 is
offered on 7.x ubuntu, and I wonder if 8.2 will be offered on 6.10? Probably
the recommondation will be to compile 8.2 on 6.10, but I've only used binary
installations on linux and am not eager to open up another can of worms.

Use ubuntu backports. Add:

deb http://archive.ubuntu.com/ubuntu edgy-backports main restricted
universe multiverse

to /etc/apt/sources.list (by using sudo gedit /etc/apt/sources.list)

The newer postgres versions will be available (I think 8.2.4 is there at
the moment). For more info check out the ubuntu backports forum at:
http://ubuntuforums.org/forumdisplay.php?f=47

HTH

Le mardi 10 juillet 2007, novnov a écrit :

I have postgres 8.1 installed on ubuntu 6.10 via synapic package manager. I
would like to install 8.2, but it's not offered in the list. I think 8.2 is
offered on 7.x ubuntu, and I wonder if 8.2 will be offered on 6.10?
Probably the recommondation will be to compile 8.2 on 6.10, but I've only
used binary installations on linux and am not eager to open up another can
of worms.

You can backport PostgreSQL on debian platforms quite easily, as related here:
http://archives.postgresql.org/pgsql-general/2007-05/msg00427.php

But using the backports as given on another post is still easier, and provides
automatic upgrades of minor versions. Just though you might be interrested in
how to easily recompile a postgresql package under your system. Think about
replacing the deb-src sid target by ubuntu feisty (or newer, don't know) one.

Regards,
--
dim

On 7/9/07, novnov <novnovice@gmail.com> wrote:

I have postgres 8.1 installed on ubuntu 6.10 via synapic package manager. I
would like to install 8.2, but it's not offered in the list. I think 8.2 is
offered on 7.x ubuntu, and I wonder if 8.2 will be offered on 6.10? Probably
the recommondation will be to compile 8.2 on 6.10, but I've only used binary
installations on linux and am not eager to open up another can of worms.

In a way I would like to move to the later ubuntu distro. But I'm concerned
that since my eventual deploy may be on something fairly barebones like
centos, it might be good to stay with the somewhat less polished version of
ubuntu...not sure if there is any value in this approach, but it's hard to
make good choices when one has so little exposure to what the various
options mean.
--
View this message in context: http://www.nabble.com/Postgres-8.2-binary-for-ubuntu-6.10--tf4053274.html#a11513301
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

There won't be a release for postgresql 8.2 for ubuntu 6.10
you can :
1 upgrade to ubuntu feisty with sudo "update-manager -c -d"
2 request a backport
3 do the backport yourserf
4 compile from source

--
Leonel

Thanks all of you. It does seem like the backport is the way to go.

So now I have 8.2 and some new postgres/linux newb questions.

I can safely remove 8.1 after moving data using synaptic, ie 8.2 shouldn't
be dependent on 8.1 at all?

I don't understand how postgres is installed with these package managers.
The windows installer asks me for the superuser name (postgres is the
default) and I provide a password. There is an option to run as a service,
and a windows user acct can be created for that. After the synaptic install,
postgres seems to be running as a service. I see a postgres user account is
created 'postgres' but don't know what the password is?

Finally, I've never been able to get pgadmin to work on linux. I can't
connect, probably because the password is unknown, but another question is
the host address, is localhost is ok?
--
View this message in context: http://www.nabble.com/Postgres-8.2-binary-for-ubuntu-6.10--tf4053274.html#a11526007
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

On Tue, Jul 10, 2007 at 10:50:39AM -0700, novnov wrote:

Thanks all of you. It does seem like the backport is the way to go.

So now I have 8.2 and some new postgres/linux newb questions.

I can safely remove 8.1 after moving data using synaptic, ie 8.2 shouldn't
be dependent on 8.1 at all?

I don't understand how postgres is installed with these package managers.
The windows installer asks me for the superuser name (postgres is the
default) and I provide a password. There is an option to run as a service,
and a windows user acct can be created for that. After the synaptic install,
postgres seems to be running as a service. I see a postgres user account is
created 'postgres' but don't know what the password is?

Finally, I've never been able to get pgadmin to work on linux. I can't
connect, probably because the password is unknown, but another question is
the host address, is localhost is ok?

Show the doc in /usr/share/doc/postgresql* for details.
If pgadmin runs on the same machine then localhost is your choice.
Don't forget to edit the pg_hda.conf under your data-dir (ex.
/var/lib/pgsql or so).

Greetings
Mario

--
-----------------------------------------------------
| havelsoft.com - Ihr Service Partner für Open Source |
| Tel: 033876-21 966 |
| Notruf: 0173-277 33 60 |
| http://www.havelsoft.com |
| |
| Inhaber: Mario Günterberg |
| Mützlitzer Strasse 19 |
| 14715 Märkisch Luch |
-----------------------------------------------------

Just a word of advice... unless you plan to spend lots of time on your
db (like you want to think about it more than twice a week sort of
thing...), just go with what you have in terms of the distro. We are
running 8.1.4. And it just works, yes, even after all this time! You
are certainly behind a good firewall, so if you have X.X.X, and it
works (ie, your developpers have certified for X.X.X), why think about
having the latest? Upgrading to new versions may well expose problems
(like I remember someone talking about query optimisations a while
back) that are non issues. If you are going to be pushing the limits,
then compiling your own versions is not going to be an issue...
Just my 2c
Cheers
Anton
ps. I know, when a new version comes out so often it is soooooooooo
hard to resist!

On 11.07.2007 23:07, Anton Melser wrote:

Just a word of advice... unless you plan to spend lots of time on your
db (like you want to think about it more than twice a week sort of
thing...), just go with what you have in terms of the distro. We are
running 8.1.4. And it just works, yes, even after all this time! You
are certainly behind a good firewall, so if you have X.X.X, and it
works (ie, your developpers have certified for X.X.X), why think about
having the latest? Upgrading to new versions may well expose problems
(like I remember someone talking about query optimisations a while
back) that are non issues. If you are going to be pushing the limits,
then compiling your own versions is not going to be an issue...
Just my 2c
Cheers
Anton
ps. I know, when a new version comes out so often it is soooooooooo
hard to resist!

Well, a good reason for upgrades are fixed bugs, and as minor releases
focus on that, there is a good reason to stay half way up-to-date within
the branch you are using.

This god like faith of some admins in package maintainers, that they
know what's right, good and stable for them, sometimes really worries me.

Besides that.. I'd really expect my distribution to offer me the choice
of what version of PostgreSQL to install.

--
Regards,
Hannes Dorbath

On Thu, Jul 12, 2007 at 09:04:38AM +0200, Hannes Dorbath wrote:

This god like faith of some admins in package maintainers, that they
know what's right, good and stable for them, sometimes really worries me.

The problem is the mismatch between what distrbuters want and what the
postgres team wants. For distributors "stable" means no behavioural
changes, whereas the postgresql team does bug fixes, some of which
definitly make behavioural changes that would make previously working
programs break.

Backports is usually a good compromise.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Martijn van Oosterhout <kleptog@svana.org> writes:

On Thu, Jul 12, 2007 at 09:04:38AM +0200, Hannes Dorbath wrote:

This god like faith of some admins in package maintainers, that they
know what's right, good and stable for them, sometimes really worries me.

The problem is the mismatch between what distrbuters want and what the
postgres team wants. For distributors "stable" means no behavioural
changes, whereas the postgresql team does bug fixes, some of which
definitly make behavioural changes that would make previously working
programs break.

I think we have a pretty good track record of not doing that except when
it's forced by a need to plug a security hole.

However, distributors certainly have more constraints than one could
wish. For instance, at Red Hat I can't just push a new Postgres update
into RHEL releases at my whim --- there are company constraints based on
available QA resources and suchlike. So sometimes the RHEL version of
PG lags behind the community version just because of manpower/scheduling
issues. They have been pretty good about letting me push security
updates promptly, though.

regards, tom lane

I installed 8.2 on ubuntu 6.10 using the backport a while ago. In pgadmin III
I still can't connect to the server settings. When I open server status in
pgadmin on the ubuntu box, it first messages me that server instrumentation
functions are missing and then presents what may be a subset of the server
status. The dialog is for 8.2, 8.1 is no longer installed. But everything
I've read indicates that 8.2 should include what's needed. Using the
synaptic manager I see that postgresql 8.2, -client-8.2, -client-common,
-common, -contrib-8.2 are installed...is there one missing that would bring
the extended server status functionality with it?

novnov wrote:

Thanks all of you. It does seem like the backport is the way to go.

So now I have 8.2 and some new postgres/linux newb questions.

I can safely remove 8.1 after moving data using synaptic, ie 8.2 shouldn't
be dependent on 8.1 at all?

I don't understand how postgres is installed with these package managers.
The windows installer asks me for the superuser name (postgres is the
default) and I provide a password. There is an option to run as a service,
and a windows user acct can be created for that. After the synaptic
install, postgres seems to be running as a service. I see a postgres user
account is created 'postgres' but don't know what the password is?

Finally, I've never been able to get pgadmin to work on linux. I can't
connect, probably because the password is unknown, but another question is
the host address, is localhost is ok?

--
View this message in context: http://www.nabble.com/Postgres-8.2-binary-for-ubuntu-6.10--tf4053274.html#a12009767
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

You may import the adminpack.sql come with the -contrib-8.2 package
to create those administrative functions.

Regards

novnov wrote:

Thanks Ian that helped.

Couple related questions. #1, the same warning is issued by pgadmin III but
the extra instrumentation does seem to have been installed by adminpack.sql;
I can see server status on the ubuntu box from an admin tool installed on a
windows box, where I couldn't before.

#2 I was able to find the adminpack.sql file on a windows postgres install
easily. But where is that share/contrib folder on linux? I looked in the etc
folder and then in the var/lib/ etc folders and it wasn't in those
locations. I searched the disk and didn't find it. postgresql-contrib-8.2
was installed by synaptic.

李彦 Ian Li wrote:

You may import the adminpack.sql come with the -contrib-8.2 package
to create those administrative functions.

Regards

novnov wrote:

I installed 8.2 on ubuntu 6.10 using the backport a while ago. In pgadmin
III
I still can't connect to the server settings. When I open server status
in
pgadmin on the ubuntu box, it first messages me that server
instrumentation
functions are missing and then presents what may be a subset of the
server
status. The dialog is for 8.2, 8.1 is no longer installed. But everything
I've read indicates that 8.2 should include what's needed. Using the
synaptic manager I see that postgresql 8.2, -client-8.2, -client-common,
-common, -contrib-8.2 are installed...is there one missing that would
bring
the extended server status functionality with it?

novnov wrote:

Thanks all of you. It does seem like the backport is the way to go.

So now I have 8.2 and some new postgres/linux newb questions.

I can safely remove 8.1 after moving data using synaptic, ie 8.2
shouldn't
be dependent on 8.1 at all?

I don't understand how postgres is installed with these package
managers.
The windows installer asks me for the superuser name (postgres is the
default) and I provide a password. There is an option to run as a
service,
and a windows user acct can be created for that. After the synaptic
install, postgres seems to be running as a service. I see a postgres
user
account is created 'postgres' but don't know what the password is?

Finally, I've never been able to get pgadmin to work on linux. I can't
connect, probably because the password is unknown, but another question
is
the host address, is localhost is ok?

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

--
View this message in context: http://www.nabble.com/Postgres-8.2-binary-for-ubuntu-6.10--tf4053274.html#a12014777
Sent from the PostgreSQL - general mailing list archive at Nabble.com.