From: | "Isiah Thomas" <proinfo(at)hongkong(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | I am now Linux and PostgreSQL user, have a question |
Date: | 2001-04-26 09:41:33 |
Message-ID: | 9c8qf9$2n9d$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am new user of linux. and I am interested in Postgresql
recently I download ver7.1 and setup
I do it step by step according some docunment in www.Linuxfab.cx
the docunment I read is in below link
http://linuxfab.cx/indexBookData.php?BID=5&G1=5&G2=2&G3=0&G4=0&PAGEID=1
The problem I got is as below:
P.S. the super user "postgres" is added by myself
[root(at)vtl /root]# su - postgres
[postgres(at)vtl postgres]$ /usr/local/pgsql/bin/initdb -D /usr/loca/pgsql/data
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.
Creating directory /usr/loca/pgsql/data
mkdir: cannot create directory `/usr/loca/pgsql/data': No such file or
directory
initdb failed.
Removing temp file /tmp/initdb.11893.
[postgres(at)vtl postgres]$ /usr/local/pgsql/bin/initdb -D
/usr/local/pgsql/data
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.
Fixing permissions on existing directory /usr/local/pgsql/data
Creating directory /usr/local/pgsql/data/base
Creating directory /usr/local/pgsql/data/global
Creating directory /usr/local/pgsql/data/pg_xlog
Creating template1 database in /usr/local/pgsql/data/base/1
DEBUG: database system was shut down at 2001-04-25 10:37:03 HKT
DEBUG: CheckPoint record at (0, 8)
DEBUG: Redo record at (0, 8); Undo record at (0, 8); Shutdown TRUE
DEBUG: NextTransactionId: 514; NextOid: 16384
DEBUG: database system is in production state
Creating global relations in /usr/local/pgsql/data/global
DEBUG: database system was shut down at 2001-04-25 10:37:10 HKT
DEBUG: CheckPoint record at (0, 108)
DEBUG: Redo record at (0, 108); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 514; NextOid: 17199
DEBUG: database system is in production state
Initializing pg_shadow.
Enabling unlimited row width for system tables.
Creating system views.
Loading pg_description.
Setting lastsysoid.
Vacuuming database.
Copying template1 to template0.
Success. You can now start the database server using:
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
[postgres(at)vtl postgres]$ /usr/local/pgsql/bin/postmaster -D
/usr/local/pgsql/data
\DEBUG: database system was shut down at 2001-04-25 10:48:00 HKT
DEBUG: CheckPoint record at (0, 1522124)
DEBUG: Redo record at (0, 1522124); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 615; NextOid: 18720
DEBUG: database system is in production state
the process stoped here, not more action. Can anybody tell me what's wrong?
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Parkinson | 2001-04-26 09:54:07 | debug logs: query: rollback |
Previous Message | Tod McQuillin | 2001-04-26 08:53:33 | Re: Run a create object script ??? |