# emerge -uv1ND dev-db/pgadmin3 These are the packages that would be merged, in order: Calculating dependencies... done! [ebuild U ] dev-db/pgadmin3-1.10.1 [1.10.0] USE="-debug" 0 kB Total: 1 package (1 upgrade), Size of downloads: 0 kB ... x86_64-pc-linux-gnu-g++ -DHAVE_CONFIG_H -I. -I.. -I/usr/include/postgresql/libpq-4 -DSSL -I/usr/lib64/wx/include/gtk2-unicode-release-2.8 -I/usr/include/wx-2.8 -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -D__WXGTK__ -O2 -DEMBED_XRC -I/usr/include/libxml2 -I/usr/include/libxml2 -DDATA_DIR=\"/usr/share/pgadmin3/\" -Wall -Wno-non-virtual-dtor -fno-strict-aliasing -I../pgadmin/include -MT dlgSchedule.o -MD -MP -MF .deps/dlgSchedule.Tpo -c -o dlgSchedule.o `test -f './agent/dlgSchedule.cpp' || echo './'`./agent/dlgSchedule.cpp In file included from ../pgadmin/include/ctl/ctlSQLBox.h:20, from ../pgadmin/include/pgAdmin3.h:23, from ./agent/dlgSchedule.cpp:12: ../pgadmin/include/db/pgConn.h: In static member function ‘static bool pgConn::IsValidServerEncoding(int)’: ../pgadmin/include/db/pgConn.h:104: error: ‘pg_valid_server_encoding_id’ was not declared in this scope In file included from ../pgadmin/include/ctl/ctlSQLBox.h:20, from ../pgadmin/include/pgAdmin3.h:23, from ./agent/dlgJob.cpp:14: ../pgadmin/include/db/pgConn.h: In static member function ‘static bool pgConn::IsValidServerEncoding(int)’: ../pgadmin/include/db/pgConn.h:104: error: ‘pg_valid_server_encoding_id’ was not declared in this scope make[2]: *** [dlgSchedule.o] Error 1 make[2]: *** Waiting for unfinished jobs.... In file included from ../pgadmin/include/ctl/ctlSQLBox.h:20, from ../pgadmin/include/pgAdmin3.h:23, from ./pgAdmin3.cpp:13: ../pgadmin/include/db/pgConn.h: In static member function ‘static bool pgConn::IsValidServerEncoding(int)’: ../pgadmin/include/db/pgConn.h:104: error: ‘pg_valid_server_encoding_id’ was not declared in this scope make[2]: *** [dlgJob.o] Error 1 make[2]: *** [pgAdmin3.o] Error 1 make[2]: Leaving directory `/tmp/portage/dev-db/pgadmin3-1.10.1/work/pgadmin3-1.10.1/pgadmin' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/tmp/portage/dev-db/pgadmin3-1.10.1/work/pgadmin3-1.10.1' make: *** [all] Error 2 * * ERROR: dev-db/pgadmin3-1.10.1 failed. * Call stack: * ebuild.sh, line 49: Called src_compile * environment, line 2926: Called die * The specific snippet of code: * emake || die "emake failed" * The die message: * emake failed * * If you need support, post the topmost build error, and the call stack if relevant. * A complete build log is located at '/tmp/portage/dev-db/pgadmin3-1.10.1/temp/build.log'. * The ebuild environment file is located at '/tmp/portage/dev-db/pgadmin3-1.10.1/temp/environment'.
Created attachment 212427 [details] emerge --info
You are mixing stable and unstable. Though, this still may be a valid bug. What versions of postgresql do you have installed ?
Installed packages: ~ $ equery l gresql [ Searching for package 'gresql' in all categories among: ] * installed packages [I--] [ ~] dev-db/postgresql-8.2.14 (0) [I--] [ ~] dev-db/postgresql-docs-8.2.14 (8.2) [I--] [ ~] dev-db/postgresql-docs-8.4.1 (8.4) [I--] [ ] dev-java/jdbc-postgresql-8.3_p605 (0) [I--] [ ~] virtual/postgresql-base-8.2 (8.2)
This should be defined in libpq-fe.h. It is in postgresql-8.4 (not sure about 8.3) (but probably adding a version dep would be good)
Yes, there is /usr/include/postgresql/libpq-4/libpq-fe.h. But I am not sure what I should be looking at?
pg_valid_server_encoding_id, of course.
Well, it doesn't have it: # grep -i pg_valid_server_encoding_id /usr/include/postgresql/libpq-fe.h #
I ran into this also. Stable =dev-db/libpq-8.1.11 does not have any reference to pg_valid_server_encoding_id, so please add a least version dependency. Marking virtual/postgresql-base and deps as ~x86 pulled in 8.4.1, so I can't say anything about postgres 8.3
Created attachment 215699 [details] config.log for failed pgadmin3 build
As a stable x86 user, I'll add that the recent stabilization of postgresql to 8.4.2 has now broken both the stable (currently 1.8.2) and keyworded (1.10.1) versions of pgadmin3. Both die with an inability to find pg_config: checking for strchr... yes checking for pg_config... no configure: error: Could not find your PostgreSQL installation. You might need to use the --with-pgsql=DIR configure option !!! Please attach the following file when seeking support: !!! /var/tmp/portage/dev-db/pgadmin3-1.10.1/work/pgadmin3-1.10.1/config.log * * ERROR: dev-db/pgadmin3-1.10.1 failed. * Call stack: * ebuild.sh, line 49: Called src_compile * environment, line 2863: Called econf '--with-wx-version=2.8' '--disable-debug' * ebuild.sh, line 534: Called die * The specific snippet of code: * die "econf failed" * The die message: * econf failed * * If you need support, post the topmost build error, and the call stack if relevant.
Please check if the problem persists when using dev-db/postgresql-server. (8.4.3 is currently stable upstream and the ebuild is in the tree keyword masked.)
Should be fixed with current in-tree ebuilds
I was experiencing this problem even if it is marked as resolved, and even with several versions of postgres installed. The fix is easy, my computer was using an old postgres version eselect postgresql list Available postgresql installations 8.1 <-* <-S base-8.1.22 server-8.1.22 8.2 base-8.2.18 server-8.2.18 8.3 base-8.3.12 server-8.3.12 8.4 base-8.4.5 server-8.4.5 9.0 base-9.0.1 server-9.0.1 So, after a eselect postgresql set 9.0 it is possible to upgrade >=pgadmin3-1.10.2 Hope this helps someone else.
Happened to me with postgresql 8.4.6 while trying to install pgadmin3-1.12.2 Although "eselect postgresql list" was showing that 8.4 was selected (and the only install), doing an "eselect postgresql set 8.4" fixed it
