Creating a user for postgresql

10 January 2004   2 comments   Linux

Mind that age!

This blog post is 19 years old! Most likely, its content is outdated. Especially if it's technical.

http://www.phpfreaks.com/postgresqlmanual/page/app-createuser.html

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!

Comments

Peter Bengtsson

Test comment. Please ignore.

Peter Bengtsson

TEST

Your email will never ever be published.

Related posts