On Saturday 05 October 2002 14:03, anda menulis :
> Kalau :
> psql template1 <enter>
> \l <enter> <== melihat daftar database yang ada
> \c nama_database <enter> <== koneksi ke database tertentu
> \z <enter> <== melihat previlegesnya yang ada
> bisa ndak ? di psql ketik "\?" kalau mau melihat daftar command yang ada.
> IPBS
Tetep tidak bisa pak :(
Yang keluar begini :
[bujung@bujung bujung]$ pgsql template1
bash: pgsql: command not found
Waktu kucari dengan perintah :
[bujung@bujung bujung]$ whereis pgsql
pgsql: /etc/pgsql /usr/lib/pgsql /usr/include/pgsql /usr/local/pgsql
/usr/share/pgsql
dengan catatan /usr/local/pgsql adalah direktori yang telah saya sediakan
karena pada file /etc/profile sudah saya tambahkan baris :
PATH=$PATH:/usr/local/pgsql/bin
LD_LIBRARY_PATH=/usr/local/pgsql/lib
MANPATH=$MANPATH:/usr/local/pgsql/man
PGLIB=/usr/local/pgsql/lib
PGDATA=/usr/local/pgsql/data
export PATH LD_LIBRARY_PATH MANPATH PGLIB PGDATA
[bujung@bujung bujung]$ initdb
The files belonging to this database system will be owned by user "bujung".
This user must also own the server process.
Fixing permissions on existing directory /usr/local/pgsql/data... chmod:
changing permissions of `/usr/local/pgsql/data': Operation not permitted
initdb failed.
Setelah chown saya rubah menjadi begini :
[bujung@bujung bujung]$ initdb
The files belonging to this database system will be owned by user "bujung".
This user must also own the server process.
Fixing permissions on existing directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
creating template1 database in /usr/local/pgsql/data/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
creating system views... ok
loading pg_description... ok
vacuuming database template1... ok
copying template1 to template0... ok
Success. You can now start the database server using:
/usr/bin/postmaster -D /usr/local/pgsql/data
or
/usr/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
Waktu saya lanjutkan dengan perintah
[bujung@bujung bujung]$ /usr/bin/postmaster -D /usr/local/pgsql/data
FATAL 1: Can't read lock file /tmp/.s.PGSQL.5432.lock: Permission denied
Trus setelah saya rubah chmod dan chownnya dan mengetikkan lagi perintah
[bujung@bujung bujung]$ /usr/bin/postmaster -D /usr/local/pgsql/data
Lock file "/tmp/.s.PGSQL.5432.lock" already exists.
Is another postmaster (pid 2070) using "/tmp/.s.PGSQL.5432"?
/usr/bin/postmaster: cannot create UNIX stream port
[bujung@bujung bujung]$
Nah bagaimana hayo pak :(
Tolongin saya dong, mumpung lagi niat belajar neh !
--
Warso Prayitno [ [EMAIL PROTECTED] ]
--
Utk berhenti langganan, kirim email ke [EMAIL PROTECTED]
Informasi arsip di http://www.linux.or.id/milis.php3
