Java开发网 - 关于postgreSQL安装

Topic: 关于postgreSQL安装

1.关于postgreSQL安装	Copy to clipboard
Posted by: mayutao Posted on: 2003-02-20 01:04 我想在windows xp上安装postgreSQL ，英文的说明不太好理解。那位能给我一些指点，谢谢

2.Re:关于postgreSQL安装 [Re: mayutao]

Copy to clipboard

Posted by: Julian13
Posted on: 2003-02-22 02:58

i follow this step-by-step guide to install postgresql on my windows2000.
http://www.ejip.net/faq/postgresql_win_setup_faq.jsp

The simple step is:
1. install "Cygwin" which is a UNIX environment.
(you should install PostgreSQL package while installing Cygwin)
2. install "CygIPC" which is a daemon job to run PostgreSQL in Windows
3. create PostgreSQL database file.

That is. Good luck.

3.Re:关于postgreSQL安装 [Re: mayutao]	Copy to clipboard
Posted by: sho Posted on: 2003-02-25 17:52 可以到 http://download.desk.ne.jp/win/2/00026/5337.html 下载postgresql for win32....... 不用installl..... 解开执行initdb.exe就会create 一个database 再执行pgsvmgr.exe postgresql就run起来了非常好用

4.Re:关于postgreSQL安装 [Re: mayutao]	Copy to clipboard
Posted by: sho Posted on: 2003-02-25 18:07 再介绍一个工具DBTool for win32 它的界面很像SQL Server的Enterprise Manager 可用于mysql postgresql http://www.dbtools.com.br/EN/downloads.php

5.Re:关于postgreSQL安装 [Re: mayutao]	Copy to clipboard
Posted by: Julian13 Posted on: 2003-02-27 13:36 thx for the postgresql for win32. i'm looking for this long time age. do u know how to run postgresql as windows services as well? most article talk about running it under cygwin environment. just wonder any alternative. thx

6.Re:关于postgreSQL安装 [Re: mayutao]	Copy to clipboard
Posted by: sho Posted on: 2003-02-27 15:35 try: ipc-daemon: ipc-daemon --install-as-service postgresql: cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user postgres --shutdown enjoy it....

7.Re:关于postgreSQL安装 [Re: mayutao]	Copy to clipboard
Posted by: Julian13 Posted on: 2003-02-28 12:38 thx for ur tips. successfully install the ipc-daemon and postmaster as Services. however can't make it started properly. i'm running w2k. is that matter?

8.Re:关于postgreSQL安装 [Re: mayutao]	Copy to clipboard
Posted by: sho Posted on: 2003-03-02 16:28 你應該在cygwin下先用console下啟動，ipc-daemon和postgresql 應該會出現錯誤訊息，把那些錯誤處理掉應該就可以了... PS.要記得在win32下要有postgres這個user

9.Re:关于postgreSQL安装 [Re: mayutao]

Copy to clipboard

Posted by: sho
Posted on: 2003-03-02 20:06

以下出至cygwin的postgresql README

The following is the basic Cygwin PostgreSQL installation procedure:

1. Start the cygipc ipc-daemon:

$ ipc-daemon &

2. Initialize PostgreSQL:

$ initdb -D /usr/share/postgresql/data

3. Start the PostgreSQL postmaster:

$ postmaster -D /usr/share/postgresql/data &

4. Connect to PostgreSQL:

$ psql template1

The following is the NT services Cygwin PostgreSQL installation procedure:

1. Install the cygipc ipc-daemon as a NT service:

# ipc-daemon --install-as-service

2. Create the "postgres" user account:

# cmd /c lusrmgr.msc # [3]
# mkpasswd -l -u postgres >>/etc/passwd

3. Grant the "postgres" user the "Log on as a service" user right:

# cmd /c secpol.msc [4]

4. Install postmaster as a NT service:

# cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user postgres --shutdown # [5] [6]

5. Create the PostgreSQL data directory:

# mkdir /usr/share/postgresql/data

6. Change ownership of the PostgreSQL data directory:

# chown postgres /usr/share/postgresql/data # [10]

7. Initialize PostgreSQL (*when running under the "postgres" account*):

$ initdb -D /usr/share/postgresql/data

5. Start the cygipc ipc-daemon:

# net start ipc-daemon # [7]

6. Start postmaster:

# net start postmaster # [7]

7. Connect to PostgreSQL:

# psql -U postgres template1 [8] [9]

The following are the notes to the above:

[1] The "#" prompt indicates running as a user which is a member of the
Local Administrators group.
[2] The "$" prompt indicates running as the "postgres" user. Log in as
"postgres" or use ssh to emulate Unix's "su" command.
[3] On Windows 2000, this starts the "Local Users and Groups" applet.
On Windows NT 4.0, do the analogous operation.
[4] On Windows 2000, this starts the "Local Security Settings" applet.
On Windows NT 4.0, do the analogous operation.
[5] Do not use rxvt for this step because the password exchange will not
work properly.
[6] Clean postmaster shutdown will only work with a post Cygwin 1.3.2
snapshot from 2001-Jul-28 or later.
[7] Cygwin's bin directory (e.g., C:\Cygwin\bin) must be added to the
Windows NT/2000's system PATH and the machine rebooted for the SCM
to find cygwin1.dll.
[8] Actually, psql can run under any user account.
[9] One can use PostgreSQL's createuser command or set PGUSER to obviate
the need to specify "-U postgres" on the psql command line.
[10] Assumes that ntsec is set via the CYGWIN environment variable.

10.Re:关于postgreSQL安装 [Re: mayutao]	Copy to clipboard
Posted by: Julian13 Posted on: 2003-03-02 22:21 thx. let me try your step when back to office :>