Changes between Version 17 and Version 18 of UsersWikiPostGIS20Ubuntu1204

Timestamp:

May 6, 2012, 12:43:08 AM (12 years ago)

Author:

jeffmeyer

Comment:

—

UsersWikiPostGIS20Ubuntu1204

@@ -180 +180 @@
 If you're going to want to connect to the PostgreSQL database using your own account (so you don't have to fool around with 'postgres'), you may want to do this:
 {{{
-user$ sudo -s -u postgres
-postgres$ createuser --superuser $user     ---- note: createuser is a command line tool to create a PostgreSQL user, not a system account  
-postgres$ createdb $user
+$USER$ sudo -s -u postgres
+postgres$ createuser --superuser $USER     ---- note: createuser is a command line tool to create a PostgreSQL user, not a system account  
+postgres$ createdb $USER
 postgres$ psql
 psql (9.1.3)
 Type "help" for help.
 
-postgres=# \password $user
+postgres=# \password $USER
 Enter new password: 
 Enter it again: 
 postgres=# \q
 postgres$ exit
-user$ psql
+$USER$ psql
 psql (9.1.3)
 Type "help" for help.
 
-$user=# 
+$USER=#                        ---- voila! 
 }}}