Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problem in postgresql installation

Problem in postgresql installation

From
"Pierre-Alexis Paquin"
Date:
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

Re: Problem in postgresql installation

From
Oliver Elphick
Date:
On Tue, 2002-04-09 at 08:22, Pierre-Alexis Paquin wrote:problem
>
> 1.When i type initdb it said me that it's not possible to create specific directories (pgsql and data)

The user running initdb needs write permissions in the directory.  You
must arrange that before you run initdb.

> 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 ....

You must run initdb successfully first.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "And they questioned Him, saying "...Is it lawful for
      us to pay taxes to Caesar, or not? ...And He said to
      them "...render to Caesar the things that are
      Caesar's, and to God the things that are God's."
                      Luke 20:21,22,25
Attachment

Re: Problem in postgresql installation

From
"P. Jourdan"
Date:
At 09:22 AM 4/9/2002 +0200, Pierre-Alexis wrote:
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 ....

I have had such problems too, I suggest looking at the page: http://www.postgresql.org/idocs/index.php?installation.html
 and you should be able to find answers there, as I did.
Philip Jourdan