Re: [GENERAL] Problem changing default data_directory in PG 9.6 + CentOS6

2016-10-19 Thread Edilmar LISTAS
Em 18-10-2016 16:53, Devrim Gündüz escreveu: Hi, On Mon, 2016-10-17 at 17:38 -0300, 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://downloa

Re: [GENERAL] Problem changing default data_directory in PG 9.6 + CentOS6

2016-10-18 Thread Devrim Gündüz
Hi, On Mon, 2016-10-17 at 17:38 -0300, 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/redh

Re: [GENERAL] Problem changing default data_directory in PG 9.6 + CentOS6

2016-10-18 Thread Edilmar LISTAS
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

Re: [GENERAL] Problem changing default data_directory in PG 9.6 + CentOS6

2016-10-18 Thread Edilmar LISTAS
Em 18-10-2016 11:33, Melvin Davidson escreveu: On Tue, Oct 18, 2016 at 10:20 AM, Edilmar LISTAS mailto:edili...@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.c

Re: [GENERAL] Problem changing default data_directory in PG 9.6 + CentOS6

2016-10-18 Thread Melvin Davidson
On Tue, Oct 18, 2016 at 10:20 AM, Edilmar LISTAS 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 p

Re: [GENERAL] Problem changing default data_directory in PG 9.6 + CentOS6

2016-10-18 Thread Edilmar LISTAS
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)

Re: [GENERAL] Problem changing default data_directory in PG 9.6 + CentOS6

2016-10-17 Thread Adrian Klaver
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-ce

Re: [GENERAL] Problem changing default data_directory in PG 9.6 + CentOS6

2016-10-17 Thread Melvin Davidson
On Mon, Oct 17, 2016 at 4: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/ > r