Re: Problem changing default data_directory in PG 9.6 + CentOS6 - Mailing list pgsql-general
From | Edilmar LISTAS |
---|---|
Subject | Re: Problem changing default data_directory in PG 9.6 + CentOS6 |
Date | |
Msg-id | 55fdd4f3-8751-9984-97cc-8055df9a63b3@intersite.com.br Whole thread Raw |
In response to | Re: Problem changing default data_directory in PG 9.6 + CentOS6 (Edilmar LISTAS <edilista@intersite.com.br>) |
List | pgsql-general |
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. > >
pgsql-general by date: