when I start pgaccess,I get the following error: Error in startup script: couldn't load file "libpgtcl.so": /usr/lib/libpgtcl.so: undefined symbol: crypt while executing "load libpgtcl.so" (procedure "main" line 6) invoked from within
*** Bug 2287 has been marked as a duplicate of this bug. *** pgaccess from postgresql-devel does not work. Error in startup script: couldn't load file "libpgtcl.so": /usr/lib/libpgtcl.so: undefined symbol: crypt while executing "load libpgtcl.so" (procedure "main" line 6) invoked from within "main $argc $argv" (file "/usr/bin/pgaccess" line 4954)
*** Bug 2810 has been marked as a duplicate of this bug. *** Error in startup script: couldn't load file "libpgtcl.so": /usr/lib/libpgtcl.so: undefined symbol: crypt The docs for pgaccess mention that things have to be changed in makefiles. Here is the relevent section from the docs for pgaccess: PostgreSQL 6.4 release has a minor bug. I does not includ by default the crypt lib when compiling libpgtcl. So, you will need to manually add a -lcrypt to SHLIB line in Makefile in src/interfaces/libpgtcl and then make clean and make again. The new libpgtcl.so library is properly configured to run pgaccess.
*** Bug 2949 has been marked as a duplicate of this bug. *** When pgaccess is run the following error message is displayed: Error in startup script: couldn't load file "libpgtcl.so": /usr/lib/libpgtcl.so: undefined symbol: crypt while executing "load libpgtcl.so" (procedure "main" line 6) invoked from within "main $argc $argv" (file "/usr/bin/pgaccess" line 4954) It looks like the tcl interface to postgres wasn't built quite right.
Please release a fixed RPM for this. The fix below is correct and trivial.
*** Bug 3617 has been marked as a duplicate of this bug. *** In RH 6.0 with postgresql-clients 6.4.2 the "pgaccess" tcl/tk program does not work. The cause seems to be a problem with the libpgtcl.so library. The output of an attempt to run pgaccess is as follows: Error in startup script: couldn't load file "libpgtcl.so": /usr/lib/libpgtcl.so: undefined symbol: crypt while executing "load libpgtcl.so" (procedure "main" line 6) invoked from within "main $argc $argv" (file "/usr/bin/pgaccess" line 4954)
*** Bug 4652 has been marked as a duplicate of this bug. *** According to the web page above... PostgreSQL 6.4 release has a minor bug. I does not includ by default the crypt lib when compiling libpgtcl. So, you will need to manually add a -lcrypt to SHLIB line in Makefile in src/interfaces/libpgtcl and then make clean and make again. The new libpgtcl.so library is properly configured to run pgaccess.
This should be fixed by postgresql-6.5.1-0.8 and later.