Changes between Version 11 and Version 12 of UsersWikiPostGIS20Ubuntu1204

Timestamp:

May 5, 2012, 10:51:10 PM (12 years ago)

Author:

jeffmeyer

Comment:

—

UsersWikiPostGIS20Ubuntu1204

@@ -124 +124 @@
 Note that some online documentation recommends setting up a system user account called 'postgres' with superuser privileges, but this is not a requirement for getting started.
 
-Next steps - start logged in as your user account
+Next steps - start these steps logged in as your user account:
+'''NOTE:''' you do not have to use the same password for the system and PostgreSQL user accounts that share the same name. 
 {{{
 $ sudo passwd postgres
@@ -143 +144 @@
 
 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:
-
-{{{
-
-}}}
-
-Now, you should be able to
+{{{
+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
+Enter new password: 
+Enter it again: 
+postgres=# \q
+postgres$ exit
+user$ psql
+psql (9.1.3)
+Type "help" for help.
+
+$user=# 
+}}}
+
+As noted above, this is a great resource: https://help.ubuntu.com/community/PostgreSQL.
+
 
 If you connect through pgadmin, use the following attributes: