For Windows2000 下載 PgSQL731wina1.exe (http://www.postgresql.org), Finally you will see the next line, you need enter the passWord for Administrator 最后你將看下一個行,你必須為用戶Administrator輸入password. ******************** Enter password of user `.Administrator′:123456 ********************
local all trust host all 127.0.0.1 255.255.255.255 trust
just delete #, and save.
[root@localhost root]# su - postgres -bash-2.05b$ /usr/bin/postmaster -i -D /usr/local/pgsql/data >logfile 2>&1 & -bash-2.05b$ /usr/bin/createdb test -bash-2.05b$ /usr/local/pgsql/bin/psql test test=# .......the following same as Windows2000
到此, 數(shù)據(jù)準備就緒.
執(zhí)行shutdown.bat or shutdown.sh, 停止Jboss Server.
<attribute name="JndiName">PostgresDS</attribute> <attribute name="ManagedConnectionFactoryProperties"> <properties> <config-property name="ConnectionURL" type="java.lang.String">jdbc:postgresql://localhost/test</config-property> <config-property name="DriverClass" type="java.lang.String">org.postgresql.Driver</config-property> <!--set these only if you want only default logins, not through JAAS --> <config-property name="UserName" type="java.lang.String">Administrator</config-property> <config-property name="Password" type="java.lang.String">123456</config-property> </properties>
In my example, set Username Administrator, password 123456 for windows 2000 set Username Postgres, no password for Linux. 在我的例子中, windows2000, 用戶:Administrator,password:123456 Linux(RH8.0), 用戶:Postgres, 沒有password 因為PostgresSQL和windows2000使用不同的default用戶名,所以在linux和window2000中這文件不同.當然,你可以加相同的PostgresSQL用戶名和password在linux和window2000中, 這樣這文件就相同了.