<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Figured out the problem: I was extracting the
binary with WinZip, which destroyed the symlink. I recreated the link
using:</FONT></DIV>
<DIV><FONT face=Arial size=2>$ ln -s /usr/local/pgsql/bin/postgres.exe
/usr/local/pgsql/bin/postmaster</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>see: <A
href="http://archives2.us.postgresql.org/pgsql-cygwin/2001-05/msg00019.php">http://archives2.us.postgresql.org/pgsql-cygwin/2001-05/msg00019.php</A><A
href="http://archives2.us.postgresql.org/org/pgsql-dygwin/2001-05/msg00019.php"></A></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Now, I have another problem:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If I type in any command such as \l or "select *
from item", I get "less: not found."</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Does anyone know what this is
about?</FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=dougvanauken@worldnet.att.net
href="mailto:dougvanauken@worldnet.att.net">Doug Van Auken</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=postgis@yahoogroups.com
href="mailto:postgis@yahoogroups.com">postgis@yahoogroups.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, November 18, 2001 2:06
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [postgis] Installation on
Windows 2000 using Cygwin</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hello,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am trying to install Postgresql 7.1.3 on
Windows 2000 and Cygwin, using the binaries contained in Cygwin's postgresql
7.1.3 distribution, but I can't get it running.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have the binaries located in
c:/cygwin/local/pgsql/bin. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>After I unpacked the, I did the
following:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I executed the ipc-daemon:</FONT></DIV>
<DIV><FONT face=Arial size=2> <A
href="mailto:Administrator@PHOENIX">Administrator@PHOENIX</A> ~<BR> $
/usr/local/bin/ipc-daemon.exe &<BR> [1] 1516</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I executed the initdb command:</FONT></DIV>
<DIV><FONT face=Arial size=2> <A
href="mailto:Administrator@PHOENIX">Administrator@PHOENIX</A> /bin<BR> $
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Then I ran this command:</FONT></DIV>
<DIV><FONT face=Arial size=2> /usr/local/pgsql/bin/postmaster -D
/usr/local/pgsql/data</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>At this point, I got a message that said: bash:
/usr/local/pgsql/bin/postmaster: No such file or directory</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I don't see any program called postmaster in the
postgresql archive, so I tried substituting "POSTGRES" in place of
"POSTMASTER", as in:</FONT></DIV>
<DIV><FONT face=Arial size=2> $ /usr/local/pgsql/bin/postgres -D
/usr/local/pgsql/data</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>This generated the following
response:</FONT></DIV>
<DIV><FONT face="Courier New" size=2> $ /usr/local/pgsql/bin/postgres -D
/usr/local/pgsql/data <BR> DEBUG: database system was shut down at
2001-11-18 11:46:59<BR> DEBUG: CheckPoint record at (0,
1563272)<BR> DEBUG: Redo record at (0, 1563272); Undo record at
(0, 0); Shutdown TRUE<BR> DEBUG: NextTransactionId: 615; NextOid:
18720 <BR> DEBUG: database system is in production state<BR>
FATAL 1: Database "Administrator" does not exist in the system
catalog.<BR> DEBUG: shutting down<BR> DEBUG: database
system is shut down</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>All the documentation I have points to a program
called postmaster, but I don't see this program located in the
distribution. I also tried downloading the distribution from two
different locations, but I still do not see the postmaster
program.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Another strange thing is that I tried to create a
postgres user in Windows 2000, then logged in as that user. However,
when I started Cygwin, I still had the <A
href="mailto:Administrator@PHOENIX">"Administrator@PHOENIX</A>", instead of <A
href="mailto:postgres@PHOENIX">postgres@PHOENIX</A> </FONT>prompt.</DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Doug Van Auken</FONT></DIV><BR><BR><TT>To
unsubscribe from this group, send an email
to:<BR>postgis-unsubscribe@yahoogroups.com<BR><BR></TT><BR><BR><TT>Your use of
Yahoo! Groups is subject to the <A
href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of Service</A>.</TT>
<BR></BLOCKQUOTE>
<br>
<!-- |**|begin egp html banner|**| -->
<table border=0 cellspacing=0 cellpadding=2>
<tr bgcolor=#FFFFCC>
<td align=center><font size="-1" color=#003399><b>Yahoo! Groups Sponsor</b></font></td>
</tr>
<tr bgcolor=#FFFFFF>
<td align=center width=470><a href="http://rd.yahoo.com/M=212180.1701098.3252983.1269402/D=egroupweb/S=1705007183:HM/A=812075/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b178349800057000"><img src="http://us.a1.yimg.com/us.yimg.com/a/ve/verisign/verisign1002.gif" height=60 width=468 border=0></a></td>
</tr>
<tr><td><img alt="" width=1 height=1 src="http://us.adserver.yahoo.com/l?M=212180.1701098.3252983.1269402/D=egroupmail/S=1705007183:HM/A=812075/rand=157897833"></td></tr>
</table>
<!-- |**|end egp html banner|**| -->
<br>
<tt>
To unsubscribe from this group, send an email to:<BR>
postgis-unsubscribe@yahoogroups.com<BR>
<BR>
</tt>
<br>
<br>
<tt>Your use of Yahoo! Groups is subject to the <a href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of Service</a>.</tt>
</br>
</BODY></HTML>