Thread: Postgresql installation problem
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
I'm also a newbie on postgresql. The first time I installed it was last friday. But I'll give a shot! Any mistakes, please correct me guys! > 1. Did you initialized your database with initdb ? This step creates the base files needed to run PSQL. I'll assume you're running postgresql as postgres user. Firstly, create a directory like data in your psql home directory. Then, if the owner is not the postgres user, give him the ownershio of it. Something like: # cd /usr/local/psql # mkdir data # chown postgres:users data # chmod 755 data the '#' means I'm root! now, initdb... # su postgres $ pwd /usr/local/psql $ cd bin $ ./initdb -D /usr/local/psql/data the '$' means I'm a normal user like 'postgres' in this case > 2. Have you started Postgres with postmaster -i or pg_ctl start ? Now you must start your postgresql daemon as postgres user. YOU CANNOT START POSTGRESQL AS ROOT. $ pwd /usr/local/psql/bin $ ./postmaster -i -D /usr/local/psql/data & ok now your daemon should be started... > 3. Have you modified parameters in $PGDATA/postgresql.conf file ? > Follow your answers, you have solved your problem you can do it later. for now, check if it is working as you wish. See ya, William Zanatta
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@i2m.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/
First thanx for the speed of your response. The problem is that nothing's happened when I launch postmaster. When I run postmaster - i , the system writes : 2002-04-15 . 10:47:06 [1016] DEBUG : database system was shut down at ...... 2002-04-15 . 10:47:06 [1016] DEBUG : Checkpoint record at (0,1522276) 2002-04-15 . 10:47:06 [1016] DEBUG : Redo record at (0,1522276) : undo record (0,0) shutdown TRUE 2002-04-15 . 10:47:06 [1016] DEBUG : NextTransactionId : 615 ; NextOid:18720 2002-04-15 . 10:47:06 [1016] DEBUG : database system is in production state and it does nothing else, I don't have the prompt. when i make CTRL-C to interrupt, the sytem writes : database was shutdown. I think the database system starts well but there is a problem that I don't know. I type psql template1 or createdb ... and nothing's happen. Thanx for your help Pierre-Alexis ----- Original Message ----- From: "William N. Zanatta" <william@veritel.com.br> To: "Pierre-Alexis Paquin" <papaquin@i2m.fr> Cc: <pgsql-general@postgresql.org> Sent: Monday, April 15, 2002 3:58 PM Subject: Re: [GENERAL] Postgresql installation problem > I'm also a newbie on postgresql. The first time I installed it was last > friday. But I'll give a shot! Any mistakes, please correct me guys! > > > 1. Did you initialized your database with initdb ? > > This step creates the base files needed to run PSQL. > I'll assume you're running postgresql as postgres user. > Firstly, create a directory like data in your psql home directory. Then, > if the owner is not the postgres user, give him the ownershio of it. > Something like: > > # cd /usr/local/psql > # mkdir data > # chown postgres:users data > # chmod 755 data > > the '#' means I'm root! > > now, initdb... > > # su postgres > $ pwd > /usr/local/psql > $ cd bin > $ ./initdb -D /usr/local/psql/data > > the '$' means I'm a normal user like 'postgres' in this case > > > 2. Have you started Postgres with postmaster -i or pg_ctl start ? > > Now you must start your postgresql daemon as postgres user. YOU CANNOT > START POSTGRESQL AS ROOT. > > $ pwd > /usr/local/psql/bin > $ ./postmaster -i -D /usr/local/psql/data & > > ok now your daemon should be started... > > > 3. Have you modified parameters in $PGDATA/postgresql.conf file ? > > Follow your answers, you have solved your problem > > you can do it later. for now, check if it is working as you wish. > > > See ya, > > William Zanatta >
http://www.foo.be/docs/unix hint : '&' On Wed, 17 Apr 2002, Pierre-Alexis Paquin wrote: > The problem is that nothing's happened when I launch postmaster. > When I run postmaster - i , the system writes : [snip] > Thanx for your help > Pierre-Alexis > > ----- Original Message ----- -- Tycho Fruru tycho@fruru.com "Prediction is extremely difficult. Especially about the future." - Niels Bohr
http://www.foo.be/docs/unix hint : '&' On Wed, 17 Apr 2002, Pierre-Alexis Paquin wrote: > The problem is that nothing's happened when I launch postmaster. > When I run postmaster - i , the system writes : [snip] > Thanx for your help > Pierre-Alexis > > ----- Original Message -----