PostgreSQL - Revision history

Andrew at 11:35, 12 May 2020

2020-05-12T11:35:58Z

2020-02-07T11:35:05Z

2020-02-07T11:20:44Z

‎PostgresSQL

2020-02-07T11:08:48Z

‎PostgresSQL

2020-02-07T11:04:36Z

‎Creating a DB

2020-02-07T11:04:27Z

Created page with "== PostgresSQL == === Creating a DB === sudo su - postgres createdb <dbname>"

New page

== PostgresSQL ==

=== Creating a DB ===
sudo su - postgres
createdb <dbname>

← Older revision		Revision as of 11:35, 12 May 2020
Line 19:		Line 19:

	== Starting an interactive session ==		== Starting an interactive session ==
−	psql <dbname>	+	sudo -u postgres psql <dbname>
		+
		+	== Useful Commands ==
		+	* List all databases:
		+	\list

@@ Line 1: / Line 1: @@
-== PostgresSQL ==
+== Creating a DB ==
    sudo -u postgres createdb <dbname>
-=== Creating a role ===
+== Creating a role ==
 Note that in postgres all access is managed by "roles", there is no concept of users or groups (though for historical purposes users and roles can be thought of as largely interchangeable).
@@ Line 13: / Line 11: @@
    sudo -u postgres createuser <username> -P
-=== Authentication ===
+== Authentication ==
-==== Local Users ====
+=== Local Users ===
 By default (defined in `/etc/postgresql/11/main/pg_hba.conf`), local users can authenticate without needing a password into a role with the same name as their username.
-==== Remote Users ====
+=== Remote Users ===
 Remote users (including those connecting from other docker containers) can only connect as roles with passwords defined.
-=== Starting an interactive session ===
+== Starting an interactive session ==
    psql <dbname>

@@ Line 4: / Line 4: @@
    sudo -u postgres createdb <dbname>
-=== Creating a user ===
+=== Creating a role ===
    sudo -u postgres createuser <username>
 === Starting an interactive session ===
    psql <dbname>

@@ Line 2: / Line 2: @@
 === Creating a DB ===
-   sudo su - postgres
+   sudo -u postgres createdb <dbname>
-   createdb <dbname>