Postgres Pro
Downloads
Home   >   mailing lists

Thread: Changing/Specifying Data Dir to postmaster Service

Changing/Specifying Data Dir to postmaster Service

From
CSN
Date:
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

Re: Changing/Specifying Data Dir to postmaster Service

From
Mike G
Date:
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@postgresql.org

Re: Changing/Specifying Data Dir to postmaster Service

From
CSN
Date:
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@thegodshalls.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@postgresql.org
>
>




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