[참고] MS윈도용 네이티브 바이너리는 공식적으로 PostgreSQL 버전8.0부터 릴리즈되었습니다.
---------------------------------------------------------------------------------------------
http://en.wikipedia.org/wiki/PostgreSQL
PostgreSQL 8.0 (2005.01.19) Release : Native server on Microsoft Windows
MS윈도(MS윈도우)용 네이티브 바이너리 서버가 포스트그레스큐엘(포스트그레에스큐엘) 8.0버전부터 공식적으로 릴리즈되기 시작했습니다.
MS윈도(MS윈도우,Windows XP, WinXP)용 네이티브 바이너리 서버가
포스트그레스큐엘(포스트그레에스큐엘) 8.0버전부터 공식적으로 릴리즈되기 시작했습니다.
---------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------
Windows XP, Cygwin 1.3.22-1, PostgreSQL 7.3.2, CygIPC 1.13.2-1 installation steps
http://archives.postgresql.org/pgsql-cygwin/2003-05/msg00035.php
----------------------------------------------------------------------------------
--------------------------------------------------------------------------
PostgreSQL 7.4 on Windows XP?
http://archives.postgresql.org/pgsql-ports/2004-01/msg00001.php
For anyone having problems with all the different install how to's out there
for postgresql on windows here's one that actual works(for 7.4.1).
Just got up and running in W2k in about 15 minutes.
http://www.tishler.net/jason/software/postgresql/postgresql-7.4.1.README
--------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------
worked perfect: install postgresql-7.4.1 on Windows 2000
http://www.sitepoint.com/forums/showthread.php?170194-worked-perfect-install-postgresql-7-4-1-on-Windows-2000
--------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
http://www.postgresql.org/docs/current/static/release-8-0.html
E.118. Release 8.0 ( Release Date: 2005.01.19. )
E.118.1. Overview
Major changes in this release:
( Microsoft Windows Native Server )
Older releases like Windows 95, Windows 98, and Windows ME are not supported
because these operating systems do not have the infrastructure to support PostgreSQL.
# "PostgreSQL 8.0"은 (윈도98SE)를 지원하지 않는다. #
# MS Windows는 (Win2000 SP4 and later)부터 지원한다. #
# MS Windows는 (Windows2000 SP4 and later)부터 지원한다. #
# MS Windows는 (Windows 2000 SP4 and later)부터 지원한다. #
------------------------------------------------------------------------------------------
# MS윈도우용 네이티브 바이너리 다운로드 #
# ( MS윈도용 바이너리 ) ( for WindowsXP ) ( for WinXP ) ( for Windows7 ) ( for Win7 ) #
EnterpriseDB - The Enterprise PostgreSQL Company :
http://www.enterprisedb.com/products-services-training/pgdownload#windows
postgresql-8.3.18-1-windows.exe :
http://get.enterprisedb.com/postgresql/postgresql-8.3.18-1-windows.exe
------------------------------------------------------------------------------------------
http://archives.postgresql.org
http://www.postgresql.org/download/
라이브씨디 라이브시디 라이브 씨디 라이브 시디
PostgreSQL LiveCD - a Fedora based PostgreSQL liveCD
PostgreSQL Live CD - a Fedora based PostgreSQL live CD
( Last updated: Jan. 09, 2011 )
http://www.pglivecd.org
PostgreSQL RPM Building Project - Live CD
9.0 CentOS version ( PostgreSQL 9.0.2 )
http://www.pglivecd.org/iso/livecd-PG90-CentOS.x86-201101100855.iso
8.4 CentOS version ( PostgreSQL 8.4.3 )
http://www.pglivecd.org/iso/livecd-PG84-CentOS-x86-20100423.iso
8.4 Fedora version ( PostgreSQL 8.4.3 )
http://www.pglivecd.org/iso/livecd-PG84-Fedora-x86-201004241117.iso
--------------------------------------------------------------------------------------------
http://www.tishler.net/jason/software/postgresql/postgresql-7.4.1.README
$Id: README,v 1.46 2003/12/29 15:37:45 jt Exp $
Abstract:
This is the README for the Cygwin PostgreSQL distribution.
PostgreSQL is an advanced Object-Relational database management system (DBMS) that supports almost all SQL constructs (including transactions, subselects and user-defined types and functions).
The Cygwin PostgreSQL package is very monolithic compared its RPM counterparts and its contents is roughly analogous to the aggregation of the following PostgreSQL RPMs:
postgresql-contrib
postgresql-devel
postgresql-docs
postgresql-jdbc
postgresql-libs
postgresql-perl
postgresql-python
postgresql-server
Requirements:
The following packages or later are required to build and/or execute Cygwin PostgreSQL:
crypt 1.0-2
cygipc 2.01-2
cygwin 1.5.5-1
gcc 3.3.1-2
libncurses7 5.3-4
libreadline5 4.3-5
openssl 0.9.7c-1
perl 5.8.0-5
readline 4.3-5
zlib 1.1.4-4
Sun JDK 1.4.1
Ant 1.5
Install:
There are two types of Cygwin PostgreSQL installations -- basic and NT services.
The basic installation is good for casual use on any version of Windows, but required on Windows 9x/Me.
The NT services installation is good for a more production environment, but is only available on Windows NT/2000/XP.
Note that this installation type is very similar to the normal Unix installation with just some Cygwin/Windows variations.
You should choose the type which best meets your needs and/or is constrained by your platform.
Regardless of the installation type, the first step is to start ipc-daemon2.
If ipc-daemon2 is not running or a version previous to 2.01-1 is running, then initdb and postmaster can fail with the error message:
IpcSemaphoreCreate: semget(...) failed: Function not implemented
and
IpcMemoryCreate: shmget(...) failed: Function not implemented
respectively.
The following is the basic Cygwin PostgreSQL installation procedure (skip if using the NT services installation below):
1. Start the cygipc ipc-daemon2:
$ ipc-daemon2 &
2. Initialize PostgreSQL:
$ initdb -D /var/postgresql/data
3. Start the PostgreSQL postmaster:
$ postmaster -D /var/postgresql/data &
4. Connect to PostgreSQL:
$ psql template1
The following is the NT services Cygwin PostgreSQL installation procedure (with footnotes designated by "[n]"):
1. Install the cygipc ipc-daemon2 as a NT service:
# ipc-daemon2 --install-as-service
2. Create the "postgres" user account:
# net user postgres $password /add /fullname:postgres /comment:'PostgreSQL user account' /homedir:"$(cygpath -w /home/postgres)" # [11]
# mkpasswd -l -u postgres >>/etc/passwd
3. Grant the "postgres" user the "Log on as a service" user right:
# cmd /c secpol.msc # [3] [4] [5] [12]
4. Install postmaster as a NT service:
# cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /var/postgresql/data -i" --dep ipc-daemon2 --termsig INT --user postgres --shutdown # [6]
5. Create the PostgreSQL data directory:
# mkdir -p /var/postgresql/data
6. Change ownership of the PostgreSQL data directory:
# chown postgres /var/postgresql/data # [10]
7. Start the cygipc ipc-daemon2:
# cygrunsrv -S ipc-daemon2 # [7]
8. Initialize PostgreSQL (*when running under the "postgres" account*):
$ initdb -D /var/postgresql/data
9. Start postmaster:
# cygrunsrv -S postmaster # [7]
10. Verify postmaster is running:
# cygrunsrv -Q postmaster [13]
11. 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] Sorry, but I don't know of a generally available command line way of setting user rights.
[4] On Windows 2000 and XP Pro, this starts the "Local Security Settings" applet.
On Windows NT 4.0, start User Manager, select Policies, and then select User Rights...
[5] See http://support.microsoft.com/default.aspx?scid=KB;en-us;q259733 for a Microsoft KB article explaining how to configure user rights.
[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.
[11] $password is the password for the postgres user account.
[12] On Windows XP Home, there is no built in way to assign user rights -- use editrights instead:
$ editrights -u postgres -a SeServiceLogonRight
[13] If postmaster fails to start, then examine /var/log/postmaster.log and/or the NT Event Log.
Source:
As configured, the PostgreSQL source builds OOTB under Cygwin.
I also added the following files to the source archive:
CYGWIN-PATCHES/README
CYGWIN-PATCHES/build.sh
and renamed the original source archive to match Cygwin's setup.exe naming conventions.
Build:
This distribution has been configured as follows:
configure --enable-multibyte --with-python --with-perl --with-java --with-CXX --with-openssl --prefix=/usr --sysconfdir=/etc --datadir=/usr/share --mandir=/usr/share/man --includedir=/usr/include/postgresql --docdir=/usr/share/doc/postgresql-$version
where $version is the PostgreSQL version (e.g., 7.3).
See CYGWIN-PATCHES/build.sh in the source archive for my exact build recipe for configuring, making, and packaging this distribution.
Test:
On NT/2000/XP, Cygwin PostgreSQL passes all regression tests (i.e., make installcheck).
On 9X/ME, it has been reported that Cygwin PostgreSQL hangs at random places during the regression test. Unfortunately, at the time of this writing, no one has tracked down the root cause of these hangs.
Issues:
1. make check can generate spurious regression test failures due to overflowing the the listen() backlog queue which generates connection refused errors.
Note that make installcheck does not have this problem since it runs all tests sequentially instead of in large concurrent groups.
2. It is recommended to delete all cygipc temporary files (/tmp/cygipc* and /tmp/MultiFile*) before starting postmaster under a different user account.
Otherwise, postmaster will fail to start due to IPC errors.
Note cygipc 2.x automatically removes these files during normal shutdown so this issue has been essentially obviated.
3. Cygwin PostgreSQL only supports the "C" locale because Cygwin itself does not fully support locales.
4. Cygwin PostgreSQL can fail to start or not function properly if certain files and directories have incorrect permissions. The following usually solves these kinds of problems:
$ chmod a+rwx /tmp
$ chmod a+rx /usr/bin /usr/bin/*
$ chmod a+rw /var/log # could adversely affect other daemons
Homepage:
The primary PostgreSQL web site is:
http://www.postgresql.org
Download:
The primary PostgreSQL ftp site is:
ftp://ftp.postgresql.org
Mailing Lists:
Please report problems, suggestions, etc. dependent on their nature to one of the following:
pgsql-cygwin@postgresql.org
cygwin@cygwin.com
Maintainer:
Jason Tishler <jason@tishler.net>
--------------------------------------------------------------------------------------------
|