Creating a user for postgresql

10 January 2004   2 comments   Linux

Powered by Fusion×

PostgreSQL This took some time to figure out (found answer here)and it might come in handy sometime in the far future so I write it down here and now.
To create a user for the postgresql database on linux you have to do that from the linux user called postgres.

This would not work:

peterbe@computer:~$ createuser peterbe

What you need to do is this:

peterbe@computer:~$ su -
...log in as root...
computer:~# su postgres
computer:/root$ createuser peterbe

Now I know!


Peter Bengtsson
Test comment. Please ignore.
Peter Bengtsson
Thank you for posting a comment

Your email will never ever be published

Related posts

Vivisimo - clustered searching 08 January 2004
PythonPoint 10 January 2004
Related by keywords:
Fastest database for Tornado 09 October 2013
Integer division in programming languages 04 August 2004
Optimization of getting random rows out of a PostgreSQL in Django 23 February 2011
Connecting with psycopg2 without a username and password 24 February 2011
Adding a year in PostgreSQL 04 February 2004
pg_class to check if table exists 20 April 2005
To sub-select or not sub-select in PostgreSQL 31 August 2009
Speed test between django_mongokit and postgresql_psycopg2 09 March 2010
UPPER vs. ILIKE 19 April 2010
Date formatting in python or in PostgreSQL 20 July 2004
PostgreSQL, MySQL or SQLite 04 April 2004
Postgres collation errors on CITEXT fields when upgrading to 9.1 21 May 2012