PostgreSQL

A relational database engine with an elephant. pgAdminIII is the associated management GUI.
web | feed? | project | issues? | documentation (wiki) | PostgreSQL License

Ubuntu packages | postgresql postgresql-contrib pgadmin3
Other distributions | choco debian (wiki)
Other listings | fsd fresh openhub openhatch ubuntuwiki wikidata wikipedia
Alternatives | :mysql
See also | :database

Server instrumentation

Once pgadmin3 and postgresql-contrib both installed, install adminpack (aka Server Instrumentation):

sudo -u postgres psql
# CREATE EXTENSION adminpack;
# \q

psycopg2

Also install psycopg2 dependencies (for :python / :postgresql integration)

Connection over a network

To allow 1.2.3.4 to connect to the database:

See:

Restart service

sudo /etc/init.d/postgresql reload # simple reload
sudo /etc/init.d/postgresql restart # full restart (required for some postgresql.conf changes)

Matching superuser

For a user based on the current user account, see https://help.ubuntu.com/community/PostgreSQL#Alternative_Server_Setup

Independent superuser

For an independent superuser (not linked to current user account):

sudo -u postgres createuser --superuser <USERNAME>
sudo -u postgres psql
# \password <USERNAME>
# \q

You should now be able to log in to pgAdmin III with this user and create databases.



Backlinks: mysql django microsoft:sql-server

CC0 / Public domain dedication To the extent possible under law, d3vid seaward has waived all copyright and related or neighboring rights to "PostgreSQL in Grasmere notebook, including code snippets" (why? how?)