From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
---|---|
To: | Pierre-Alexis Paquin <papaquin(at)i2m(dot)fr>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgresql installation problem |
Date: | 2002-04-15 17:45:42 |
Message-ID: | 20020415174542.79790.qmail@web13406.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
To initialize the database, the database user must
have the proper permissions to create the database
directories you've mentioned (pgsql, pgsql/data).
Assuming the following:
Database User: postgres
Databsase User's group: database
Database directory: /var/lib/pgsql/data
1. Read the online documentation for your version at
http://www.us.postgresql.org/users-lounge/docs/
2. As root:
create the group database in /etc/group
create the user postgres
mkdir -p /var/lib/pgsql/data
chown -R postgres.database /var/lib/pgsql/
3. Login as postgres and:
add the next 2 lines to postgres' .profile
PGDATA=/var/lib/pgsql/data
export $PGDATA
execute the following from the command line:
initdb -D /var/lib/pgsql/data
postmaster -D /var/lib/pgsql/data &
I think this should do it. If I forgot anything, I'm
sure someone will correct me! ;-)
Best of luck,
Andrew Gould
--- Pierre-Alexis Paquin <papaquin(at)i2m(dot)fr> wrote:
> Hi
>
> I have installed a 7.1.3 postgresql version on my
> linux server. (RedHat 7.2)
>
> When I type "createuser xxxxxxxx" it asks me :
> Shall the new user allowed to create databases
> (y/n)?
>
> Shall the new user allowed to
> create more new user (y/n)?
>
> I answer yes to the both questions and then a bug
> report said :
> " psql : connetDbstart() -- connect() failed -
> no such file or directory
> Is the postmaster running locally and accepting
> connections on Unix socket :'/tmp/.s.PSQL.5432'
> createuser : creation of user 'xxxxxxx' failed.
>
> I already had answers to this but I am a newbie in
> linux, so i didn't understand what i have to do
> exactly to resolve this problem.
>
> Someone wrote me :
> 1. Did you initialized your database with initdb ?
> 2. Have you started Postgres with postmaster -i or
> pg_ctl start ?
> 3. Have you modified parameters in
> $PGDATA/postgresql.conf file ?
> Follow your answers, you have solved your problem
>
> 1.When i type initdb it said me that it's not
> possible to create specific directories (pgsql and
> data)
> 2. How am I supposed to use the postmaster or pg_ctl
> ??
> 3. The installation is not complete so i haven't a
> postgresql.conf file ....
>
> Thanks for your help.
> Pierre-Alexis
>
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-04-15 17:48:29 | Re: Why does postgres not take into account my index on a bigint column ? |
Previous Message | Philip Reimer | 2002-04-15 17:29:31 | User-Defined Datatypes |