Re: 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: Re: super beginner setting up postgresql for the first time
Date: 2010-12-24 07:42:12
Message-ID: AANLkTikNfA1OPkP-PumSd3rV4tnrva=SpB=arM+X6VUX@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Thanks John and Richard for your help.

I've updated (I thought I needed an older version for some dependency, but I
was wrong) to 9.0

In case anyone else happens to find this and has similar questions, here's a
little synopsis of what it took for me to finish setting up postgresql:

delete any existing postgres users.

make a new user from terminal, outlined
here<http://www.postgresql.org/docs/9.0/interactive/postgres-user.html>.
(I added a password and admin group status instead of postgres group status)

Make folders for the new postgres user, just using mkdir in terminal. "
/usr/local/pgsql" and "/usr/local/pgsql/data"

I needed to copy brand new .bash_profile and .bashrc files into the
/usr/local/pgsql directory

then I had to use "su postgres" to login as the postgres account. (not sudo
su postgres)
Then I used source .bash_profile to load the new bash configuration. This is
necessary to ensure that postgres commands are available in the PATH
environment
variable (which I had already set in a different .bash_profile file)

from there I used the
initdb<http://www.postgresql.org/docs/9.0/interactive/app-initdb.html>command
to create a database cluster in
/usr/local/pgsql/data
Then I used the chown command discussed on this
page<http://www.postgresql.org/docs/9.0/interactive/creating-cluster.html>to
give ownership to the postgres user

That finally created the
pg_hba.conf<http://www.postgresql.org/docs/9.0/static/auth-pg-hba-conf.html>file
that Richard mentioned. I did not need to edit this file because the
default authorization value is "trust", meaning that it can be accessed
without a password.

then I could finally run the server, using pg_ctl
start<http://www.postgresql.org/docs/9.0/interactive/server-start.html>

Once the server was running I was able to create new superusers (using
createuser <http://www.postgresql.org/docs/8.1/static/app-createuser.html>, a
Terminal command). While making them, no passwords were requested.

Then I could finally go back into the django
app<http://docs.djangoproject.com/en/dev/intro/tutorial01/>I was
making, edit
the settings.py<http://docs.djangoproject.com/en/dev/ref/settings/#std:setting-DATABASES>file
to include the new superuser, and then run the
syncdb <http://docs.djangoproject.com/en/dev/ref/django-admin/#syncdb>command.
This actually prompted me to make a new superuser with a password,
which I did.

The learning curve is steep on these things! I hope this is helpful to
someone else.

2010/12/23 John DeSoi <desoi(at)pgedit(dot)com>

>
> On Dec 23, 2010, at 12:05 PM, Benjamin Golder wrote:
>
> > I recently installed postgresql82 with MacPorts but I can't login to
> psql, postgres, or postmaster when I run them from terminal.
> >
>
> 8.2 is really old. If you are just starting you should be using 9.0. Here
> are a couple of options for Mac installers:
>
> http://www.postgresql.org/download/macosx (Enterprise DB option)
>
>
> http://www.postgresqlformac.com/lists/downloads/unified_installer_disk_imag/
>
>
> John DeSoi, Ph.D.
>
>
>
>
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jasen Betts 2010-12-25 07:17:04 Re: Migration from MySQL to PostgreSQL : Datatypes?
Previous Message Jayadevan M 2010-12-24 03:26:26 Re: Migration from MySQL to PostgreSQL : Datatypes?