Re: Win XP Install README

Seth,

On Tue, Jul 08, 2003 at 02:04:35PM -0400, Seth Rubin wrote:
> Besides being a developer, business owner, etc., I also do tech
> writing.

Since you do tech writing...

> Rather than make it "perfect", I just added a few tweaks that should:

Why not make it "perfect?" :,)

> I took the latest cygwin postgresql-7.3.3.README and made a few minor
> revisions based on what I had to do to make postgresql work with my XP
> Home edition, and based on your and Frank Seesink's posts. Hopefully
> this should result in fewer redundant queries from those installing on
> WinXP.

Just for the record and the archives, does PostgreSQL run properly as a
service under XP Home?

> 1 - make it easy to compare to the original (you're busy enough
> already)

I would have preferred a patch instead:

$ cp /usr/doc/Cygwin/postgresql-7.3.3.README postgresql-7.3.3.README.orig
$ # edit postgresql-7.3.3.README
$ diff -up postgresql-7.3.3.README.orig postgresql-7.3.3.README >postgresql-7.3.3.README.diff

> [snip]
> -- Added footnote "[13]" to item 2 (creating the postgres account)
>
> [13] Where necessary, grant Postgres access to cygwin's /tmp and
> /usr/bin files.
> E.g.
> $ chmod 777 /tmp
> $ chmod a+rx /usr/bin /usr/bin/*

I will add the above to the next version of the README.

> -- Under footnote [12], the one about ntrights under XP Home, added:
>
> Usage: ntrights -u postgres +r SeServiceLogonRight

Ditto.

> -- Added footnote "[14]" to item 8 (Initialize postgresql from
> postgres account)
>
> [14] Do not use "Switch User" to change accounts - log out
> completely and then log back in. This avoids Windows bug in
> Terminal Services.

The above is no longer necessary. cygipc now supports Fast User
Switching.

> -- Added footnote "[15]" to item 9 (start postmaster):
>
> [15] If postmaster service fails to start, examine
> /var/log/postmaster.log

I will add the above to the next version of the README.

> -- Added footnote "[16]" to item 10 (Connect to PostgreSQL):
>
> [16] For cygwin 1.3.22-1 and below, a bug prevents this from working
^^^^^^^^^
> from accounts other than "postgres". You can work around this
> using TCP/IP connection (instead of default AF_UNIX) or replacing
> your /usr/bin/cygwin1.dll file with recent .dll snapshot from
> http://cygwin.com/snapshots (unpack with bunzip2)

The "and below" is not quite correct. This problem was introduced in
1.3.21 or one or two point releases earlier. Hence, there is only a
"small" when this doesn't work.

I will add a modified version of the above to the next version of the
README.

> -- Changed "The following is the basic Cygwin PostgreSQL installation
> procedure:",
> to:
> Manual Cygwin PostgreSQL installation procedure:
> (skip for recommended NT services Cygwin PostgreSQL installation)
>
> This last wasn't strictly necessary, but I noticed that there were
> others, beside myself, who followed the basic procedure, then hit
> ourselves for not realizing the "real" procedure was after it.

Ditto.

> Hope this all makes your (and everybody else's) life a bit easier.

It should. I really appreciate your help.

Thanks,
Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6