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?
>>
>
