Trying Cygwin version of PostgreSQL

Peter <peter@helpnet.com.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@sss.pgh.pa.us> wrote:

Peter <peter@helpnet.com.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@postgresql.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

Hi Paul,

You might like to try the very good installation guide for PostgreSQL on
Windows at :

http://www.ejip.net/faq/postgresql_win_setup_faq.jsp

Added a link to it from the techdocs.postgresql.org website earlier
today too.

:-)

Regards and best wishes,

Justin Clift

On Thursday 21 February 2002 23:37, Paul Rowland wrote:

Great! But where is the documentation on doing this
stuff? I'd like to try.

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

Peter <peter@helpnet.com.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@postgresql.org

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

Justin Clift suggested:
http://www.ejip.net/faq/postgresql_win_setup_faq.jsp
I started from scratch following the page and adapting it where it is
out of date. I reached the stage of starting postmaster and receiving
the message:
DEBUG: pq_recvbuf: unexpected EOF on client connection
DEBUG: incomplete startup packet

Peter

Peter wrote:

Justin Clift suggested:
http://www.ejip.net/faq/postgresql_win_setup_faq.jsp
I started from scratch following the page and adapting it where it is
out of date. I reached the stage of starting postmaster and receiving
the message:
DEBUG: pq_recvbuf: unexpected EOF on client connection
DEBUG: incomplete startup packet

Aww Rats.

I'll try it tonight and see how it goes for me.

Did you use PostgreSQL 7.2 or 7.1.3?

:-)

Regards and best wishes,

Justin Clift

Peter

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

Peter <peter@helpnet.com.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

Hi Peter,

Haven't yet had the time to properly try this out. Did a quick initial
installation of PostgreSQL 7.2 with cygwin 1.3.9, and got the same error as
yourself.

I've had reports of PostgreSQL 7.1.3 working on cygwin however, but haven't
gotten around to trying that myself yet. There is a possibility that the 7.2
version of PostgreSQL that's made for cygwin might not yet be at a point
where it should be, due to PostgreSQL 7.2 only very recently being released.

There is a PostgreSQL "cygwin" mailing list which you can subscribe to and
ask the guys there about, and this sounds like it might be the best avenue
for you :

http://www.ca.postgresql.org/users-lounge/index.html

Hoping that helps.

:-)

Regards and best wishes,

Justin Clift