Re: Now trying Cygwin with normal download of PostgreSQL

Hello PostgreSQL,
I am trying to install the PostgreSQL 7.2 downloaded by Cygwin but the
install does not match any of the documentation. Help!

Last year I installed PostgreSQL 7.1 on NT for a one off project then
deleted it. I used the pg download then added Cygwin using the Cygwin
download. Everything worked after I put together documentation from
several included files, a few web pages and lots of experiments.

This time I am attempting to use the Cygwin download including
PostgreSQL. The documentation is scattered over several documents and
none match the actual installation process.

I resorted to trial and error. Initdb hangs when "Creating template1
database" so there must be a step missing. Given the many "try this"
paragraphs across several documents, I estimate the number of
combinations will exceed the storage capacity of a 32 bit integer.

Should I give up on Cygwin and go back to what I did last time? Is there
a document or web page that describes a successful installation step by
step?

Peter

Peter <peter(at)helpnet(dot)com(dot)au> writes:
> I resorted to trial and error. Initdb hangs when "Creating template1
> database" so there must be a step missing.

I think you forgot to run the cygipc daemon.

regards, tom lane

Great! But where is the documentation on doing this
stuff? I'd like to try.
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Peter <peter(at)helpnet(dot)com(dot)au> writes:
> > I resorted to trial and error. Initdb hangs when
> "Creating template1
> > database" so there must be a step missing.
>
> I think you forgot to run the cygipc daemon.
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo(at)postgresql(dot)org

__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com

I have the latest Cygwin and PostgreSQL 7.2. Using the installation
instructions at http://people.freebsd.org/~kevlo/postgres/portNT.html,
make produces the messages:
pg_passwd.o(.text+0x763):pg_passwd.c: undefined reference to 'crypt'
collect2: ld returned 1 exit status
make[3]: *** [pg_passwd] Error 1

The installation using the standalone PostgreSQL download works better
than trying to install the Cygwin version. The target of this project is
to install SQL-ledger but, if PostgreSQL works well, I might use it for
other projects.

The reason I persevere on NT is I need solutions that work on NT,
Solaris, and Linux. MySQL, using Berkeley tables for transactions, does
work on all those platforms but I hear the Berkeley tables use page
locking instead of row locking. Oracle is an easy to deploy alternative
but I am not about to pay $40,000 for an Oracle licence just so I can
perform a few hours development each month. What I need is a bullet
proof way of installing PostgreSQL on NT.

Peter

Peter <peter(at)helpnet(dot)com(dot)au> writes:
> I have the latest Cygwin and PostgreSQL 7.2. Using the installation
> instructions at http://people.freebsd.org/~kevlo/postgres/portNT.html,
> make produces the messages:
> pg_passwd.o(.text+0x763):pg_passwd.c: undefined reference to 'crypt'

If you can figure out *why* that happens, we'll be glad to apply the fix
in future versions, but there's not a lot we can do about it remotely;
you're going to have to do some of the legwork yourself. (This is open
source software, after all.)

You could start by looking at the configure log (config.log) to see if
it found libcrypt or not. If there is a libcrypt, did it get mentioned
in LIBS in src/Makefile.global? Is it mentioned in the build command
for pg_passwd (which you carefully omitted from your complaint)?

regards, tom lane