X-Spam-Check-By: sourceware.org
Message-ID: <45F619DE.3060303@lists.cichon.com>
Date: Mon, 12 Mar 2007 20:26:22 -0700
From: Public Mailing Lists <lists AT lists DOT cichon DOT com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.13) Gecko/20060414
MIME-Version: 1.0
To: cygwin AT cygwin DOT com
Subject: Re: Seeking Installation Instructions for Postgresql on Cygwin
References: <45F4CF61 DOT 2030108 AT lists DOT cichon DOT com> <45F4D442 DOT 59E09C1 AT dessent DOT net> <Pine DOT GSO DOT 4 DOT 63 DOT 0703121132240 DOT 22868 AT access1 DOT cims DOT nyu DOT edu>
In-Reply-To: <Pine.GSO.4.63.0703121132240.22868@access1.cims.nyu.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id: <cygwin.cygwin.com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com

Thanks guys, now I'm a little further:

I installed that cygserver, and now I can start a postgresql with
/etc/rc.d/init.d/postgresql startlocal

If I try to start the service, I'm getting:
$ /etc/rc.d/init.d/postgresql start
Starting PostgreSQL: - cygserver OK - cygrunsrv: Error starting a 
service: OpenS
ervice:  Win32 error 1060:
Der angegebene Dienst ist kein installierter Dienst.
[This is a German Windows, and the above message translates to English 
like "the service is not an installed service"]

ERROR service start FAILED
LOG:  shutting down
LOG:  database system is shut down
LOG:  database system was shut down at 2007-03-12 09:33:04
LOG:  checkpoint record is at 0/ABCF48
LOG:  redo record is at 0/ABCF48; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 544; next OID: 17230
LOG:  database system is ready
LOG:  received smart shutdown request
LOG:  shutting down
LOG:  database system is shut down

I would rather like to start everything at boot time with init.
Is there anything else I need to do?

Thanks for your help,
Gordon


Igor Peshansky wrote:

>On Sun, 11 Mar 2007, Brian Dessent wrote:
>
>  
>
>>Public Mailing Lists wrote:
>>
>>    
>>
>>>I'm trying to setup a Postgresql server on Windows-XP/Cygwin. I've done
>>>this a couple of times on Linux, and I'm experiencing some difficulties
>>>on Windows.
>>>
>>>I have installed the packages postgresql (version 8.0.7-1) and
>>>cygrunserv (version 1.17-1), and I have syslog and init running.
>>>
>>>If I'm trying to run /etc/rc.d/init.d/postgresql initdb, and I'm getting
>>>the following error messages:
>>>      
>>>
>>"Bad system call" usually indicates that you need cygserver installed
>>and running.  And reading /usr/share/doc/Cygwin/postgresql-*.README
>>confirms this.  Read /usr/share/doc/Cygwin/cygserver.README for details.
>>    
>>
>
>And it's an FAQ:
><http://cygwin.com/faq/faq.programming.html#faq.programming.ipc>.
>	Igor
>  
>


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/