Connecting and creating db - Mailing list pgsql-novice

From Sandy Keathley
Subject Connecting and creating db
Date
Msg-id 4DAF6660.24202.33ECC9@sandy.keathleywebs.com
Whole thread Raw
Responses Re: Connecting and creating db
List pgsql-novice
Well, this is a novice list, so I hope no one will find me too pitiful to answer.

Although I have used Postgres before, some years ago, I had never installed it (maybe I still
haven't).  I have installed version 9.0 by RPM, on an RHEL 4 box.  I can start the server,
but there are two problems:

1. logged in as user "postgres", I cannot connect to the database server without first issuing
(every time) the command: export LD_LIBRARY_PATH="/usr/pgsql/lib"
This is annoying.

2.  once connected to the cluster, I cannot create a database.  There is no error message,
and nothing is logged.  I am using the command "createdb graves". Nothing happens.

\l displays the databases (postgres, template0, template1).

Can someone point me in the right direction?

Thanks,

Sandy Keathley



pgsql-novice by date:

Previous
From: Grzegorz Szpetkowski
Date:
Subject: Choosing character set for database
Next
From: Tom Lane
Date:
Subject: Re: Connecting and creating db