Re: (no subject) - Mailing list pgsql-novice

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

--
-------------------------------------------------
Aarni Ruuhimäki | Megative Tmi | KYMI.com