Hello

I began with a laptop, installed Red Hat Enterprise Linux 3. I do not know
what is included or not on this version. I downloaded some RPMs from
RedHat.com and used tech support to install all of them. I do not know what
all the RPM does, whether it goes to completion or just unzips some
compressed files. I found a book about PostgreSQL for a previous version and
used it. After using Red Hat technical support I used the book. I modified
the bash_profile for user account postgres, and my personal user account
according to instructions in the book. I get error messages concerning these
files.

I am kind of lost about PostgreSQL but if you will help me I will
persevere.

I have some error messages when trying to create a database using the
command: createdb "mydb".

Error message for both of those commands:

psql: could not connect to server: No such file or directory Is the server
running locally and accepting connections on Unix domain socket
"tmp.PGSQL.5432"?
createuser: creation of user "username" failed.

Or if I am trying to create a database I get the error message similar to
above but last line says: createdb: database creation failed.

I have created a user account called postgre, without the s on the end. I
do not know what ramifications this has.

I noticed after mistyping "postgre" that the username "postgres" was already
created.

The version I have installed in 7.3.

Thank you for helping me. Please email me and tell me what I need to do to
get it running.

Lee

Hi,

First, your database server is not running so you cannot do anything.

So, I thoink you need to follow the steps :
1 - initdb -D /Thedirectory where are your data (With RPM maybe you don't need this step)
2 - postmaster -S -D /Thedirectory -i & (maybe have you a /etc/init.d/postgres*, in this case you only need to tape /etc/init.d/postgres* start, I put postgres* because I don't know exactky the name)

And now you can create an user and a database

Bruno

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Hi Lee,

RHEL 3 should be pretty much the same as RH 9 ?

First, you will have to run initdb (as user postgres perhaps):

#initdb -D /path/to/datadir/(owned by by postgres, create it first) -E (for
encoding, perhaps LATIN1 for umlauts and other funny characters to work and
sort) -L
/default/onRH7.3/is/usr/local/pgsql/share/or/where/ever/postgres.bki/resides/

e.g:

initdb -D /usr/share/pgdata/ -E LATIN1 -L /usr/local/pgsql/share/

This will create your system / cluster.

Then, again as postgres or preferred user, or by default, start postmaster:

#/usr/local/pgsql/bin/postmaster -D /path/to/datadir/ -i(for port 5432 from
outside ?) -B (number of buffers) -N (number of connections allowed)

e.g.:

#/usr/local/pgsql/bin/postmaster -D /usr/share/pgdata/ -i -B 128 -N 256

Now you should be able to create databases.

Hope this helps.

BR,

Aarni

On Wednesday 14 January 2004 08:13, you wrote:
--
-------------------------------------------------
Aarni Ruuhimäki | Megative Tmi | KYMI.com



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster