Creating a PostgreSQL Database 3152015.docVIP

Creating a PostgreSQL Database 3/15/2011 Two methods for creating a database: (1) At the command line createdb -U postgres -D pgdata_local db_name - user must have previously been granted permission to create databases - createdb is a “wrapper” for “psql -d “ The “-D” option creates the database in the PGDATA_LOCAL partition. Note the absence of a $ in front of the PGDATA_LOCAL partition name. The PGDATA_LOCAL partition is sized at 32 GBytes. If a database is created without the “-D” option, it will be created in the PGDATA partition which is only .5 GBytes in size. If this