DB Import & Export - Revision history

Tacoball: /* PostgreSQL */

2026-10-22T06:33:46Z

PostgreSQL

← Older revision		Revision as of 06:33, 22 October 2026
Line 9:		Line 9:
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	source .env		source .env
	sudo docker exec -e PGPASSWORD="$OWNERS_PASSWORD" -it container_name pg_dump -U user -d dbname -a > backup.sql		sudo docker exec \
			-e PGPASSWORD="$OWNERS_PASSWORD" \
			-it container_name \
			pg_dump \
			-U user \
			-d dbname \
			-a > backup.sql
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-

2026-10-21T09:56:29Z

PostgreSQL

← Older revision		Revision as of 09:56, 21 October 2026
Line 37:		Line 37:
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-
	\| Restore from SQL \|\|		\| Restore from SQL into local database. \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	source .env		source .env
	sudo docker exec -e PGPASSWORD="$OWNERS_PASSWORD" -it container_name psql -U user -d dbname < backup.sql		sudo docker exec \
			-e PGPASSWORD="$OWNERS_PASSWORD" \
			-i container_name \
			psql \
			-U user \
			-d dbname < backup.sql
	</syntaxhighlight>		</syntaxhighlight>
	\|}		\|}

2026-10-21T09:53:44Z

PostgreSQL

← Older revision		Revision as of 09:53, 21 October 2026
Line 17:		Line 17:
	sudo docker exec \		sudo docker exec \
	-e PGPASSWORD="$OWNERS_PASSWORD" \		-e PGPASSWORD="$OWNERS_PASSWORD" \
	-it container_name \		-i container_name \
	pg_dump \		pg_dump \
	--data-only \		--data-only \

2026-10-21T09:46:25Z

PostgreSQL

← Older revision		Revision as of 09:46, 21 October 2026
Line 35:		Line 35:
	users		users
	RESTART IDENTITY;		RESTART IDENTITY;
			</syntaxhighlight>
			\|-
			\| Restore from SQL \|\|
			<syntaxhighlight lang="bash">
			source .env
			sudo docker exec -e PGPASSWORD="$OWNERS_PASSWORD" -it container_name psql -U user -d dbname < backup.sql
	</syntaxhighlight>		</syntaxhighlight>
	\|}		\|}

2026-10-21T09:44:10Z

PostgreSQL

2026-10-21T09:12:45Z

PostgreSQL

← Older revision		Revision as of 09:12, 21 October 2026
Line 6:		Line 6:
	! 🎯 Purpose \|\| ⌨️ Command		! 🎯 Purpose \|\| ⌨️ Command
	\|-		\|-
	\| ~~Back up~~ the database inside the container. \|\|		\| Perform a backup of the container’s database inside the container. \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	source .env		source .env

2026-10-21T09:12:02Z

PostgreSQL

← Older revision		Revision as of 09:12, 21 October 2026
Line 12:		Line 12:
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-
	\| ~~Backup<br>(~~container) \|\|		\| Perform a remote database backup inside the container. \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	source .env		source .env

2026-10-21T09:11:09Z

PostgreSQL

← Older revision		Revision as of 09:11, 21 October 2026
Line 6:		Line 6:
	! 🎯 Purpose \|\| ⌨️ Command		! 🎯 Purpose \|\| ⌨️ Command
	\|-		\|-
	\| ~~Backup<br>(~~container) \|\|		\| Back up the database inside the container. \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	source .env		source .env

2026-10-21T09:08:08Z

PostgreSQL

← Older revision		Revision as of 09:08, 21 October 2026
Line 16:		Line 16:
	source .env		source .env
	sudo docker exec \		sudo docker exec \
	-e PGPASSWORD="$OWNERS_PASSWORD" \		-e PGPASSWORD="$OWNERS_PASSWORD" \
	-it container_name \		-it container_name \
	pg_dump \		pg_dump \
	--data-only \		--data-only \
	--column-inserts \		--column-inserts \
	--exclude-table=schema_migrations \		--exclude-table=schema_migrations \
	--exclude-table=spatial_ref_sys \		--exclude-table=spatial_ref_sys \
	-U user \		-U user \
	-h 192.168.0.253 \		-h 192.168.0.253 \
	-p 65432 \		-p 65432 \
	-d dbname		-d dbname
	</syntaxhighlight>		</syntaxhighlight>
	\|}		\|}

2026-10-21T09:07:03Z

PostgreSQL

@@ Line 5: / Line 5: @@
 {| class="wikitable"
 ! 🎯 Purpose || ⌨️ Command
 |-
 | Backup<br>(container) ||
@@ Line 20: / Line 15: @@
 <syntaxhighlight lang="bash">
 source .env
-sudo docker exec -e PGPASSWORD="$OWNERS_PASSWORD" -it container_name pg_dump -U user -d dbname -a > backup.sql
+sudo docker exec \
 </syntaxhighlight>
 |}