Re: Win XP Install README - Mailing list pgsql-cygwin

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