Re: Struggling to change default data location - Mailing list pgsql-general

From Geoff Caplan
Subject Re: Struggling to change default data location
Date
Msg-id 003d01c0ce76$d8885510$0339a8c0@ajanta
Whole thread Raw
In response to Re: Struggling to change default data location  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Struggling to change default data location
Re: Re: Struggling to change default data location
List pgsql-general
Peter, thanks for your patience with a newbie. I think my stuckness stems
from 2 issues:

1) Starting environment

> The environment initdb runs in when it runs at system startup is probably
> not the one you set up.  Check the /etc/init.d/postgresql file for
> details.

This is certainly true, as my settings are overridden. I have had a look at
this file, but I am still not clear what environment it is reading when it
sets $PGDATA.  Can you clarify where this environment
config file should be (on RedHat)?

2) Passing parameters to postmaster during starup

Also, the init.d script uses pg_ctl to start the postmaster. I need to pass
the -i parameter using the "postmaster" utility. (As I understand it, in
past releases of these
RPMs -i was set as a default). At what point in the startup sequence can you
pass "postmaster" utility params to the postmaster process?

I will spare you from the output from your diagnostic script till I can get
these basics sorted out...

Thanks again

Geoff Caplan




pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: help with serial type
Next
From: Joel Burton
Date:
Subject: Re: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?