Thread: Fw: Starting postmaster as a service (newbie)

Fw: 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: Fw: Starting postmaster as a service (newbie)

From
Robert Treat
Date:
You should not have to run initdb after each restart, check out the
following link on setting up cygwin as a service:
http://www.tishler.net/jason/software/postgresql/postgresql-7.3.2.README

future questions should be posted to pgsql-cygwin

Robert Treat

On Thu, 2003-06-05 at 10:27, Vinay wrote:
>
>
> 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

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL