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