Use sudo with the -u switch to specify the postgres user.
sudo -u postgres createdb stocks
Published January 9th, 2012
How do you sudo to a specific user in Ubuntu to create a new Postgres database?
Similar Articles
Ubuntu 12.04 resolv.conf
Create Ubuntu 12.04 USB installer from Debian
Ubuntu 12.04 install Nvidia drivers from ppa
Ubuntu Unity show desktop
Ubuntu Natty Narwhal and Maverick Meerkat Thunderbird 24th April obsolete warning
Ubuntu Natty Narwhal switch back to Classic desktop instead of Unity
Ubuntu Natty Narwhal fix broken scrollbars in Classic desktop (Eclipse, Nautilus)
Debian / Ubuntu php-gd function imageantialias() not implemented
Use 64 bit Sun Java plugin in Firefox on Ubuntu
virtualbox-4.1 conflicts with virtualbox
[SOLVED] Ubuntu ssh Too many authentication failures
Samsung SyncMaster 913N 1280x1024 resolution in Debian and Ubuntu
Ubuntu remove OpenJDK and use Sun Java as default
Ubuntu fix 'Load balancing tick' problem
Ubuntu /media/Stick_ (with underscore)
PostgreSQL 9 pgcrypto Debian
Postgresql increase SHMMAX with sysctl
Postgresql add cascade to existing foreign key constraint
PostgreSQL output query result to file
PostgreSQL /var/lib/postgresql/8.4/main/pg_xlog filling up with WAL files
PostgreSQL drop unique constraint
PostgreSQL DROP NULL constraint on COLUMN
SQL get MAX value or NULL (LEFT JOIN example)
Select unique values in postgres
Load specific columns from CSV file into PostgreSQL
Postgres copy table structure inside database without data
PostgreSQL config, data, log files on Debian
PostgreSQL Debian make a baseline backup for PITR
FATAL: sorry, too many clients already (PostgreSQL)
Run PostgreSQL queries from the command line and export data
PostgreSQL convert BIGINT to date
Get SEDOL from ISIN using SQL (Postgres)
Find biggest tables in postgres
Postgres list databases
Install pgcrypto for Postgres encryption in Debian Lenny
Postgres invalid byte sequence for encoding UTF8
Create and export PGP keys for Postgresql
Postgres list user-defined stored procedures
Postgres dump database schema with or without data
Postgres server to server database copy performance boost
Create Ubuntu 12.04 USB installer from Debian
Ubuntu 12.04 install Nvidia drivers from ppa
Ubuntu Unity show desktop
Ubuntu Natty Narwhal and Maverick Meerkat Thunderbird 24th April obsolete warning
Ubuntu Natty Narwhal switch back to Classic desktop instead of Unity
Ubuntu Natty Narwhal fix broken scrollbars in Classic desktop (Eclipse, Nautilus)
Debian / Ubuntu php-gd function imageantialias() not implemented
Use 64 bit Sun Java plugin in Firefox on Ubuntu
virtualbox-4.1 conflicts with virtualbox
[SOLVED] Ubuntu ssh Too many authentication failures
Samsung SyncMaster 913N 1280x1024 resolution in Debian and Ubuntu
Ubuntu remove OpenJDK and use Sun Java as default
Ubuntu fix 'Load balancing tick' problem
Ubuntu /media/Stick_ (with underscore)
PostgreSQL 9 pgcrypto Debian
Postgresql increase SHMMAX with sysctl
Postgresql add cascade to existing foreign key constraint
PostgreSQL output query result to file
PostgreSQL /var/lib/postgresql/8.4/main/pg_xlog filling up with WAL files
PostgreSQL drop unique constraint
PostgreSQL DROP NULL constraint on COLUMN
SQL get MAX value or NULL (LEFT JOIN example)
Select unique values in postgres
Load specific columns from CSV file into PostgreSQL
Postgres copy table structure inside database without data
PostgreSQL config, data, log files on Debian
PostgreSQL Debian make a baseline backup for PITR
FATAL: sorry, too many clients already (PostgreSQL)
Run PostgreSQL queries from the command line and export data
PostgreSQL convert BIGINT to date
Get SEDOL from ISIN using SQL (Postgres)
Find biggest tables in postgres
Postgres list databases
Install pgcrypto for Postgres encryption in Debian Lenny
Postgres invalid byte sequence for encoding UTF8
Create and export PGP keys for Postgresql
Postgres list user-defined stored procedures
Postgres dump database schema with or without data
Postgres server to server database copy performance boost