Thread: PGACCESS installation
Hi,
I have this particular problem with PgAccess installation. I have PostgreSQL 7.1.3 installed with the --with-tcl option. I installed PgAccess in the same way as mentioned in the installation documents. I have appended the files in the PATH settings too ( /usr/local/pgsql/lib/libpgtcl.so & /usr/local/pgaccess/main./tcl ).
But on starting PgAccess it gives the following error:
Error in startup script : Couldnt load file ''libpgtcl.so''. Cannot open shared object file : No such file or directory
while executing
''load libpgtcl [info shared lib extension ] ''
(procedure ''main'' line 3)
involved from within
'' main $argc $argv ''
( file ''/usr/local/pgaccess/main.tcl '' line 249 )
How do I overcome this particular error?
I'am using Red Hat Linux v 7.2.
Thanx in advance
Unni
I had this problem once and I just created a symbolic link as follows: <br />ln -s /usr/src/pgsql/src/interfaces/libpgtcl.so/usr/local/pgsql/lib/libpgtcl.so <br />not the best solution, but worked for me<p>Oleg <p>Unnikrishnan Menon wrote: <blockquote type="CITE"><style></style><font face="Arial"><font size="-1">Hi,</font></font> <fontface="Arial"><font size="-1">I have this particular problem with PgAccess installation.I have PostgreSQL 7.1.3 installed with the --with-tcl option. I installed PgAccess in the same way as mentionedin the installation documents. I have appended the files in the PATH settings too ( /usr/local/pgsql/lib/libpgtcl.so& /usr/local/pgaccess/main./tcl ).</font></font><font face="Arial"><font size="-1">Buton starting PgAccess it gives the following error:</font></font> <font face="Arial"><font size="-1">Error instartup script : Couldnt load file ''libpgtcl.so''. Cannot open shared object file : No such file or directory</font></font><fontface="Arial"><font size="-1"> while executing</font></font><font face="Arial"><font size="-1">''loadlibpgtcl [info shared lib extension ] ''</font></font><font face="Arial"><font size="-1"> (procedure ''main''line 3)</font></font><font face="Arial"><font size="-1">involved from within</font></font><font face="Arial"><fontsize="-1">'' main $argc $argv ''</font></font><font face="Arial"><font size="-1">( file ''/usr/local/pgaccess/main.tcl'' line 249 )</font></font> <font face="Arial"><font size="-1">How do I overcome this particularerror?</font></font> <font face="Arial"><font size="-1">I'am using Red Hat Linux v 7.2.</font></font> <font face="Arial"><fontsize="-1">Thanx in advance</font></font> <font face="Arial"><font size="-1">Unni</font></font></blockquote>
>> Hi, I have this particular problem with PgAccess installation. I have
>> PostgreSQL 7.1.3 installed with the --with-tcl option. I installed
>> PgAccess in the same way as mentioned in the installation documents. I
>> have appended the files in the PATH settings too (
>> /usr/local/pgsql/lib/libpgtcl.so & /usr/local/pgaccess/main./tcl ).But
>> on starting PgAccess it gives the following error: Error in startup
>> script : Couldnt load file ''libpgtcl.so''. Cannot open shared object
>> file : No such file or directory while executing''load libpgtcl
>> [info shared lib extension ] '' (procedure ''main'' line 3)involved
>> from within'' main $argc $argv ''( file ''/usr/local/pgaccess/main.tcl
>> '' line 249 ) How do I overcome this particular error?
What are you doing to start pgaccess? I think you could only get to
that point if you tried to execute main.tcl directly; but you're
supposed to start it by running the pgaccess shell script.
Neither the tcl file nor the .so belong in your PATH, btw.
regards, tom lane
Hi Tom, I tried ur suggestion, but it does not seem to work. I ran PgAccess shell script file. As to Oleg's suggestion the link file is already created in the mentioned path. The error still remains. Regards, Unni ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Unnikrishnan Menon" <unnikrishnan.menon@chennai.transys.net> Cc: "Oleg Lebedev" <olebedev@waterford.org>; <pgsql-sql@postgresql.org> Sent: Thursday, January 24, 2002 12:43 AM Subject: Re: [SQL] PGACCESS installation > >> Hi, I have this particular problem with PgAccess installation. I have > >> PostgreSQL 7.1.3 installed with the --with-tcl option. I installed > >> PgAccess in the same way as mentioned in the installation documents. I > >> have appended the files in the PATH settings too ( > >> /usr/local/pgsql/lib/libpgtcl.so & /usr/local/pgaccess/main./tcl ).But > >> on starting PgAccess it gives the following error: Error in startup > >> script : Couldnt load file ''libpgtcl.so''. Cannot open shared object > >> file : No such file or directory while executing''load libpgtcl > >> [info shared lib extension ] '' (procedure ''main'' line 3)involved > >> from within'' main $argc $argv ''( file ''/usr/local/pgaccess/main.tcl > >> '' line 249 ) How do I overcome this particular error? > > What are you doing to start pgaccess? I think you could only get to > that point if you tried to execute main.tcl directly; but you're > supposed to start it by running the pgaccess shell script. > > Neither the tcl file nor the .so belong in your PATH, btw. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
Hi all, well, I just installed 7.2b5 and now, xbase2pg does not work anymore. Yes I did recompile xbase2pg and added the path to the postgres include files. The program compiles ok, but when I run it, it tells me the table was created and records added, but I can not find the table in the DB. Any ideas? TIA jll
Hi all, well, I just installed 7.2b5 and now, xbase2pg does not work anymore. Yes I did recompile xbase2pg and added the path to the postgres include files. The program compiles ok, but when I run it, it tells me the table was created and records added, but I can not find the table in the DB. Any ideas? Or is there a newer version of xbase2pg? TIA jll
Hi Unnikrishnan Menon, try "less /etc/ld.so.conf", is /usr/local/pgsql/lib/ in it? If not add it in ld.so.conf (see man ld), or cp your tcllib.so to the paths mentioned in ld.so.conf. regards, freek Unnikrishnan Menon wrote: > Hi Tom, > > I tried ur suggestion, but it does not seem to work. I ran PgAccess shell > script file. > As to Oleg's suggestion the link file is already created in the mentioned > path. > The error still remains. > Regards, > Unni > > > ----- Original Message ----- > From: "Tom Lane" <tgl@sss.pgh.pa.us> > To: "Unnikrishnan Menon" <unnikrishnan.menon@chennai.transys.net> > Cc: "Oleg Lebedev" <olebedev@waterford.org>; <pgsql-sql@postgresql.org> > Sent: Thursday, January 24, 2002 12:43 AM > Subject: Re: [SQL] PGACCESS installation > > >> >> Hi, I have this particular problem with PgAccess installation. I have >> >> PostgreSQL 7.1.3 installed with the --with-tcl option. I installed >> >> PgAccess in the same way as mentioned in the installation documents. I >> >> have appended the files in the PATH settings too ( >> >> /usr/local/pgsql/lib/libpgtcl.so & /usr/local/pgaccess/main./tcl ).But >> >> on starting PgAccess it gives the following error: Error in startup >> >> script : Couldnt load file ''libpgtcl.so''. Cannot open shared object >> >> file : No such file or directory while executing''load libpgtcl >> >> [info shared lib extension ] '' (procedure ''main'' line 3)involved >> >> from within'' main $argc $argv ''( file ''/usr/local/pgaccess/main.tcl >> >> '' line 249 ) How do I overcome this particular error? >> >> What are you doing to start pgaccess? I think you could only get to >> that point if you tried to execute main.tcl directly; but you're >> supposed to start it by running the pgaccess shell script. >> >> Neither the tcl file nor the .so belong in your PATH, btw. >> >> regards, tom lane >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 6: Have you searched our list archives? >> >> http://archives.postgresql.org > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >