Postgres RDBMS/Installing and Configuring PostgreSQL

From Wikibooks, open books for an open world
Jump to: navigation, search

Installing[edit]

Installing from packages[edit]

Installing from source[edit]

Starting and stopping[edit]

$ /etc/init.d/postgresql start

Creating a user[edit]

The following command creates a new user with superuser privileges:

$ createuser -U postgres -s <some username>

Creating a new user is a database operation, so it can only be done by an existing database user. You need to specify which database user to use (otherwise it will default to using a database user with the same name as your current UNIX user, which is unlikely to be correct). Default installs typically have a user called postgres that can be used for this.

To set a password for the newly created user, log in to the database using an account with superuser privileges, and issue the command:

ALTER USER <username> WITH ENCRYPTED PASSWORD 'secret';