X-Recipient:	archive-cygwin AT delorie DOT com
DomainKey-Signature:	a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:to:subject:references:from:date:in-reply-to
	:message-id:mime-version:content-type; q=dns; s=default; b=IrBUf
	zLdneJxBW0BANWt7r4YRdDSgRChsPQCfMYNFQmNUeFIcreWaKtl/EMmykB+mm8Ef
	q/mozfmum1C4aSu8tQDX1ZaghUkWXt9Hzc+8dmwGMz0nRe94LtaYqogR5iK+AeDJ
	JAfyXnk8QdB2uAOuTvX+9E9kcukl0lq/bPFnbA=
DKIM-Signature:	v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:to:subject:references:from:date:in-reply-to
	:message-id:mime-version:content-type; s=default; bh=+/Dc/jw4XXt
	sP2URrFdDSSKlpss=; b=JVS+opm/lqWi5g5bz2D4Pz4h58TQ2txRnBpiV8sc1Q+
	hgAt2Dlhi7sNinbQ9Co/qmntPx1C2pRW1TEfgp9/ceKpXBhQJblM137ehVz0LAzD
	3Z5xf+5B5gEXzgjTCe1aCJUTAJK7ObuzG8cAJ+DITjeIg3F8h9TDLx+5ck86L+wA
	=
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id:	<cygwin.cygwin.com>
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
Authentication-Results:	sourceware.org; auth=none
X-Virus-Found:	No
X-Spam-SWARE-Status:	No, score=-1.9 required=5.0 tests=AWL,BAYES_00,RP_MATCHES_RCVD,SPF_PASS,T_TVD_MIME_NO_HEADERS autolearn=ham version=3.3.2 spammy=impatient, rcd, professional
X-HELO:	loire.is.ed.ac.uk
To:	cygwin AT cygwin DOT com
Subject:	Re: Attention PostgreSQL maintainer
References:	<CAFWoy7H2G=WPsrrwPiKbG8M9ZsWUZdhekNBWoOcpSHFQruB0Zw AT mail DOT gmail DOT com> <f5befpl938f DOT fsf AT troutbeck DOT inf DOT ed DOT ac DOT uk>
From:	ht AT inf DOT ed DOT ac DOT uk (Henry S. Thompson)
Date:	Sun, 29 Oct 2017 20:38:37 +0000
In-Reply-To:	<f5befpl938f.fsf@troutbeck.inf.ed.ac.uk> (Henry S. Thompson's message of "Sun\, 29 Oct 2017 19\:13\:36 +0000")
Message-ID:	<f5b7evd8zaq.fsf@troutbeck.inf.ed.ac.uk>
User-Agent:	Gnus/5.1012 (Gnus v5.10.12) XEmacs/21.5-b34 (linux)
MIME-Version:	1.0
X-Edinburgh-Scanned:	at loire.is.ed.ac.uk with MIMEDefang 2.78, Sophie, Sophos Anti-Virus, Clam AntiVirus
X-IsSubscribed:	yes

--=-=-=

OK, here's and attempt at a set of install instructions for
  Windows 10 Professional Ver 10.0 Build 14393
  Cygwin DLL version: 2.9.0-3
  Postgresql: 9.6.5-2

I got slightly muddled with the cygserver and postgress
install-as-service steps, so the attached may not quite be right in that
regard, I won't be in a position to do another clean install until next
week to confirm, so happy to hear from someone else who can do so
sooner...

Maintainer: Please note what I believe to be a bug in the current
release which is described/fixed in the second step below.

ht


--=-=-=
Content-Disposition: inline; filename=pg_9.6_install_notes.txt
Content-Description: Postgresql install notes for Cygwin

I was eventually able to follow a modified version of
"For the impatient: install as service (hard)" from
/usr/share/doc/Cygwin/postgresql.README, as follows:

* Dump your old database, if you had a previous installation

* !!!! IMPORTANT!!!: edit /etc/rc.d/init.d/postgresql
   to fix what I believe is a bug as shipped:
   On line 32 or thereabouts, change
    DAEMON="$progdir/$prog.exe"
   --->
    DAEMON="$progdir/$prog"

* Adjust any other (e.g. PATH) settings in /etc/rc.d/init.d/postgresql

* If you had an old installation, move the data directory
  (e.g. /usr/share/postgresql/data) elsewhere, or at least save
  .../data/postgresql.conf somewhere before you delete .../data

* If you don't already have cygserver running as a service:
    > /usr/bin/cygserver-config
    > cygrunsrv --start cygserver

* Initialise Postgresql
    > /etc/rc.d/init.d/postgresql initdb # in an elevated shell
     The files belonging to this database system will be owned by user "[you]".
     This user must also own the server process.

     The database cluster will be initialized with locale "C".
     The default text search configuration will be set to "english".

     Data page checksums are disabled.

     creating directory /usr/share/postgresql/data ... ok
     creating subdirectories ... ok
     selecting default max_connections ... 30
     selecting default shared_buffers ... 128MB
     selecting dynamic shared memory implementation ... posix
     creating configuration files ... ok
     running bootstrap script ... ok
     performing post-bootstrap initialization ... ok
     syncing data to disk ... ok

     WARNING: enabling "trust" authentication for local connections
     You can change this by editing pg_hba.conf or using the option -A, or
     --auth-local and --auth-host, the next time you run initdb.

     [Success. You can now start the database server using:

	 /usr/sbin/pg_ctl -D /usr/share/postgresql/data -l logfile start # ignore this!]

     done.

* If you had a previous install, do a diff between your saved
  postgresql.conf and the new .../data/postgresql.conf and copy over
  any substantive changes you had made and wish to keep

* Install as a service
  > /etc/rc.d/init.d/postgresql install
   - cygserver OK - Installing PostgreSQL daemon: done.
  > /etc/rc.d/init.d/postgresql start

* Cleanup up the initial odd role situation
  > psql -U SYSTEM postgres
   postgres=# ALTER ROLE "SYSTEM" WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION;
   postgres=# CREATE ROLE [yourCygwinLogin];
   postgres=# ALTER ROLE [yourCygwinLogin] WITH SUPERUSER INHERIT NOCREATEROLE CREATEDB LOGIN NOREPLICATION;
   postgres=# \q

* Create a database for yourself
  > psql -U [yourCygwinLogin] postgres
   postgres=# CREATE DATABASE xyzzy WITH TEMPLATE=template0 OWNER=[yourCygwinLogin] ENCODING=....;
   postgres=# \q
  > psql -U [yourCygwinLogin] xyzzy
   [off you go]

--=-=-=

-- 
       Henry S. Thompson, School of Informatics, University of Edinburgh
      10 Crichton Street, Edinburgh EH8 9AB, SCOTLAND -- (44) 131 650-4440
                Fax: (44) 131 650-4587, e-mail: ht AT inf DOT ed DOT ac DOT uk
                       URL: http://www.ltg.ed.ac.uk/~ht/
 [mail from me _always_ has a .sig like this -- mail without it is forged spam]


--=-=-=
Content-Type: text/plain; charset=us-ascii


--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
--=-=-=--

- Raw text -