Postgres - Revision history

Piousbox at 01:59, 21 March 2022

2022-03-21T01:59:46Z

2022-03-21T01:59:25Z

2022-02-20T17:32:01Z

2022-02-16T19:00:27Z

2020-12-07T18:21:59Z

2020-12-07T17:55:09Z

2020-06-03T14:17:09Z

2019-02-04T18:39:23Z

2019-01-31T16:19:48Z

2019-01-31T16:19:14Z

← Older revision		Revision as of 01:59, 21 March 2022
Line 1:		Line 1:
		+	= Develop =
	Config file:		Config file:
	sudo vim /etc/postgresql/9.5/main/pg_hba.conf		sudo vim /etc/postgresql/9.5/main/pg_hba.conf

← Older revision		Revision as of 01:59, 21 March 2022
Line 1:		Line 1:
		+	Config file:
		+	sudo vim /etc/postgresql/9.5/main/pg_hba.conf
	== check version ==		== check version ==

@@ Line 2: / Line 2: @@
   ActiveRecord::Base.connection.select_value('SELECT version()')
 == import ==
   pg_restore --verbose --no-acl --no-owner --data-only -h localhost -d HaulHub_development latest.dump
@@ Line 52: / Line 61: @@
 </pre>
 == who is connected to the database? ==

← Older revision		Revision as of 19:00, 16 February 2022
Line 62:		Line 62:

	docker-compose up		docker-compose up
		+
		+	=== Restart on mac os x ===
		+	brew services restart postgres

	== Troubleshooting ==		== Troubleshooting ==

← Older revision		Revision as of 18:21, 7 December 2020
Line 2:		Line 2:

	ActiveRecord::Base.connection.select_value('SELECT version()')		ActiveRecord::Base.connection.select_value('SELECT version()')
		+
		+	== import ==
		+
		+	pg_restore --verbose --no-acl --no-owner --data-only -h localhost -d HaulHub_development latest.dump

	== Install ==		== Install ==

← Older revision		Revision as of 17:55, 7 December 2020
Line 1:		Line 1:
		+	== check version ==
		+
		+	ActiveRecord::Base.connection.select_value('SELECT version()')
		+
	== Install ==		== Install ==
	<pre>		<pre>

@@ Line 1: / Line 1: @@
 == Install ==
 <pre>
 brew install postgresql
 brew services start postgresql

@@ Line 45: / Line 45: @@
 == postgres import sql ==
   psql databasename < data_base_dump
 == Use on Mac Os X ==

@@ Line 1: / Line 1: @@
-=== Install ===
+== Install ==
 <pre>
 brew install postgresql
@@ Line 14: / Line 14: @@
 </pre>
-=== install utils ===
+== install utils ==
 <pre>
   sudo apt-get purge postgresql-client-*
@@ Line 24: / Line 24: @@
 </pre>
-=== check size of each database ===
+== check size of each database ==
 From: https://wiki-bsse.ethz.ch/display/ITDOC/Check+size+of+tables+and+objects+in+PostgreSQL+database
@@ Line 34: / Line 34: @@
 </pre>
-=== check size of each table ===
+== check size of each table ==
 <pre>
 SELECT
@@ Line 43: / Line 43: @@
 </pre>
-=== postgres import sql ===
+== postgres import sql ==
   psql databasename < data_base_dump
-=== pesky buggy stuff ===
+== pesky buggy stuff ==
 <pre>