PostgreSQL 初期セットアップ
- インストールはこちら
パスワード:
- postgres% psql
Welcome to psql 8.1.22, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
- postgres=# alter user postgres with password 'postgres-password';
ALTER ROLE
- postgres=# CREATE USER "elmarverde" CREATEDB PASSWORD 'elmarverde-password' LOGIN;
CREATE ROLE
- postgres=# \q
- postgres% exit
- elmarverde% createdb testdb
CREATE DATABASE