Attention PostgreSQL maintainer

Attention PostgreSQL maintainer

[Keith Christian]

[-- Attachment #1: Type: text/plain, Size: 241 bytes --]

Marco,

I've written a short updated quick start guide for PostgreSQL on Cygwin.

It is attached, (cygwin_postgresql_9_6_5_quick_start_example.txt.)

You're free to use it if you think it will be helpful for the README
or elsewhere.


Keith

[-- Attachment #2: cygwin_postgresql_9_6_5_quick_start_example.txt --]
[-- Type: text/plain, Size: 5294 bytes --]


----------------------------------------------------------------------
Updated Quick Start for PostgreSQL under Cygwin 2.9.0, under Windows 7
Sat Oct 28 16:24:15 MDT 2017
----------------------------------------------------------------------




---------------------------
Windows Version Information
---------------------------
	Sat Oct 28 15:30:34 pty1 (keith@somemachine) /home/keith>uname -a

	CYGWIN_NT-6.1-WOW somemachine 2.9.0(0.318/5/3) 2017-09-12 10:41 i686 Cygwin

	Sat Oct 28 15:30:40 pty1 (keith@somemachine) /home/keith>wmic os get buildnumber,caption,CSDVersion /format:csv

	Node,BuildNumber,Caption,CSDVersion
	somemachine,7601,Microsoft Windows 7 Enterprise ,Service Pack 1




-----------------
Install cygserver
-----------------
	Sat Oct 28 15:30:48 pty1 (keith@somemachine) /home/keith>/bin/cygserver-config
	Generating /etc/cygserver.conf file


	Warning: The following function requires administrator privileges!

	Do you want to install cygserver as service?
	(Say "no" if it's already installed as service) (yes/no) yes

	The service has been installed under LocalSystem account.
	To start it, call `net start cygserver' or `cygrunsrv -S cygserver'.

	Further configuration options are available by editing the configuration
	file /etc/cygserver.conf.  Please read the inline information in that
	file carefully. The best option for the start is to just leave it alone.

	Basic Cygserver configuration finished. Have fun!




---------------
Start cygserver
---------------
	Sat Oct 28 16:00:27 pty1 (keith@somemachine) /home/keith>cygrunsrv -S cygserver




------------------------------------
Initialize PostgreSQL data directory
------------------------------------
	Sat Oct 28 16:04:03 pty1 (keith@somemachine) /home/keith>/usr/sbin/initdb.exe -D /usr/share/postgresql/data
	The files belonging to this database system will be owned by user "keith".
	This user must also own the server process.

	The database cluster will be initialized with locale "C".
	The default database encoding has accordingly been set to "SQL_ASCII".
	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




----------------
Start PostgreSQL
----------------
	Sat Oct 28 16:04:47 pty1 (keith@somemachine) /home/keith>/usr/sbin/pg_ctl -D /usr/share/postgresql/data -l logfile start
	server starting




--------------------------------------------
PostgreSQL is now running, create a database
--------------------------------------------
	Sat Oct 28 16:05:20 pty1 (keith@somemachine) /home/keith>createdb




----------------------------------------------------------------------------
Start psql, the PostgreSQL command line client, and run a few sample queries
----------------------------------------------------------------------------
	Sat Oct 28 16:05:45 pty1 (keith@somemachine) /home/keith>psql
	psql (9.6.5)
	Type "help" for help.

	keith=# select version();
					 version
	-------------------------------------------------------------------------
	 PostgreSQL 9.6.5 on i686-pc-cygwin, compiled by gcc (GCC) 6.4.0, 32-bit
	(1 row)


	keith=# \c template1
	You are now connected to database "template1" as user "keith".
	template1=# select version();
					 version
	-------------------------------------------------------------------------
	 PostgreSQL 9.6.5 on i686-pc-cygwin, compiled by gcc (GCC) 6.4.0, 32-bit
	(1 row)

	template1=# select now();
		      now
	-------------------------------
	 2017-10-28 16:07:13.462488-06
	(1 row)

	template1=# select 1.0/.3;
	      ?column?
	--------------------
	 3.3333333333333333
	(1 row)

	template1=# \l
					 List of databases
	    Name    |   Owner    | Encoding  | Collate | Ctype |     Access privileges
	------------+------------+-----------+---------+-------+---------------------------
	 keith      | keith | SQL_ASCII | C       | C     |
	 postgres   | keith | SQL_ASCII | C       | C     |
	 template0  | keith | SQL_ASCII | C       | C     | =c/keith            +
		    |       |           |         |       | keith=CTc/keith
	 template1  | keith | SQL_ASCII | C       | C     | =c/keith            +
		    |       |           |         |       | keith=CTc/keith
	(4 rows)




-------------------------------------------------
Quit the PSQL command line client, back to the OS
-------------------------------------------------
	template1=# \q




Sat Oct 28 16:13:14 pty1 (keith@somemachine) /home/keith>


[-- Attachment #3: Type: text/plain, Size: 219 bytes --]


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

Re: Attention PostgreSQL maintainer

[Marco Atzeri]

On 29/10/2017 00:38, Keith Christian wrote:
> Marco,
> 
> I've written a short updated quick start guide for PostgreSQL on Cygwin.
> 
> It is attached, (cygwin_postgresql_9_6_5_quick_start_example.txt.)
> 
> You're free to use it if you think it will be helpful for the README
> or elsewhere.
> 
> 
> Keith
> 
> 

Noted.

Regards
Marco

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

Re: Attention PostgreSQL maintainer

[Henry S. Thompson]

Keith Christian writes:

> I've written a short updated quick start guide for PostgreSQL on Cygwin.

Thanks for this, but it's for Windows 7, and will not (at least AFAICT)
work on Windows 10.  I'll try to provide a W10 narrative if I can
recover it from my history...

ht
-- 
       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@inf.ed.ac.uk
                       URL: http://www.ltg.ed.ac.uk/~ht/
 [mail from me _always_ has a .sig like this -- mail without it is forged spam]

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

Re: Attention PostgreSQL maintainer

[Henry S. Thompson]

[-- Attachment #1: Type: text/plain, Size: 568 bytes --]

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


[-- Attachment #2: Postgresql install notes for Cygwin --]
[-- Type: text/plain, Size: 2911 bytes --]

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]

[-- Attachment #3: Type: text/plain, Size: 354 bytes --]

-- 
       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@inf.ed.ac.uk
                       URL: http://www.ltg.ed.ac.uk/~ht/
 [mail from me _always_ has a .sig like this -- mail without it is forged spam]


[-- Attachment #4: Type: text/plain, Size: 219 bytes --]


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

Re: Attention PostgreSQL maintainer

[Keith Christian]

[-- Attachment #1: Type: text/plain, Size: 4817 bytes --]

Henry,

Your "install as as a service" steps above are successful!


kcdb=# select version();
                                 version
-------------------------------------------------------------------------
 PostgreSQL 9.6.5 on i686-pc-cygwin, compiled by gcc (GCC) 6.3.0, 32-bit
(1 row)


uname -a
CYGWIN_NT-6.1-WOW HQSWD-C009223 2.9.0(0.318/5/3) 2017-09-12 10:41 i686 Cygwin


Steps I took and all CLI output is attached as
configure_postgresql_under_cygwin_20171030_162047.txt.

Keith

On Sun, Oct 29, 2017 at 2:38 PM, Henry S. Thompson <ht@inf.ed.ac.uk> wrote:
> 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
>
>
> 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@inf.ed.ac.uk
>                        URL: http://www.ltg.ed.ac.uk/~ht/
>  [mail from me _always_ has a .sig like this -- mail without it is forged spam]
>
>
>
> --
> 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

[-- Attachment #2: configure_postgresql_under_cygwin_20171030_162047.txt --]
[-- Type: text/plain, Size: 9067 bytes --]


Commands (only) which run in the verbose section below:

		$ locate postgresql.conf
		$ vi /etc/rc.d/init.d/postgresql
		$ cp -pv /etc/rc.d/init.d/postgresql /etc/rc.d/init.d/orig.postgresql
		$ vi /etc/rc.d/init.d/postgresql
		$ diff -w /etc/rc.d/init.d/orig.postgresql /etc/rc.d/init.d/postgresql
		$ cygrunsrv -L
		$ cygrunsrv -Q cygserver
		$ /etc/rc.d/init.d/postgresql initdb
		$ /etc/rc.d/init.d/postgresql install
		$ /etc/rc.d/init.d/postgresql start
		$ pgrep -fl postgres
		$ handle -a postgres
		$ psql -U SYSTEM postgres
		postgres=# ALTER ROLE "SYSTEM" WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION;
		postgres=# CREATE ROLE keith;
		postgres=# ALTER ROLE keith WITH SUPERUSER INHERIT NOCREATEROLE CREATEDB LOGIN NOREPLICATION;
		postgres=# \q
		$ psql -U keith postgres
		postgres=# \l
		postgres=# CREATE DATABASE kcdb WITH TEMPLATE=template0 OWNER=keith;
		postgres=# \q
		$ psql -U keith kcdb
		kcdb=# \l
		kcdb=# \d+
		kcdb=# \l+
		kcdb=# select now();
		kcdb=# select version();
		kcdb=# select 1.00/0.3;
		kcdb=# \q

Mon Oct 30 16:03:07 pty2 (keith@somemachine) ~>locate postgresql.conf
/cygdrive/c/cygwin/usr/share/amanda/example/amanda-client-postgresql.conf
/cygdrive/c/cygwin/usr/share/postgresql/postgresql.conf.sample

Mon Oct 30 16:06:02 pty2 (keith@somemachine) ~>vi /etc/rc.d/init.d/postgresql

Mon Oct 30 16:07:07 pty2 (keith@somemachine) ~>cp -pv /etc/rc.d/init.d/postgresql /etc/rc.d/init.d/orig.postgresql
'/etc/rc.d/init.d/postgresql' -> '/etc/rc.d/init.d/orig.postgresql'

Mon Oct 30 16:07:15 pty2 (keith@somemachine) ~>vi /etc/rc.d/init.d/postgresql

Mon Oct 30 16:17:37 pty2 (keith@somemachine) ~>diff -w /etc/rc.d/init.d/orig.postgresql /etc/rc.d/init.d/postgresql
32c32
< DAEMON="$progdir/$prog.exe"
---
> DAEMON="$progdir/$prog"


Mon Oct 30 16:08:44 pty2 (keith@somemachine) ~>cygrunsrv -L
BrlAPI
cygserver

Mon Oct 30 16:09:10 pty2 (keith@somemachine) ~>cygrunsrv -Q cygserver
Service             : cygserver
Display name        : CYGWIN cygserver
Current State       : Running
Controls Accepted   : Stop
Command             : /usr/sbin/cygserver


Mon Oct 30 16:09:22 pty2 (keith@somemachine) ~>/etc/rc.d/init.d/postgresql initdb
The files belonging to this database system will be owned by user "keith".
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

done.

Mon Oct 30 16:10:40 pty2 (keith@somemachine) ~>/etc/rc.d/init.d/postgresql install
- cygserver OK - Installing PostgreSQL daemon: done.

Mon Oct 30 16:11:41 pty2 (keith@somemachine) ~>/etc/rc.d/init.d/postgresql start
Starting PostgreSQL: - cygserver OK - done.

Mon Oct 30 16:11:54 pty2 (keith@somemachine) ~>pgrep -fl postgres
13248 postgres
31360 postgres
31524 postgres
17572 postgres
31372 postgres
10520 postgres

Mon Oct 30 16:12:02 pty2 (keith@somemachine) ~>handle -a postgres

Nthandle v4.1 - Handle viewer
Copyright (C) 1997-2016 Mark Russinovich
Sysinternals - www.sysinternals.com

postgres.exe       pid: 29628  type: File           124: C:\cygwin\var\log\postgresql.log
postgres.exe       pid: 29628  type: File           12C: C:\cygwin\usr\share\postgresql\data
postgres.exe       pid: 29628  type: File           130: C:\cygwin\var\log\postgresql.log
postgres.exe       pid: 31360  type: File           124: C:\cygwin\var\log\postgresql.log
postgres.exe       pid: 31360  type: File           12C: C:\cygwin\usr\share\postgresql\data
postgres.exe       pid: 31360  type: File           130: C:\cygwin\var\log\postgresql.log
postgres.exe       pid: 10520  type: File           124: C:\cygwin\var\log\postgresql.log
postgres.exe       pid: 10520  type: File           12C: C:\cygwin\usr\share\postgresql\data
postgres.exe       pid: 10520  type: File           130: C:\cygwin\var\log\postgresql.log
postgres.exe       pid: 17572  type: File           124: C:\cygwin\var\log\postgresql.log
postgres.exe       pid: 17572  type: File           12C: C:\cygwin\usr\share\postgresql\data
postgres.exe       pid: 17572  type: File           130: C:\cygwin\var\log\postgresql.log
postgres.exe       pid: 31372  type: File           124: C:\cygwin\var\log\postgresql.log
postgres.exe       pid: 31372  type: File           12C: C:\cygwin\usr\share\postgresql\data
postgres.exe       pid: 31372  type: File           130: C:\cygwin\var\log\postgresql.log
postgres.exe       pid: 31372  type: File           1A4: C:\cygwin\usr\share\postgresql\data\global\1262
postgres.exe       pid: 13248  type: File           124: C:\cygwin\var\log\postgresql.log
postgres.exe       pid: 13248  type: File           12C: C:\cygwin\usr\share\postgresql\data
postgres.exe       pid: 13248  type: File           130: C:\cygwin\var\log\postgresql.log

Mon Oct 30 16:12:09 pty2 (keith@somemachine) ~>psql -U SYSTEM postgres
psql (9.6.5)
Type "help" for help.

postgres=# ALTER ROLE "SYSTEM" WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION;
ALTER ROLE
postgres=# CREATE ROLE keith;
CREATE ROLE
postgres=# ALTER ROLE keith WITH SUPERUSER INHERIT NOCREATEROLE CREATEDB LOGIN NOREPLICATION;
ALTER ROLE
postgres=# \q

Mon Oct 30 16:14:15 pty2 (keith@somemachine) ~>psql -U keith postgres
psql (9.6.5)
Type "help" for help.

postgres=# \l
                          List of databases
   Name    | Owner  | Encoding  | Collate | Ctype | Access privileges
-----------+--------+-----------+---------+-------+-------------------
 postgres  | SYSTEM | SQL_ASCII | C       | C     |
 template0 | SYSTEM | SQL_ASCII | C       | C     | =c/SYSTEM        +
           |        |           |         |       | SYSTEM=CTc/SYSTEM
 template1 | SYSTEM | SQL_ASCII | C       | C     | =c/SYSTEM        +
           |        |           |         |       | SYSTEM=CTc/SYSTEM
(3 rows)

postgres=# CREATE DATABASE kcdb WITH TEMPLATE=template0 OWNER=keith;
CREATE DATABASE
postgres=# \q

Mon Oct 30 16:21:38 pty2 (keith@somemachine) ~>psql -U keith kcdb
psql (9.6.5)
Type "help" for help.

kcdb=# \l
                            List of databases
   Name    |   Owner    | Encoding  | Collate | Ctype | Access privileges
-----------+------------+-----------+---------+-------+-------------------
 kcdb      | keith      | SQL_ASCII | C       | C     |
 postgres  | SYSTEM     | SQL_ASCII | C       | C     |
 template0 | SYSTEM     | SQL_ASCII | C       | C     | =c/SYSTEM        +
           |            |           |         |       | SYSTEM=CTc/SYSTEM
 template1 | SYSTEM     | SQL_ASCII | C       | C     | =c/SYSTEM        +
           |            |           |         |       | SYSTEM=CTc/SYSTEM
(4 rows)

kcdb=# \l+
                                                              List of databases
   Name    |   Owner    | Encoding  | Collate | Ctype | Access privileges |  Size   | Tablespace |                Description
-----------+------------+-----------+---------+-------+-------------------+---------+------------+--------------------------------------------
 kcdb      | keith      | SQL_ASCII | C       | C     |                   | 7245 kB | pg_default |
 postgres  | SYSTEM     | SQL_ASCII | C       | C     |                   | 7245 kB | pg_default | default administrative connection database
 template0 | SYSTEM     | SQL_ASCII | C       | C     | =c/SYSTEM        +| 7153 kB | pg_default | unmodifiable empty database
           |            |           |         |       | SYSTEM=CTc/SYSTEM |         |            |
 template1 | SYSTEM     | SQL_ASCII | C       | C     | =c/SYSTEM        +| 7153 kB | pg_default | default template for new databases
           |            |           |         |       | SYSTEM=CTc/SYSTEM |         |            |
(4 rows)

kcdb=# select now();
              now
-------------------------------
 2017-10-30 16:22:11.230924-06
(1 row)

kcdb=# select version();
                                 version
-------------------------------------------------------------------------
 PostgreSQL 9.6.5 on i686-pc-cygwin, compiled by gcc (GCC) 6.3.0, 32-bit
(1 row)

kcdb=# select 1.00/0.3;
      ?column?
--------------------
 3.3333333333333333
(1 row)

kcdb=# \q



[-- Attachment #3: Type: text/plain, Size: 219 bytes --]


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

Re: Attention PostgreSQL maintainer

[Keith Christian]

Woops, I apologize for top-posting.

Keith

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

Re: Attention PostgreSQL maintainer

[Marco Atzeri]

On 30/10/2017 23:45, Keith Christian wrote:
> Henry,
> 
> Your "install as as a service" steps above are successful!

Keith , Henry,
I am adding your notes to the README

and modified the /etc/rc.d/init.d/postgresql
as suggested.

9.6.6 should be up shortly, and I plan to add 10.1
as test in the near future.


Thanks both
Marco



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

Re: Attention PostgreSQL maintainer

[Keith Christian]

You're welcome Marco, thanks for incorporating our comments.  I've
always found this one of the more helpful mailing lists.  One small
way that we users can help the very busy maintainers.

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

Re: Attention PostgreSQL maintainer

[Keith Christian]

Marco,

I believe lines 57 through 124 of the latest
/usr/share/doc/Cygwin/postgresql.README are courtesy of the good Henry
S. Thompson.

Lines 129 to the end of /usr/share/doc/Cygwin/postgresql.README are
those that I contributed to the cause.

wc /usr/share/doc/Cygwin/postgresql.README
  343  1444 13064 /usr/share/doc/Cygwin/postgresql.README

Henry, do you concur?

Keith

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

Re: Attention PostgreSQL maintainer

[Henry S. Thompson]

Keith Christian writes:

> I believe lines 57 through 124 of the latest
> /usr/share/doc/Cygwin/postgresql.README are courtesy of the good Henry
> S. Thompson.
>
> Lines 129 to the end of /usr/share/doc/Cygwin/postgresql.README are
> those that I contributed to the cause.
>
> wc /usr/share/doc/Cygwin/postgresql.README
>   343  1444 13064 /usr/share/doc/Cygwin/postgresql.README
>
> Henry, do you concur?

Yes, the first set of notes are the ones I sent.

ht
-- 
       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@inf.ed.ac.uk
                       URL: http://www.ltg.ed.ac.uk/~ht/
 [mail from me _always_ has a .sig like this -- mail without it is forged spam]

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