Re: [Fwd: Re: postgres not allowing new database?] - Mailing list pgsql-general

From lee johnson
Subject Re: [Fwd: Re: postgres not allowing new database?]
Date
Msg-id 39BBB69A.74C76501@imyourhandiman.com
Whole thread Raw
In response to [Fwd: Re: postgres not allowing new database?]  (lee johnson <lee@imyourhandiman.com>)
List pgsql-general
> mkdir /usr/local/pgsql/data
> chown postgres /usr/local/pgsql/data
> su - postgres
> /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

line 3 not working display weird stuff that doesn't seem to apply to
what I"m doing........see below......
-----------------
[handiman@localhost handiman]$ su - postgres
Password:
Cdrecord 1.8.1 (i686-pc-linux-gnu) Copyright (C) 1995-2000 Jörg
Schilling
cdrecord: Permission denied. Cannot open '/dev/sg0'. Cannot open SCSI
driver.
cdrecord: For possible targets try 'cdrecord -scanbus'. Make sure you
are root./dev/ttyS2: Permission denied
--------------------------
its reading my ./profile ????????? ..what does this have to do with
postgres?

am i having trouble because i was root when I installed the
rpm's......maybe i should start over?
and remove the rpm's and download the tar files and install them as su
instead of root???

semi confused here thanks for any help ( sorry....... maybe I should
have been addressing pg-novice all this time? )... :-)
lee





pgsql-general by date:

Previous
From: "Karl F. Larsen"
Date:
Subject: Re: FOREIGN KEY questions
Next
From: Neil Conway
Date:
Subject: triggers in SQL?