Skip site navigation (1) Skip section navigation (2)

Re: Changing/Specifying Data Dir to postmaster Service

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: PGSQL Cygwin <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: Changing/Specifying Data Dir to postmaster Service
Date: 2004-08-27 06:13:56
Message-ID: 20040827061356.7524.qmail@web52909.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-cygwin
Actually, I just stopped the service, then ran
postmaster from the command line with a different -D
directory. I just needed to access an old data dir to
export/import.

CSN


--- Mike G <mike(at)thegodshalls(dot)com> wrote:

> Hello,
> 
> You need to do an initdb and specify the directory
> you want to install /
> start it in.  Of course you will have to backup your
> data first and then
> restore the dump(s) after the initdb.  
> 
> Then you must also remove the postmaster service and
> re-install using
> the new path etc.
> 
> HTH.
> 
> Mike
> 
> 
> On Thu, 2004-08-26 at 20:24, CSN wrote:
> > I installed the postmaster service using:
> > 
> > cygrunsrv --install postmaster --path
> > /usr/bin/postmaster --args "-D
> /var/postgresql/data
> > -i" --dep cygserver --termsig INT --user postgres
> > --shutdown
> > 
> > How can I start it using another data directory?
> > 
> > Thanks,
> > CSN
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> protection around 
> > http://mail.yahoo.com
> > 
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
> 
> 



		
__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail 

In response to

pgsql-cygwin by date

Next:From: Jason TishlerDate: 2004-08-27 12:00:36
Subject: Re: postgresql-7.4.5-1 ready for review
Previous:From: Mike GDate: 2004-08-27 03:33:09
Subject: Re: Changing/Specifying Data Dir to postmaster Service

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group