Do you train Kung Fu?
Or know someone who does?
Then check out KungFuPeople.com
Mobile version of this page
Previous:
Vivisimo - clustered searching
Next:
PythonPoint
Adding a year in PostgreSQL
Date formatting in python or in PostgreSQL
Integer division in programming languages
Running simple SQL commands on the command line
pg_class to check if table exists
List of casts in PostgreSQL
Just Oracle and IBM?
ALTER TABLE patch
Quick PostgreSQL optimization story
Date formatting in Python or in PostgreSQL (part II)
Sorting transform function in PostgreSQL
Why bother with MySQL...
To sub-select or not sub-select in PostgreSQL
Speed test between django_mongokit and postgresql_psycopg2
UPPER vs. ILIKE
Fastest "boolean SQL queries" possible with Django
Optimization of getting random rows out of a PostgreSQL in Django
Connecting with psycopg2 without a username and password
Vivisimo - clustered searching
Next:
PythonPoint
Related blogs
PostgreSQL, MySQL or SQLiteAdding a year in PostgreSQL
Date formatting in python or in PostgreSQL
Integer division in programming languages
Running simple SQL commands on the command line
pg_class to check if table exists
List of casts in PostgreSQL
Just Oracle and IBM?
ALTER TABLE patch
Quick PostgreSQL optimization story
Date formatting in Python or in PostgreSQL (part II)
Sorting transform function in PostgreSQL
Why bother with MySQL...
To sub-select or not sub-select in PostgreSQL
Speed test between django_mongokit and postgresql_psycopg2
UPPER vs. ILIKE
Fastest "boolean SQL queries" possible with Django
Optimization of getting random rows out of a PostgreSQL in Django
Connecting with psycopg2 without a username and password
Related by category
Linux
Creating a user for postgresql
http://www.phpfreaks.com/postgresqlmanual/page/app-createuser.html9th of January 2004
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!
