[Firefly-dev] Problems....

[firefly-dev]

Ok, so I have never made a DB before. Here is my output from the screen.
What am I doing wrong to get the last error down there?
John Hornbeck


address@hidden firefly]$ export PGDATA=~/database/
address@hidden firefly]$ initdb
The files belonging to this database system will be owned by user
"hornbeck".
This user must also own the server process.
 
The database cluster will be initialized with locale en_US.
This locale setting will prevent the use of indexes for pattern matching
operations.  If that is a concern, rerun initdb with the collation order
set to "C".  For more information see the Administrator's Guide.
 
initdb: The directory /home/hornbeck/database/ exists but is not empty.
If you want to create a new database system, either remove or empty
the directory /home/hornbeck/database/ or run initdb with
an argument other than /home/hornbeck/database/.
address@hidden firefly]$ /usr/bin/postmaster -D
/mnt1/dbs/postgresql
FATAL:  cannot open /mnt1/dbs/postgresql/PG_VERSION: Permission denied
address@hidden firefly]$ rmdir ~/database
rmdir: `/home/hornbeck/database': Directory not empty
address@hidden firefly]$ rm -rf ~/database
address@hidden firefly]$ export PGDATA=~/database/
address@hidden firefly]$ initdb
The files belonging to this database system will be owned by user
"hornbeck".
This user must also own the server process.
 
The database cluster will be initialized with locale en_US.
This locale setting will prevent the use of indexes for pattern matching
operations.  If that is a concern, rerun initdb with the collation order
set to "C".  For more information see the Administrator's Guide.
 
creating directory /home/hornbeck/database/... ok
creating directory /home/hornbeck/database//base... ok
creating directory /home/hornbeck/database//global... ok
creating directory /home/hornbeck/database//pg_xlog... ok
creating directory /home/hornbeck/database//pg_clog... ok
creating template1 database in /home/hornbeck/database//base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
vacuuming database template1... ok
copying template1 to template0... ok
 
Success. You can now start the database server using:
 
    /usr/bin/postmaster -D /home/hornbeck/database/
or
    /usr/bin/pg_ctl -D /home/hornbeck/database/ -l logfile start
 
address@hidden firefly]$ /usr/bin/postmaster -D
/mnt1/dbs/postgresql
FATAL:  cannot open /mnt1/dbs/postgresql/PG_VERSION: Permission denied
address@hidden firefly]$ /usr/bin/postmaster -D
~/database
LOG:  StreamServerPort: bind() failed: Address already in use
        Is another postmaster already running on port 5432?
        If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.
/usr/bin/postmaster: cannot create UNIX stream port
address@hidden firefly]$ pg_ctl -D ~/database/ -l logfile
start
postmaster successfully started
address@hidden firefly]$ createdb --encoding=UNICODE
firefly
psql: could not connect to server: Permission denied
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
createdb: database creation failed
address@hidden firefly]$ creatdb test
bash: creatdb: command not found
address@hidden firefly]$ createdb test
psql: could not connect to server: Permission denied
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
createdb: database creation failed
address@hidden firefly]$ su
Password:
address@hidden firefly]# chmod 777 /tmp/.s.PGSQL.5432
address@hidden firefly]# exit
exit
address@hidden firefly]$ createdb test
psql: could not connect to server: Connection refused
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
createdb: database creation failed
address@hidden firefly]$