Saya menggunakan Mandrake 8.2 ingin belajar database menggunakan PostgreSQL
Sementara buku panduan yang saya peroleh menggunakan Suse atau RedHat.
pada buku panduan tsb disuruh menambahkan baris :
/usr/local/pgsql/lib (pada file /etc/ld.so.conf hal ini sudah saya lakukan)
kemudian menjalankan ldconfig tsb dengan perintah :
#/sbin/ldconfig
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/localpgsql/lib
PGDATA=/usr/lcoal/pgsql/data
export PATH LD_LIBRARY_PATH MANPATH PGLIB PGDATA
setelah saya ketikkan perintah :
[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
[bujung@bujung bujung]$ nohup postmaster -i > pgserver.log 2>&1 &
[1] 5852
Tapi setelah saya coba perintah :
$ psql -u template1
Selalu muncul pesan seperti ini :
psql: Warning: The -u option is deprecated. Use -U.
User name: postgres
Password:
psql: FATAL 1: IDENT authentication failed for user "postgres"
[1]+ Exit 1 nohup postmaster -i >pgserver.log 2>&1
[bujung@bujung bujung]$ psql -u template1
psql: Warning: The -u option is deprecated. Use -U.
User name: bujung
Password:
psql: FATAL 1: user "bujung" does not exist
Mohon bantuan bagaimana jalan keluarnya.
Maklum masih newbie dan awam database :(
--
Warso Prayitno [ [EMAIL PROTECTED] ]
--
Utk berhenti langganan, kirim email ke [EMAIL PROTECTED]
Informasi arsip di http://www.linux.or.id/milis.php3
