Re: Postgres 9.4.5 Installation on Centos 7.3

Dear John,

Thanks for update !!!

Is it not possible If my storage is mounted on /u01 and I will create the
directory within "u01/" /postgres9.4/data. And now I want to initialize
my data within this directory ("/u01/postgres9.4/data").

There is any specific reason to use only this by default directory
"/var/lib/pgsql/9.4/data".

And if I want to keep (("/u01/postgres9.4/data) this directory then what
should be the command of initdb because command giving the error.

(-bash-4.2$ /usr/pgsql-9.4/bin/postgresql94-setup initdb -D
/u01/postgres9.4/data/

#cd

Filesystem Size Used Avail Use% Mounted on
/dev/mapper/centos-root 116G 664M 109G 1% /
devtmpfs 1.8G 0 1.8G 0% /dev
tmpfs 1.8G 0 1.8G 0% /dev/shm
tmpfs 1.8G 8.8M 1.8G 1% /run
tmpfs 1.8G 0 1.8G 0% /sys/fs/cgroup
/dev/mapper/centos-usr 20G 3.2G 16G 17% /usr
/dev/sda1 477M 273M 175M 62% /boot
/dev/mapper/centos-var 20G 907M 18G 5% /var
*/dev/mapper/centos-u01 296G 2.4G 279G 1% /u01*

cd /u01
mkdir -p /postgres9.4/data

Regards
SS

On Fri, Jan 29, 2016 at 12:34 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 1/28/2016 10:24 PM, Sachin Srivastava wrote:
>
>> I have initialized the database through below command through Postgres
>> user but in my "/u01/postgres9.4/" folder pg_log folder is not available,
>> what is the reason behind this.
>>
>> -----------------------------------
>>
>> -bash-4.2$ initdb -D /u01/postgres9.4/
>>
>
>
> the yum installed version defaults to putting the data directory in
> /var/lib/pgsql/9.4/data ... There's a bunch of reasons to stick with this,
> not the least thats where selinux is configured to expect it to be.
>
> I would recommend mounting a database filesystem as /var/lib/pgsql first,
> then doing the following as root...
>
> /usr/pgsql-9.4/bin/postgresql94-setup initdb
> systemctl enable postgresql-9.4.service
> systemctl start postgresql-9.4.service
>
> the server is now running, and will autostart when you reboot.
>
> see
> http://people.planetpostgresql.org/devrim/index.php?/archives/80-Installing-and-configuring-PostgreSQL-9.3-and-9.4-on-RHEL-7.html
>
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>