delorie.com/archives/browse.cgi   search  
Mail Archives: cygwin/2004/08/23/07:08:09

Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
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 <rurban AT x-ray DOT at>
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>
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-<VERSION>.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-<VERSION>.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--

- Raw text -


  webmaster     delorie software   privacy  
  Copyright © 2019   by DJ Delorie     Updated Jul 2019