On Wed, Mar 09, 2016 at 12:59:49PM -0600, Michael Cronenworth wrote:
On 03/09/2016 12:18 PM, Suvayu Ali wrote:
I want to create a PostgreSQL db. So I did the following:
$ su - # su - postgres $ pg_ctl initdb -D /var/lib/pgsql/data
For future reference there is a helper script that can do this stuff for you.
# postgresql-setup --init-db
And when you need to upgrade the database format due to a PostgreSQL upgrade:
# postgresql-setup --upgrade
Thanks, hopefully I'll remember the next time.
Cheers,