From: | Aarni Ruuhimäki <aarni(dot)ruuhimaki(at)kymi(dot)com> |
---|---|
To: | Lduren02(at)aol(dot)com |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: (no subject) |
Date: | 2004-01-14 11:02:35 |
Message-ID: | 200401141302.35078.aarni.ruuhimaki@kymi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Aarni Ruuhimäki | 2004-01-14 14:19:14 | SQL_ASCII / LATIN1 |
Previous Message | Raghu | 2004-01-14 09:00:33 | Meta data about object in postgres |