Thread: Problems after instaling PostgreSQL 7.0
I installed PostgreSQL 7.0 on Linux RedHat 6.2, then I ran the initdb command without any problems or warnings. Then, when I try to run the psql interactive monitor, I get the following error: [postgres@x ~/bin]$ ./psql ./psql: error in loading shared libraries: libpq.so.2.1: cannot open shared object file: No such file or directory I've checked and the file libpq.so.2.1 does exist in the /lib directory. Could you please help me with this? Thanks in advance, J. Mauricio Cuenca H. mcuenca@Telesat.com.co
Try setting the LD_LIBRARY_PATH environment variable. For example, in Linux: export LD_LIBRARY_PATH=/usr/local/pgsql/lib "J. Mauricio Cuenca H." wrote: > I installed PostgreSQL 7.0 on Linux RedHat 6.2, then I ran the initdb > command without any problems or warnings. Then, when I try to run the psql > interactive monitor, I get the following error: > > [postgres@x ~/bin]$ ./psql > ./psql: error in loading shared libraries: libpq.so.2.1: cannot open shared > object file: No such file or directory > > I've checked and the file libpq.so.2.1 does exist in the /lib directory. > > Could you please help me with this? > > Thanks in advance, > > J. Mauricio Cuenca H. > mcuenca@Telesat.com.co ==================================== Craig Johannsen Critical Path Consulting, Inc. 604-762-1514 http://members.home.net/cjohan/cpath ====================================
On Wed, 16 Aug 2000, J. Mauricio Cuenca H. wrote: > I installed PostgreSQL 7.0 on Linux RedHat 6.2, then I ran the initdb > command without any problems or warnings. Then, when I try to run the psql > interactive monitor, I get the following error: > > [postgres@x ~/bin]$ ./psql > ./psql: error in loading shared libraries: libpq.so.2.1: cannot open shared > object file: No such file or directory > > I've checked and the file libpq.so.2.1 does exist in the /lib directory. Does the OS know about it? You may need to run something like ldconfig to get it to reread all the directories shared libs reside in. Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
Craig, Thank you very much for your help, this solved my problem, but now, when I try to run "psql" I get the following: [postgres@x ~/bin]$ ./psql psql: FATAL 1: Database "postgres" does not exist in the system catalog. What could be now? J. Mauricio Cuenca H. mcuenca@Telesat.com.co ----- Original Message ----- From: "Craig Johannsen" <cjohan@home.com> To: "J. Mauricio Cuenca H." <mcuenca@Telesat.com.co> Cc: "PostgreSQL List" <pgsql-general@hub.org> Sent: Wednesday, August 16, 2000 1:10 PM Subject: Re: [GENERAL] Problems after instaling PostgreSQL 7.0 > Try setting the LD_LIBRARY_PATH environment variable. For example, in Linux: > export LD_LIBRARY_PATH=/usr/local/pgsql/lib >
Use the createdb program to create a database. For example,
./createdb testdb
Then, run psql specifying the testdb database. For example,
./psql testdb
Once you are successfully running psql, you can define new users
with the CREATE USER statement.. For example,
create user mauricio
Any such user can then log on under their own user ID and run
./psql testdb
You can use the GRANT statement to grant other users access to tables.
"J. Mauricio Cuenca H." wrote:
> Craig,
>
> Thank you very much for your help, this solved my problem, but now, when I
> try to run "psql" I get the following:
> [postgres@x ~/bin]$ ./psql
> psql: FATAL 1: Database "postgres" does not exist in the system catalog.
>
> What could be now?
>
> J. Mauricio Cuenca H.
> mcuenca@Telesat.com.co
>
> ----- Original Message -----
> From: "Craig Johannsen" <cjohan@home.com>
> To: "J. Mauricio Cuenca H." <mcuenca@Telesat.com.co>
> Cc: "PostgreSQL List" <pgsql-general@hub.org>
> Sent: Wednesday, August 16, 2000 1:10 PM
> Subject: Re: [GENERAL] Problems after instaling PostgreSQL 7.0
>
> > Try setting the LD_LIBRARY_PATH environment variable. For example, in
> Linux:
> > export LD_LIBRARY_PATH=/usr/local/pgsql/lib
> >
====================================
Craig Johannsen
Critical Path Consulting, Inc.
604-762-1514
http://members.home.net/cjohan/cpath
====================================