Postgres - Revision history

Chubbard at 16:29, 10 April 2025

2025-04-10T16:29:58Z

← Older revision		Revision as of 09:29, 10 April 2025
Line 79:		Line 79:
	=== Find active queries ===		=== Find active queries ===
	See what is actually happening at the time of a query		See what is actually happening at the time of a query
			[https://stackoverflow.com/questions/27435839/how-to-list-active-connections-on-postgresql List active connections on postgresql]
	<pre>		<pre>
	someDb=# SELECT		someDb=# SELECT

Chubbard: /* Dump a Postgres database */

2025-04-10T16:28:58Z

Dump a Postgres database

@@ Line 75: / Line 75: @@
 <pre>
 pg_dump -s databaseName -U someUser -h localhost > databaseName_database_schema_postgres.sql
 </pre>

Chubbard: /* Migrate from MySQL to Psql */

2024-04-04T18:41:12Z

Migrate from MySQL to Psql

← Older revision		Revision as of 11:41, 4 April 2024
Line 69:		Line 69:
	Total import time ✓ 8 0.7 kB 0.284s		Total import time ✓ 8 0.7 kB 0.284s

			</pre>

			=== Dump a Postgres database ===
			To dump just the schema and indexes
			<pre>
			pg_dump -s databaseName -U someUser -h localhost > databaseName_database_schema_postgres.sql
	</pre>		</pre>

Chubbard: /* Useful commands to remember */

2024-04-03T19:13:47Z

Useful commands to remember

@@ Line 28: / Line 28: @@
 * \dt  display tables
 * \l   list databases
 === Links ===

Chubbard: /* Links */

2024-04-03T19:08:13Z

Links

← Older revision		Revision as of 12:08, 3 April 2024
Line 32:		Line 32:
	[https://stackoverflow.com/questions/2172569/how-to-login-and-authenticate-to-postgresql-after-a-fresh-install\| Stack Overflow fresh install notes]		[https://stackoverflow.com/questions/2172569/how-to-login-and-authenticate-to-postgresql-after-a-fresh-install\| Stack Overflow fresh install notes]

			[https://serverfault.com/questions/198002/postgresql-what-does-grant-all-privileges-on-database-do\| Server Fault Grants and permissions information]

Chubbard: Created page with "== Postgres Notes == I generally use MySQL, however there have been cases where I need to use Postgres. I can never remember the exact syntax to do basic things, so here we are... === Create User and Database === Admin login to Postgeres (fresh install Pg14)

 sudo -u postgres psql postgres

Create User

 CREATE ROLE someUser LOGIN PASSWORD 'somePassword';

Create database and add someUser as the owner

 CREATE DATABASE databaseName with owner =..."

2024-04-03T19:06:46Z

Created page with "== Postgres Notes == I generally use MySQL, however there have been cases where I need to use Postgres. I can never remember the exact syntax to do basic things, so here we are... === Create User and Database === Admin login to Postgeres (fresh install Pg14) <pre> sudo -u postgres psql postgres </pre> Create User <pre> CREATE ROLE someUser LOGIN PASSWORD 'somePassword'; </pre> Create database and add someUser as the owner <pre> CREATE DATABASE databaseName with owner =..."

New page

== Postgres Notes ==
I generally use MySQL, however there have been cases where I need to use Postgres. I can never remember the exact syntax to do basic things, so here we are...

=== Create User and Database ===
Admin login to Postgeres (fresh install Pg14)
<pre>
sudo -u postgres psql postgres
</pre>
Create User
<pre>
CREATE ROLE someUser LOGIN PASSWORD 'somePassword';
</pre>
Create database and add someUser as the owner
<pre>
CREATE DATABASE databaseName with owner = someUser;
</pre>
Validate that this worked
<pre>
psql -h localhost -d databaseName -U someUser -p 5432
Password for user someUser: somePassword
psql (14.11 (Ubuntu 14.11-0ubuntu0.22.04.1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.
</pre>

=== Useful commands to remember ===
* \q quit
* \dt display tables
* \l list databases

=== Links ===
[https://stackoverflow.com/questions/2172569/how-to-login-and-authenticate-to-postgresql-after-a-fresh-install| Stack Overflow fresh install notes]

[[Category:Postgres]]