"Sebastien ARBOGAST" <sebastien.arbogast@xxxxxxxxx> wrote: > > 2007/12/15, Bill Moran <wmoran@xxxxxxxxxxxxxxxxx>: > > "Sebastien ARBOGAST" <sebastien.arbogast@xxxxxxxxx> wrote: > > > > > > I'm trying to start postgreSQL server on my Macbook Pro. I've > > > installed it using packages available here: > > > http://www.kyngchaos.com/wiki/software:postgres > > > But when I try to start up the server running "sudo SystemStarter > > > start PostgreSQL", I get the following message: > > > > > > postgres cannot access the server configuration file > > > "/usr/local/pgsql/data/postgresql.conf": No such file or directory > > > > > > And as a matter of fact, there is no such file in this directory. Do I > > > have to create it manually? > > > > You need to run initdb to create the directory: > > http://www.postgresql.org/docs/8.3/static/app-initdb.html > > The problem is that I need the password of the postgres user that has > been created automatically for me. I've tried "postgres" but it > doesn't seem to work. And since I can't see the user in my Preference > Pane, I can't change his password. Please don't top-post. And please don't respond personally to email that was originated on the mailing list. I've returned pgsql-general@xxxxxxxxxxxxxx to the list of recipients. If you installed the software, you obviously have root access, so just change the postgres password to something you know. While I'm not familiar with the Mac OS installation procedure, I'd assume that account was created without login capability (probably without a password at all) which is good, sound security practice. Software shouldn't create users with known passwords. You can also use sudo to switch to the postgres user without needing the password for the postgres user (although it will probably ask you for the root password again -- not entirely sure how Mac OS is set up by default) This approach has become pretty much par for the course on modern POSIX systems. Try: sudo -u postgres initdb -- Bill Moran http://www.potentialtech.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
