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
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)
#/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.
On Wednesday 14 January 2004 08:13, you wrote:
> 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
> 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
> 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.
Aarni Ruuhimäki | Megative Tmi | KYMI.com
In response to
pgsql-novice by date
|Next:||From: Aarni Ruuhimäki||Date: 2004-01-14 14:19:14|
|Subject: SQL_ASCII / LATIN1|
|Previous:||From: Raghu||Date: 2004-01-14 09:00:33|
|Subject: Meta data about object in postgres|