tks pak sudah berhasil
[EMAIL PROTECTED] ~]# service postgresql stop
Stopping postgresql service: [ OK ]
[EMAIL PROTECTED] ~]$ su - root
Password:
[EMAIL PROTECTED] ~]# rm -rf /var/lib/pgsql/data
[EMAIL PROTECTED] ~]# mkdir /var/lib/pgsql/data
[EMAIL PROTECTED] ~]# ls -l /var/lib/pgsql/
total 28
drwx------ 2 postgres postgres 4096 Feb 9 2005 backups
drwxr-xr-x 2 root root 4096 Jan 5 01:45 data
-rw-r--r-- 1 root root 147 Jan 5 01:40 initdb.i18n
-rw-rw-r-- 1 postgres postgres 0 Jan 5 00:44 msckbb.db
[EMAIL PROTECTED] ~]# chown postgres:postgres /var/lib/pgsql/data
[EMAIL PROTECTED] ~]# chmod go-rwx /var/lib/pgsql/data
[EMAIL PROTECTED] ~]# restorecon /var/lib/pgsql/data
[EMAIL PROTECTED] ~]# setenforce 0
[EMAIL PROTECTED] ~]# ls -l /var/lib/pgsql/data
total 0
[EMAIL PROTECTED] ~]# ls -l /var/lib/pgsql
total 28
drwx------ 2 postgres postgres 4096 Feb 9 2005 backups
drwx------ 2 postgres postgres 4096 Jan 5 01:45 data
-rw-r--r-- 1 root root 147 Jan 5 01:40 initdb.i18n
-rw-rw-r-- 1 postgres postgres 0 Jan 5 00:44 msckbb.db
[EMAIL PROTECTED] ~]# su - postgres
-bash-3.00$ initdb
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.
The database cluster will be initialized with locale en_US.UTF-8.
fixing permissions on existing directory /var/lib/pgsql/data... ok
creating directory /var/lib/pgsql/data/base... ok
creating directory /var/lib/pgsql/data/global... ok
creating directory /var/lib/pgsql/data/pg_xlog... ok
creating directory /var/lib/pgsql/data/pg_clog... ok
selecting default max_connections... 100
selecting default shared_buffers... 1000
creating configuration files... ok
creating template1 database in /var/lib/pgsql/data/base/1... 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
creating information schema... ok
vacuuming database template1... ok
copying template1 to template0... ok
Success. You can now start the database server using:
/usr/bin/postmaster -D /var/lib/pgsql/data
or
/usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start
-bash-3.00$ exit
logout
[EMAIL PROTECTED] ~]# service postgresql start
Starting postgresql service: [ OK ]
[EMAIL PROTECTED] ~]# service postgresql stop
Stopping postgresql service: [ OK ]
[EMAIL PROTECTED] ~]# setenforce 1
[EMAIL PROTECTED] ~]# service postgresql start
Starting postgresql service: [ OK ]
[EMAIL PROTECTED] ~]# exit
logout
tapi database-nya keburu ilang, lumayan sudah satu bulan
:)
[EMAIL PROTECTED] wrote:
mungkin link berikut berguna.
http://archives.postgresql.org/pgsql-admin/2004-02/msg00268.php
salam
hasyim
dear all
saya coba ngedump db postgres saya dengan command berikut
[EMAIL PROTECTED] ~]$ pg_dump msckbb > msckbb.db
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: relation "pg_user" does not
exist
pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE
usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding,
datpath FROM pg_database WHERE datname = 'msckbb'
kenapa fail ya?
ada yang dapat membantu saya?, tks sebleumnya
nduy
--
Berhenti langganan: [EMAIL PROTECTED]
Arsip dan info: http://linux.or.id/milis
--
Berhenti langganan: [EMAIL PROTECTED]
Arsip dan info: http://linux.or.id/milis
