Re: Postgres 8.2 binary for ubuntu 6.10? - Mailing list pgsql-general

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.