I am so glad there is a novice list, because as a brand new user, I have
plenty of naïve questions.
I am running Mac OSX 10.6.5 on a MacBook Pro. I am trying to learn to use
Postgresql for the very first time in order to use PostGIS and GeoDjango.
for now, I'm just trying to run it on my laptop while I learn the basics.
I recently installed postgresql82 with MacPorts but I can't login to psql,
postgres, or postmaster when I run them from terminal.
They request a password for my username, but will not accept any password
that I know or would have made myself.
I tried using the bash configuration commands listed
but I still couldn't login.
I then tried to create a new user account with the name postgres but
received an error saying that a user already existed with that name, even
though no user by that name is listed anywhere.
I found a way to delete the account, even though it wasn't liste, and I made
a new account with the name "postgres" that is able to administer the
I still can't login, because it seems to have associated some password with
my username that I didn't make
I think I've made a mess, and I'm not sure where to fix things. I assume
that I need to learn more about configuring the initial setup. I have read
the online documentation, and done a lot of searching, but I'm still lost. I
assume that I need to have a user account set up in order to use the initdb
So my questions are:
How should I create a user account/password for postgresql and create my
first database to get going? Should I just uninstall and start from scratch?
Is there a configuration file I can edit to reset my password and username?
Thanks and sorry for asking such a terrible question.
Looking forward to learning postgres,
pgsql-novice by date
|Next:||From: Bill P.||Date: 2010-12-23 17:12:18|
|Subject: Migration from MySQL to PostgreSQL : Datatypes?|
|Previous:||From: Mladen Gogala||Date: 2010-12-23 13:42:40|
|Subject: Re: Does Skype outage have anything to do with PostgreSQL?|