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
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
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
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
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
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)
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
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