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

Re: super beginner setting up postgresql for the first time

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: Benjamin Golder <benjamin(dot)j(dot)golder(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: super beginner setting up postgresql for the first time
Date: 2010-12-23 17:17:29
Message-ID: AANLkTiki0vV9gy4oRT=bCOXx2n5=R-sGyxoAnDbAWAOd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, Dec 23, 2010 at 9:05 AM, Benjamin Golder
<benjamin(dot)j(dot)golder(at)gmail(dot)com> wrote:
> I am so glad there is a novice list, because as a brand new user, I have
> plenty of naïve questions.

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

The postgres user is created as the default OS user that will own the
PostgreSQL processes and files.  Also there is a postgres db user that
is "like" a root/administrator users for the RDBMS.

If your very new to postgresql and you want to learn, the first thing
that you'll need to do is turn off some of the security features until
you learn your way around the system a bit better.  Later you'll want
to reapply these features for protection.

First off, you want to make postgres "trust" you.  You can to this by
modifying the pg_hba.conf file and then restarting the postgresql
service.

http://www.postgresql.org/docs/9.0/interactive/auth-pg-hba-conf.html

You can test if your permission changes allow you access by using the
psql the command line client application that comes with postgresql.

This will be the first set to get you started.

-- 
Regards,
Richard Broersma Jr.

In response to

pgsql-novice by date

Next:From: AarniDate: 2010-12-23 17:38:47
Subject: Re: Migration from MySQL to PostgreSQL : Datatypes?
Previous:From: Bill P.Date: 2010-12-23 17:12:18
Subject: Migration from MySQL to PostgreSQL : Datatypes?

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