Skip site navigation (1) Skip section navigation (2)

super beginner setting up postgresql for the first time

From: Benjamin Golder <benjamin(dot)j(dot)golder(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: super beginner setting up postgresql for the first time
Date: 2010-12-23 17:05:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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 GogalaDate: 2010-12-23 13:42:40
Subject: Re: Does Skype outage have anything to do with PostgreSQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group