Re: Problem changing default data_directory in PG 9.6 + CentOS6

Hi,

After some tests, really the problem is with original script from PG 9.6
RPM /etc/rc.d/init.d/postgresql-9.6. If I run pg_ctl, start/stop with
the new data_directory works fine!

Em 18-10-2016 13:49, Edilmar LISTAS escreveu:
> Em 18-10-2016 11:33, Melvin Davidson escreveu:
>>
>>
>> On Tue, Oct 18, 2016 at 10:20 AM, Edilmar LISTAS
>> <edilista@intersite.com.br <mailto:edilista@intersite.com.br>> wrote:
>>
>>     1) I changed /etc/rc.d/init.d/postgresql-9.6 like this:
>>     PGDATA=/sistemas/sat4/bdpg
>>     #PGDATA=/var/lib/pgsql/9.6/data
>>
>>     2) I copied postgresql.conf and pg_hba.conf from
>>     /var/lib/pgsql/9.6/data to /sistemas/sat4/bdpg
>>
>>     3) I changed postgresql.conf like this:
>>     data_directory = '/sistemas/sat4/bdpg'
>>
>>     4) service postgresql-9.6 start
>>     Iniciando o serviço postgresql-9.6: [FAILED]
>>
>>     In my devel machine, I only did step 3), PG starts lookup for
>>     default configs in /var/lib/pgsql/data and uses my databases in the
>>     alternative path /sistemas/sat4/bdpg.
>>
>>
>>     Em 17-10-2016 21:22, Adrian Klaver escreveu:
>>
>>         On 10/17/2016 01:38 PM, Edilmar LISTAS wrote:
>>
>>             I have an env running a changed data_directory fine in a
>>             devel machine
>>             PG 9.4 using Fedora23.
>>             Now, I have a server machine with CentOS where I downloaded
>>             the RPMs
>>             from repo
>>
>> https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-centos96-9.6-3.noarch.rpm
>>
>>
>> <https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-centos96-9.6-3.noarch.rpm>.
>>
>>
>>             All the configs run fine if I doesn't change the default
>>             data_directory.
>>             But I need to use the path /sistemas/sat4/bdpg.
>>
>>             I did these commands:
>>
>>             mkdir /sistemas/sat4/bdpg
>>             chown postgres /sistemas/sat4/bdpg
>>             chmod 700 /sistemas/sat4/bdpg
>>             su - postgres
>>             /usr/pgsql-9.6/bin/initdb -D /sistemas/sat4/bdpg
>>             exit
>>
>>             Then, I changed data_directory to /sistemas/sat4/bdpg and
>>             tried to
>>
>>
>>         Changed data_directory where?
>>
>>             restart PG:
>>             service postgresql-9.6 restart
>>             STOP => OK
>>             START => FAILED
>>
>>             I disabled se_linux.
>>             The file /var/lib/pgsql/9.6/pgstartup.log just said to see
>>             future output
>>             in pg_log.
>>             The file data/pg_log/postgresql-Mon.log doesn't say anything
>>             about
>>             errors.
>>
>>             The strange is that startup arises a FAILED message, but the
>>             process
>>             "/usr/pgsql-9.6/bin/postmaster -D /var/lib/pgsql/9.6/data"
>>             is running
>>
>>
>>         So /var/lib/pgsql/9.6/data is where the original install is?
>>
>>         Best guess is that some script is starting the original install
>>         and when
>>         you go to start your custom location it fails because the new
>>         cluster is
>>         trying to use the port(5432 I am assuming) as the original
>> cluster.
>>
>>         Have you tried giving the new cluster a different port number,
>>         say 5442,
>>         and the starting it?
>>
>>
>>             (and the children logger/checkpointer/etc). But I don't get
>>             to connect
>>             using pgAdmin3. Then, I have to kill manually postmaster
>>             (because
>>             service script doesn't understand postmaster.pid in the new
>>             data dir),
>>             comment data_directory to use default place, start and
>>             connect to
>>             pgAdmin3. Then, start/stop/start/etc run fine lookup for
>>             postmaster.pid
>>             in /var/lib/pgsql/9.6/data.
>>
>>
>>         So you either need to change the start script to point to the new
>>         cluster or create a new one for it.
>>
>>
>>
>>
>>
>>
>>     --
>>     Sent via pgsql-general mailing list (pgsql-general@postgresql.org
>>     <mailto:pgsql-general@postgresql.org>)
>>     To make changes to your subscription:
>>     http://www.postgresql.org/mailpref/pgsql-general
>>     <http://www.postgresql.org/mailpref/pgsql-general>
>>
>>
>>
>> I*nstead of
>>> 4) service postgresql-9.6 start
>> *
>> *
>> Try:
>> *
>> *sudo su postgres
>> *
>> *pg_ctl start -D /sistemas/sat4/bdpg*
>> *
>> *
>> *If that works, then your problem is in the postgresql service file
>> *
>> *-- *
>> *Melvin Davidson*
>> I reserve the right to fantasize.  Whether or not you
>> wish to share my fantasy is entirely up to you.
>
> This works...
> /usr/pgsql-9.6/bin/pg_ctl -D /sistemas/sat4/bdpg -l logfile start
> but psql doesn't log:
> -bash-4.1$ psql
> Senha:
> psql: fe_sendauth: no password supplied
>
> If I use the default data_directory = /var/lib/pgsql/9.6/data, psql runs
> fine without password.
>
>