X-Spam-Check-By: sourceware.org
Message-ID: <4601B48D.3080505@x-ray.at>
Date: Wed, 21 Mar 2007 23:41:17 +0100
From: Reini Urban <rurban AT x-ray DOT at>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de-AT; rv:1.8.1.2) Gecko/20070222 SeaMonkey/1.1.1
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> <45F619DE DOT 3060303 AT lists DOT cichon DOT com>
In-Reply-To: <45F619DE.3060303@lists.cichon.com>
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

Public Mailing Lists schrieb:
> 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?

If you want to start it as service you must assign the proper 
permissions for the user SYSTEM (see the init.d script),
and install the service.
The init.d script even does this for you, as it did for with startlocal.

The README describes all necessary steps.
$ less /usr/share/doc/Cygwin/postgresql-8.0.7.README

For the impatient: install as service (hard)

     # save old database (optional)
     pg_dumpall -g /tmp/$$pgdump-globals.sql
     pg_dumpall > /tmp/$$pgdump.sql
     # adjust the settings in /etc/rc.d/init.d/postgresql
     nano /etc/rc.d/init.d/postgresql
     sysbash # /etc/rc.d/init.d/postgresql initdb
     /etc/rc.d/init.d/postgresql install
     /etc/rc.d/init.d/postgresql start

For the impatient: install as user (easy)

     cygrunsrv -S cygserver
     initdb -D /usr/share/postgresql/data
     pg_ctl start -D /usr/share/postgresql/data -l /var/log/postgresql.log
     createdb
     psql


> 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/
> 
> 


--
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/