bash$ postmaster -i &
[1] 17549
bash$ Database system in directory /home/local/pgsql/data/ is not compatible with
this version of Postgres, or we are unable to read the PG_VERSION file. Explanati
on from ValidatePgVersion: Version number in file '/home/local/pgsql/data//PG_VERS
ION' should be 6.5, not 7.0.
No data directory -- can't proceed.
이런 에러가 나네요...
보니깐...
postgresql이 6.5. 와 7.0이 둘다 같이 있다는 메세지 같은데..????
왜 그런거지 모르겠네요???
분명히..
/etc/profile
에서
PATH="$PATH:/usr/local/mysql/bin:/usr/local/jdk1.2/bin:/usr/X11R6/bin:/usr/local/J
SDK2.0/bin:/home/local/pgsql/data/base/template1:/home/local/pgsql/bin:."
CLASSPATH="/usr/local/JSDK2.0/lib/jsdk.jar:/home/local/pgsql/lib/jdbc/postgresql.j
ar:/usr/local/apache/servlets/mail.jar:/usr/local/apache/servlets/activation.jar:/
usr/local/jdk1.2.2/lib/mm.mysql-2.0.2-bin.jar:."
MANPATH="$MANPATH:/home/local/pgsql/man"
PGLIB="/home/local/pgsql/lib"
PGDATA="/home/local/pgsql/data/"
을 해주었고요...
그리고...
/etc/ld.so.conf
에서도
home/local/pgsql/lib
을 해주었거든요...
그런데..왜 이런 에러가 나죠?????
그래서 에러가 나지 않는 방향으로 할려면..
/home/local/pgsql/bin/postmaster -i -D /home/local/pgsql/data &
이렇게 data가 있는 이름을 지정해 줘야 하드라구요..
bash$ /home/local/pgsql/bin/postmaster -i -D /home/local/pgsql/data &
[1] 17575
bash$ DEBUG: Data Base System is starting up at Wed Oct 17 00:19:12 2001
DEBUG: Data Base System was shut down at Wed Oct 17 00:06:38 2001
DEBUG: Data Base System is in production state at Wed Oct 17 00:19:12 2001
...
그런데 이 또한 문제가 있네요...
이걸하게 되면...
bash$ psql -l
datname |datdba|encoding|datpath
---------+------+--------+---------
template1| 500| 0|template1
(1 row)
bash$ pq_recvbuf: unexpected EOF on client connection
이런 메시지가 뜨더군요..
결론적으로 기존에 있던 6.5랑 7.0.2랑 같이 뜨는것 같기도 한데????
제가 안해준게 있나요????
http://database.sarang.net/database/postgres/lecture/pgsql_7.1.inst.html
에서 봐서 했거든요...
좀 알려주세요
|