--0-451611635-1092729529=:54222
Content-Type: text/plain; charset=us-ascii

Hi,

Gud day!

I would like to use, postgres and currently installed cygwin, but unfortunately when i started creating a new database cluster... as i've followed in.. FAQ_MSWIN

3b. Use the initdb command to create a new database cluster. An
example command would be:

initdb -D /usr/local/pgsql/data -W -E LATIN1

--- i got error message from cygwin shell... the following are the error i commited

creating template1 database in /usr/local/pgsql/data/base/1... FATAL: Lock file :/usr/local/pgsql/data/postmaster.pid" already exists
HINT: Is another postgres (PID 1836) running in data directory ":/usr/local/pgsql/data"?

initdb: failed


--- another thing is i always encountered error when i start creating data base

psql: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

what is the problem? hope for your immediate respose
thanks.



---------------------------------
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
--0-451611635-1092729529=:54222
Content-Type: text/html; charset=us-ascii

<DIV>Hi, </DIV>
<DIV>&nbsp;</DIV>
<DIV>Gud day!</DIV>
<DIV>&nbsp;</DIV>
<DIV>I would like to use, postgres and currently installed cygwin, but unfortunately when i started creating a new database cluster... as i've followed in.. FAQ_MSWIN</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT style="BACKGROUND-COLOR: #ffff00">3b.&nbsp; Use the initdb command to create a new database cluster.&nbsp; An<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp; example command would be:<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb sp;&nbsp;&nbsp;&nbsp;&nbsp; initdb -D /usr/local/pgsql/data -W -E LATIN1<BR></FONT></DIV>
<DIV>--- i got error message from cygwin shell... the following are the error i commited</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT style="BACKGROUND-COLOR: #60bf00">creating template1 database in /usr/local/pgsql/data/base/1... FATAL: Lock file :/usr/local/pgsql/data/postmaster.pid" already exists</FONT></DIV>
<DIV><FONT style="BACKGROUND-COLOR: #60bf00">HINT: Is another postgres (PID 1836) running in data directory ":/usr/local/pgsql/data"?</FONT></DIV>
<DIV><FONT style="BACKGROUND-COLOR: #60bf00"></FONT>&nbsp;</DIV>
<DIV><FONT style="BACKGROUND-COLOR: #60bf00">initdb: failed</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>--- another thing is i always encountered error when i start creating data base</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT style="BACKGROUND-COLOR: #60bf00">psql: could not connect to server: Connection refused<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb sp;&nbsp; Is the server running locally and accepting<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp;&nbsp; connections on Unix domain socket "/tmp/.s.PGSQL.5432"?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>what&nbsp;is the problem? hope for your immediate respose </DIV>
<DIV>thanks.<BR></DIV><p>
<hr size=1>Do you Yahoo!?<br>
<a href="http://us.rd.yahoo.com/mail_us/taglines/50x/*http://promotions.yahoo.com/new_mail/static/efficiency.html">Yahoo! Mail</a> - 50x more storage than other providers!
--0-451611635-1092729529=:54222--

Jheneffer Taruc wrote:
Jheneffer, can I recommend you try the latest version 8.0 (beta).
Details at the url below:
http://www.postgresql.org/news/216.html

This is going to be a native Windows port and there is a standard
installer for it (link in the news article). This probably makes more
sense if you're just starting out.

Good Luck!

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings