Connecting and creating db

From: "Sandy Keathley" <sandy(at)keathleywebs(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Connecting and creating db
Date: 2011-04-20 23:04:00
Message-ID: 4DAF6660.24202.33ECC9@sandy.keathleywebs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2011-04-21 00:43:12 Re: Connecting and creating db
Previous Message Grzegorz Szpetkowski 2011-04-20 20:29:58 Choosing character set for database