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. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
