[Bug 476012] New: PostgreSQL appears to have been compiled without some instrumentation capabilities

https://bugzilla.novell.com/show_bug.cgi?id=476012 Summary: PostgreSQL appears to have been compiled without some instrumentation capabilities Classification: openSUSE Product: openSUSE 11.1 Version: Final Platform: x86-64 OS/Version: openSUSE 11.1 Status: NEW Severity: Enhancement Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: znmeb@cesmail.net QAContact: qa@suse.de Found By: --- User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.6) Gecko/2009012700 SUSE/3.0.6-0.1.2 Firefox/3.0.6 I installed PostgreSQL out of the server:database:postgresql repository. The version is 8.3.5-2.1 (x86_64). PostgreSQL has some instrumentation that can be compiled in. When I open the database in pgAdmin III I get this message: ------------------------------------------------------------------------------- Server instrumentation The server lacks instrumentation functions. pgAdmin III uses some support functions that are not available by default in all PostgreSQL versions. These enable some tasks that make life easier when dealing with log files and configuration files. When you install PostgreSQL 8.0 or up using the Windows installer, you just need to select the "admin" or "adminpack" module.c When compiling from source, the necessary files can be found in the xtra subdirectory of the pgAdmin source tree. For PostgreSQL 8.0, copy the admin directory under the postgresql contrib source directory, make and make install from there. For PostgreSQL 8.1, use the admin81 directory for that. PostgreSQL 8.2 and above include the instrumentation functions in the "adminpack" contrib module. After the module is installed, you need to create the instrumentation functions in your maintenance database using the admin.sql script (admin81.sql for PostgreSQL 8.1) which are usually located in the pgsql share directory (e.g. /usr/local/pgsql/share) Extended server instrumentation is not supported for PostgreSQL 7.3 and 7.4. ------------------------------------------------------------------------------- I do a lot of work with PostgreSQL, and I'd like to have this functionality. I will probably end up installing from raw upstream source if I can figure out how to make all the dependencies work, but meanwhile, it would be nice if openSUSE / SUSE Linux in general supported all the capabilities of PostgreSQL out of the box. Reproducible: Always Steps to Reproduce: 1. Install PostgreSQL and pgAdmin III 2. Connect to the database from pgAdmin III -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=476012 User znmeb@cesmail.net added comment https://bugzilla.novell.com/show_bug.cgi?id=476012#c1 --- Comment #1 from M. Edward (Ed) Borasky <znmeb@cesmail.net> 2009-02-15 11:12:41 MST --- P.S.: PostgreSQL 8.4 is close to release -- IIRC it's due in March 2009. So you can probably pick this up in the process of packaging 8.4. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=476012 Michal Marek <mmarek@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mmarek@novell.com AssignedTo|bnc-team-screening@forge.pr |max@novell.com |ovo.novell.com | -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=476012 User max@novell.com added comment https://bugzilla.novell.com/show_bug.cgi?id=476012#c2 Reinhard Max <max@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - None |P4 - Low Status|NEW |RESOLVED Resolution| |INVALID --- Comment #2 from Reinhard Max <max@novell.com> 2009-02-18 07:37:08 MST --- Everything from contrib that the PostgreSQL build system builds and installs by default is contained in the postgresql-admin RPM package. We will, however, not enable anything from there for PostgreSQL installations by default, because these are optional extension that are not part of the PostgreSQL core. But you can easily enable the adminpack module yourself for any database by running the /usr/share/postgresql/contrib/adminpack.sql script against that database with the psql command line tool. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply@novell.com