Java开发网 - Re:关于postgreSQL安装

Java开发网

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate

打印话题 寄给朋友 订阅主题

作者

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

sho

发贴: 99
积分: 88

于 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.

• CJSDNer6月14日北京聚会花絮

话题树型展开

人气	标题	作者	字数	发贴时间
10844	关于postgreSQL安装	mayutao	51	2003-02-20 01:04
9766	Re:关于postgreSQL安装	Julian13	401	2003-02-22 02:58
9952	Re:关于postgreSQL安装	sho	174	2003-02-25 17:52
9923	Re:关于postgreSQL安装	sho	125	2003-02-25 18:07
9638	Re:关于postgreSQL安装	Julian13	233	2003-02-27 13:36
9823	Re:关于postgreSQL安装	sho	244	2003-02-27 15:35
9605	Re:关于postgreSQL安装	Julian13	155	2003-02-28 12:38
9862	Re:关于postgreSQL安装	sho	105	2003-03-02 16:28
9797	Re:关于postgreSQL安装	sho	2682	2003-03-02 20:06
9974	Re:关于postgreSQL安装	Julian13	48	2003-03-02 22:21

已读帖子

新的帖子

被删除的帖子