Thread: Starting postmaster as a service (newbie)

Starting postmaster as a service (newbie)

From
"Vinay"
Date:
Hi,
   I have got a peculiar problem with my postmaster.I have installed cyg-ipc and postmaster as services on Windows 2000.
But when I restart the system , the postmaster doesn't start.I figured that it is because I have to do the init db everytime this happens. But I have to empty the data directory to do initdb in which case I will lose the created tables.
 
Is there any solution for this problem, so that I need not have to run initdb and delete the data directory every time the postmaster fails to start.
 
Thank you in advance,
help appreciated
 
Vinay

Re: Starting postmaster as a service (newbie)

From
Andrew Sullivan
Date:
On Thu, Jun 05, 2003 at 10:12:25AM -0400, Vinay wrote:
> figured that it is because I have to do the init db everytime this

I don't know anything about the Cyg Win installation, but you _don't_
need to do initdb every time: that creates a new data area.

A

----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


Re: Starting postmaster as a service (newbie)

From
"eladio rodriguez"
Date:
greetings.
it verifies that the user of win2000 has supervisor right, you can test, to
go to the services and to try to initiate it manually, verifies the step
word.
initdb single runs one you see.
my ingles is poor, is using the translator of google,
hopes helps you.

>From: "Vinay" <vinay@mdp.net>
>To: <pgsql-admin@postgresql.org>
>Subject: [ADMIN] Starting postmaster as a service (newbie)
>Date: Thu, 5 Jun 2003 10:12:25 -0400
>
>Hi,
>    I have got a peculiar problem with my postmaster.I have installed
>cyg-ipc and postmaster as services on Windows 2000.
>But when I restart the system , the postmaster doesn't start.I figured that
>it is because I have to do the init db everytime this happens. But I have
>to empty the data directory to do initdb in which case I will lose the
>created tables.
>
>Is there any solution for this problem, so that I need not have to run
>initdb and delete the data directory every time the postmaster fails to
>start.
>
>Thank you in advance,
>help appreciated
>
>Vinay

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.yupimsn.com/