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

"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:

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
====================================