Re: Errors creating my first database

Kent,

You sound like I did a couple months ago.  The book
'Pratical PostgreSQL' from O'Reilly Press really got
me started on the right foot.  Chapter 2 gives a
detailed step-by-step procedure to installing and
starting Postgres.  Do a Google search to find it
on-line, or better yet, buy the book.

The other thing that I did was to acquire SuSE 7.3
Professional.  By doing a detailed install and
selecting PostgreSQL, it will do most of the work for
you so that all that has to be done is:
1. change the postgres user password
2. run initdb
3. test your install
4. Test, test, test.....
5. Document, document, document....

Good luck, HTH,

Troy



--- kent.rigby@att.net wrote:
> I have been trying to get started with PostgreSQL,
> and
> it hasn't been going
> well.  I installed, ran initdb, but when I try to
> create
> a database with
> createdb I get an error that "username" does not
> exist.
> OK, so I try to use
> createuser to create the user name and I get a
> different, though equally
> frustrating, error.  I have shut down my Linux box
> out
> of frustration so I
> can't tell you all the exact error, sorry.  One of
> the
> errors I am getting
> is about a locking file that I don't have
> permissions
> for.
>
> Obviously I am doing something wrong here.  I have
> read
> and re-read the
> Tutorial, User's Manual and Admin Manual, tried to
> follow the procedures in
> the manual, but no luck.
>
> Could someone please help me get started here.  I am
> new
> to Linux and part
> of my frustration is that all the manuals assume an
> intermediate level of
> experience with Linux/UNIX.  I don't have that and
> at
> this rate I can't see
> that I ever will.
>
>
>
>
>
> ------------------------------------------------
> Get the award winning ISP, AT&T WorldNet Service
> http://download.att.net/webtag
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org



______________________________________________________________________
Find, Connect, Date! http://personals.yahoo.ca