My suggestion would be to use LVM or partition your new drive so that you have a file system that is the size you want your entire /var/lib/pgsql to be - that may be all of the drive you've ad... [by TrevorH]
on 07/04/2012 – Made popular on 07/04/2012
In a Linux computer, partition table and superblock are two most important data structures. The superblock keeps record of the file system characteristics including its size, empty and filled block, location and size of Inode tables, block size and status. The partition tables stores all required information about hard drive primary partitions.
I'm not sure how to explain this in the subject better, so the "question" may not be right. But here goes. I have three hard drives. Drive A is a 320GB drive, Drive B is a 80 GB Drive, and Drive C is a 1TB Drive.
Now if I do postgres -D /var/lib/pgsql/data under regular user I receive Permission denied for "/var/lib/pgsql/data/postgresql.conf", if I try it under root I get some error about that I shouldn't run postgres under the privileged user.
I'm running Ubuntu 14.04 on a 32GB mSATA drive with a mechanical drive dedicated to Windows and a data partition. I've spent a lot of time setting up my install with things like Android Studio, Itellij, MySQL Workbench, etc. I would like to be able to backup my entire mSATA drive to my data partition on set intervals and I would like the output to be installable from a USB drive.