Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner AT cygwin DOT com Mail-Followup-To: cygwin AT cygwin DOT com Delivered-To: mailing list cygwin AT cygwin DOT com Message-ID: <4129CFFB.3060608@x-ray.at> Date: Mon, 23 Aug 2004 13:07:39 +0200 From: Reini Urban User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.8a2) Gecko/20040714 MIME-Version: 1.0 To: pgsql-cygwin AT postgresql DOT org CC: cygwin AT cygwin DOT com Subject: Re: initdb and postgres both no longer work... References: <1093136712 DOT 4127f1486ac8d AT imp DOT webmail DOT hku DOT hk> In-Reply-To: <1093136712.4127f1486ac8d@imp.webmail.hku.hk> Content-Type: multipart/mixed; boundary="------------060206010202000406020606" X-IsSubscribed: yes --------------060206010202000406020606 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit tsfu AT graduate DOT hku DOT hk schrieb: > initdb now works. > Does it mean that we should use cygserver with CYGWIN=server and forget about > ipc-daemon2 from now on. BTW: /usr/share/doc/postgresql-7.4.3/FAQ_MSWIN still has the wrong docs, talking about ipc-daemon2. This should be fixed upstream, and in the CYGWIN-PATCH if not. Attached is the doc patch, which talks about cygserver, replacing ipc-daemon2, points to /usr/share/doc/Cygwin/postgresql-.README to avoid duplication, and uses the new default paths /usr/share/postgresql replacing /var/postgresql/data, and points to /var/log/postmaster.log I didn't say anything about locale issues yet, which also changed. (new --enable-multibyte) -- Reini Urban http://xarch.tu-graz.ac.at/home/rurban/ --------------060206010202000406020606 Content-Type: text/plain; name="FAQ_MSWIN-7.4.3.patch" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="FAQ_MSWIN-7.4.3.patch" --- /usr/share/doc/postgresql-7.4.3/FAQ_MSWIN.orig 2004-06-17 13:02:43.001000000 +0100 +++ /usr/share/doc/postgresql-7.4.3/FAQ_MSWIN 2004-08-23 12:05:44.528857400 +0100 @@ -1,10 +1,12 @@ How to install PostgreSQL on Windows ==================================== -$Date: 2004/03/05 19:57:20 $ +$Date: 2004-08-23 12:59:17 $ PostgreSQL requires the appropriate subset of Cygwin DLLs to be installed in order that it functions under Windows. +Recent PostgreSQL releases require at least CYGWIN v1.5 +with cygserver support, replacing ipc-daemon2. This document assumes that you do not have Cygwin already installed on your system. If that is not the case, then you will need to @@ -26,37 +28,45 @@ Cygwin. 3. Once the download and install process is complete, open a Cygwin - shell and do the following for a basic installation: + shell and do the basic cygwin installation: - 3a. Start ipc-daemon2 for shared memory support. To do this, - enter the command "ipc-daemon2 &". This program - needs to be running anytime you start the PostgreSQL server - (postmaster) or initialize a database (initdb). + Read the cygwin specific installation instruction. There is + described how to start the cygserver daemon, initialize the + database, and start the postmaster daemon. - 3b. Use the initdb command to create a new database cluster. An - example command would be: + less /usr/share/doc/Cygwin/postgresql-.README - initdb -D /usr/local/pgsql/data -W -E LATIN1 + In short: - Which will create a cluster in the /usr/local/pgsql/data - directory, will prompt for a superuser password and will - set the default database encoding to LATIN1. + 3a. Install and configure cygserver. The CYGWIN variable + must contain "server". - 3c. Start up the postmaster. Use a command similar to the - following: + $ cygserver-config - postmaster -D /usr/local/pgsql/data + 3b. Start cygserver: - This will start the postmaster, and if successful you will - see some initial log entries, and an entry "LOG: database - system is ready". + $ cygserver & + + 3c. Initialize PostgreSQL: + + $ initdb -D /usr/share/postgresql/data + + 3d. Start the PostgreSQL postmaster: + + $ postmaster -D /usr/share/postgresql/data & + + 3e. Connect to PostgreSQL: + + $ psql template1 + + 3f. Examine /var/log/postmaster.log 4. You are now running a PostgreSQL server on your Windows machine. -5. It is possible to install ipc-daemon2 and the postmaster as +5. It is possible to install cygserver and the postmaster as Windows NT services. For information on how to do this, please - refer to the README document included with Cygwin PostgreSQL. It - is installed in the /usr/share/doc/Cygwin directory. + refer to the same README document included with Cygwin PostgreSQL. + It is installed in the /usr/share/doc/Cygwin directory. Building from source -------------------- --------------060206010202000406020606 Content-Type: text/plain; charset=us-ascii -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/ --------------060206010202000406020606--