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(at)intersite(dot)com(dot)br <mailto:edilista(at)intersite(dot)com(dot)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(at)postgresql(dot)org
>> <mailto:pgsql-general(at)postgresql(dot)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.
>
>