Thread: (no subject)

(no subject)

From
Lduren02@aol.com
Date:
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

Re: (no subject)

From
Bruno LEVEQUE
Date:
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

Re: (no subject)

From
Aarni Ruuhimäki
Date:
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