Postgres:Database migration to a new server - Revision history

Daqasimi18 at 20:10, 3 August 2022

2022-08-03T20:10:25Z

← Older revision		Revision as of 20:10, 3 August 2022
Line 144:		Line 144:
	# Firstly, the newest version of PostgreSQL <code>14.3</code> was installed on Hopper.		# Firstly, the newest version of PostgreSQL <code>14.3</code> was installed on Hopper.
	# Then, the PostGIS extension was created to facilitate data that are geographical and location sensitive.		# Then, the PostGIS extension was created to facilitate data that are geographical and location sensitive.
	# Using psql database_name > dumped_database_name.sql ~~command~~ each of the above databases ~~were~~ dumped into separate .sql files.		# Using <code>psql database_name > dumped_database_name.sql</code> each of the above databases was dumped into separate <code>.sql</code> files.
	# Then by using the command scp dumped_database_name.sql username@cluster.earlham.edu :/location/to/store the dumped files were transferred to Hopper.		# Then, by using the command <code>scp dumped_database_name.sql username@cluster.earlham.edu :/location/to/store </code> the dumped files were transferred to Hopper.
	# Then by using the command sudo -u postgres psql < dumped_database_name.sql the dumped files were migrated to PostgreSQL on Hopper.		# Then, by using the command <code>sudo -u postgres psql < dumped_database_name.sql</code> the dumped files were migrated to PostgreSQL on Hopper.
	# ~~Finaly we use~~ the command select * from fieldday_trip was used to ensure the databases ~~are~~ restored properly.		# Finally, the command <code>select * from fieldday_trip</code> was used to ensure the databases were restored properly.

Daqasimi18 at 20:07, 3 August 2022

2022-08-03T20:07:30Z

← Older revision		Revision as of 20:07, 3 August 2022
Line 142:		Line 142:

	The following processes were used for moving or migrating the above databases to Hopper;		The following processes were used for moving or migrating the above databases to Hopper;
	# Firstly, the newest version of PostgreSQL ''14.3'' was installed on Hopper.		# Firstly, the newest version of PostgreSQL <code>14.3</code> was installed on Hopper.
	# Then, the PostGIS extension was created to facilitate data that are geographical and location sensitive.		# Then, the PostGIS extension was created to facilitate data that are geographical and location sensitive.
	# Using psql database_name > dumped_database_name.sql command each of the above databases were dumped into separate .sql files.		# Using psql database_name > dumped_database_name.sql command each of the above databases were dumped into separate .sql files.

Daqasimi18 at 20:06, 3 August 2022

2022-08-03T20:06:18Z

← Older revision		Revision as of 20:06, 3 August 2022
Line 142:		Line 142:

	The following processes were used for moving or migrating the above databases to Hopper;		The following processes were used for moving or migrating the above databases to Hopper;
	# Firstly, the newest version of PostgreSQL 14.3 was installed on Hopper.		# Firstly, the newest version of PostgreSQL ''14.3'' was installed on Hopper.
	# Then, the PostGIS extension was created to facilitate data that are geographical and location sensitive.		# Then, the PostGIS extension was created to facilitate data that are geographical and location sensitive.
	# Using psql database_name > dumped_database_name.sql command each of the above databases were dumped into separate .sql files.		# Using psql database_name > dumped_database_name.sql command each of the above databases were dumped into separate .sql files.

Daqasimi18 at 20:01, 3 August 2022

2022-08-03T20:01:06Z

← Older revision		Revision as of 20:01, 3 August 2022
Line 97:		Line 97:
	On Bowie there are some databases that are only needed for research and faculty. Some of the faculty�s databases contain important information that has to be secured and accessed by the specific users. To ensure that faculty�s databases and data are secure, system administrators decided to move those databases to Hopper server where research databases on PostgreSQL won�t be mixed up with students� assignments and practice databases. The following is the list of databases that are used for research or contain valuable information and they were moved to Hopper for security;		On Bowie there are some databases that are only needed for research and faculty. Some of the faculty�s databases contain important information that has to be secured and accessed by the specific users. To ensure that faculty�s databases and data are secure, system administrators decided to move those databases to Hopper server where research databases on PostgreSQL won�t be mixed up with students� assignments and practice databases. The following is the list of databases that are used for research or contain valuable information and they were moved to Hopper for security;

	*AB-hopper		* AB-hopper
	*AB_ts-hopper		* AB_ts-hopper
	*FSE-hopper		* FSE-hopper
	*FSE_test-hopper		* FSE_test-hopper
	*LearnGIS-hopper		* LearnGIS-hopper
	*WHD-hopper		* WHD-hopper
	*b-and-t-g-hopper		* b-and-t-g-hopper
	*bccd-hopper		* bccd-hopper
	*bidforme		* bidforme
	*datascience-hopper		* datascience-hopper
	*dc-tests-hopper		* dc-tests-hopper
	*emergency-hopper		* emergency-hopper
	*energy		* energy
	*epic_db		* epic_db
	*field_science		* field_science
	*field_science-hopper		* field_science-hopper
	*field_science_testing-hopper		* field_science_testing-hopper
	*field_science_v2		* field_science_v2
	*fieldsci_db		* fieldsci_db
	*fs_test-hopper		* fs_test-hopper
	*fs_test_cjearley13-hopper		* fs_test_cjearley13-hopper
	*fs_test_craig		* fs_test_craig
	*hospital_jpa_db		* hospital_jpa_db
	*ifs2018_db-hopper		* ifs2018_db-hopper
	*inventory		* inventory
	*mydat		* mydat
	*pgsql-hopper		* pgsql-hopper
	*phi_account		* phi_account
	*phi_account_test		* phi_account_test
	*phi_account_test_db		* phi_account_test_db
	*phi_test_2_db		* phi_test_2_db
	*phi_test_db		* phi_test_db
	*seniorsem-hopper		* seniorsem-hopper
	*template0		* template0
	*template1		* template1
	*trac_debian-cluster-hopper		* trac_debian-cluster-hopper
	*transport_test-hopper		* transport_test-hopper
	*tvbase		* tvbase
	*voting_data-hopper		* voting_data-hopper
	*weather		* weather
	* weatherduck-hopper		* weatherduck-hopper
	* x-hopper		* x-hopper
Line 142:		Line 142:

	The following processes were used for moving or migrating the above databases to Hopper;		The following processes were used for moving or migrating the above databases to Hopper;
	Firstly, the newest version of PostgreSQL 14.3 was installed on Hopper.		# Firstly, the newest version of PostgreSQL 14.3 was installed on Hopper.
	Then, the PostGIS extension was created to facilitate data that are geographical and location sensitive.		# Then, the PostGIS extension was created to facilitate data that are geographical and location sensitive.
	Using psql database_name > dumped_database_name.sql command each of the above databases were dumped into separate .sql files.		# Using psql database_name > dumped_database_name.sql command each of the above databases were dumped into separate .sql files.
	Then by using the command scp dumped_database_name.sql username@cluster.earlham.edu :/location/to/store the dumped files were transferred to Hopper.		# Then by using the command scp dumped_database_name.sql username@cluster.earlham.edu :/location/to/store the dumped files were transferred to Hopper.
	Then by using the command sudo -u postgres psql < dumped_database_name.sql the dumped files were migrated to PostgreSQL on Hopper.		# Then by using the command sudo -u postgres psql < dumped_database_name.sql the dumped files were migrated to PostgreSQL on Hopper.
	~~Again,~~ the command select * from fieldday_trip was used to ensure the databases are restored properly.		# Finaly we use the command select * from fieldday_trip was used to ensure the databases are restored properly.

Daqasimi18 at 19:53, 3 August 2022

2022-08-03T19:53:30Z

← Older revision		Revision as of 19:53, 3 August 2022
Line 107:		Line 107:
	*bidforme		*bidforme
	*datascience-hopper		*datascience-hopper
			*dc-tests-hopper
			*emergency-hopper
			*energy
			*epic_db
			*field_science
			*field_science-hopper
			*field_science_testing-hopper
			*field_science_v2
			*fieldsci_db
			*fs_test-hopper
	dc-tests-hopper		*fs_test_cjearley13-hopper
	emergency-hopper		*fs_test_craig
	energy		*hospital_jpa_db
	epic_db		*ifs2018_db-hopper
	field_science		*inventory
	field_science-hopper		*mydat
	field_science_testing-hopper		*pgsql-hopper
	field_science_v2		*phi_account
	fieldsci_db		*phi_account_test
	fs_test-hopper		*phi_account_test_db
	fs_test_cjearley13-hopper		*phi_test_2_db
	fs_test_craig		*phi_test_db
	hospital_jpa_db		*seniorsem-hopper
	ifs2018_db-hopper		*template0
	inventory		*template1
	mydat		*trac_debian-cluster-hopper
	pgsql-hopper		*transport_test-hopper
	phi_account		*tvbase
	phi_account_test		*voting_data-hopper
	phi_account_test_db		*weather
	phi_test_2_db		* weatherduck-hopper
	phi_test_db		* x-hopper
	seniorsem-hopper
	template0
	template1
	trac_debian-cluster-hopper
	transport_test-hopper
	tvbase
	voting_data-hopper
	weather
	weatherduck-hopper
	x-hopper

Daqasimi18 at 18:58, 3 August 2022

2022-08-03T18:58:57Z

← Older revision		Revision as of 18:58, 3 August 2022
Line 97:		Line 97:
	On Bowie there are some databases that are only needed for research and faculty. Some of the faculty�s databases contain important information that has to be secured and accessed by the specific users. To ensure that faculty�s databases and data are secure, system administrators decided to move those databases to Hopper server where research databases on PostgreSQL won�t be mixed up with students� assignments and practice databases. The following is the list of databases that are used for research or contain valuable information and they were moved to Hopper for security;		On Bowie there are some databases that are only needed for research and faculty. Some of the faculty�s databases contain important information that has to be secured and accessed by the specific users. To ensure that faculty�s databases and data are secure, system administrators decided to move those databases to Hopper server where research databases on PostgreSQL won�t be mixed up with students� assignments and practice databases. The following is the list of databases that are used for research or contain valuable information and they were moved to Hopper for security;

	AB-hopper bccd-hopper		*AB-hopper
	AB_ts-hopper bidforme		*AB_ts-hopper
	FSE-hopper datascience-hopper		*FSE-hopper
	*FSE_test-hopper		*FSE_test-hopper
	*LearnGIS-hopper		*LearnGIS-hopper
	*WHD-hopper		*WHD-hopper
	*b-and-t-g-hopper		*b-and-t-g-hopper
			*bccd-hopper
			*bidforme
			*datascience-hopper

Daqasimi18 at 18:58, 3 August 2022

2022-08-03T18:58:16Z

← Older revision		Revision as of 18:58, 3 August 2022
Line 97:		Line 97:
	On Bowie there are some databases that are only needed for research and faculty. Some of the faculty�s databases contain important information that has to be secured and accessed by the specific users. To ensure that faculty�s databases and data are secure, system administrators decided to move those databases to Hopper server where research databases on PostgreSQL won�t be mixed up with students� assignments and practice databases. The following is the list of databases that are used for research or contain valuable information and they were moved to Hopper for security;		On Bowie there are some databases that are only needed for research and faculty. Some of the faculty�s databases contain important information that has to be secured and accessed by the specific users. To ensure that faculty�s databases and data are secure, system administrators decided to move those databases to Hopper server where research databases on PostgreSQL won�t be mixed up with students� assignments and practice databases. The following is the list of databases that are used for research or contain valuable information and they were moved to Hopper for security;

			AB-hopper bccd-hopper
			AB_ts-hopper bidforme
			FSE-hopper datascience-hopper
			*FSE_test-hopper
			*LearnGIS-hopper
			*WHD-hopper
			*b-and-t-g-hopper



	~~AB-hopper~~
	~~AB_ts-hopper~~
	~~FSE-hopper~~
	~~FSE_test-hopper~~
	~~LearnGIS-hopper~~
	~~WHD-hopper~~
	~~b-and-t-g-hopper~~
	~~bccd-hopper~~
	~~bidforme~~
	~~datascience-hopper~~

Daqasimi18 at 18:55, 3 August 2022

2022-08-03T18:55:58Z

← Older revision		Revision as of 18:55, 3 August 2022
Line 98:		Line 98:






	~~{{columns-list\|colwidth=10em\|~~
	~~# a~~
	~~# b~~
	~~# c~~
	~~# d~~
	~~# e~~
	}}

Daqasimi18 at 18:52, 3 August 2022

2022-08-03T18:52:01Z

← Older revision		Revision as of 18:52, 3 August 2022
Line 97:		Line 97:
	On Bowie there are some databases that are only needed for research and faculty. Some of the faculty�s databases contain important information that has to be secured and accessed by the specific users. To ensure that faculty�s databases and data are secure, system administrators decided to move those databases to Hopper server where research databases on PostgreSQL won�t be mixed up with students� assignments and practice databases. The following is the list of databases that are used for research or contain valuable information and they were moved to Hopper for security;		On Bowie there are some databases that are only needed for research and faculty. Some of the faculty�s databases contain important information that has to be secured and accessed by the specific users. To ensure that faculty�s databases and data are secure, system administrators decided to move those databases to Hopper server where research databases on PostgreSQL won�t be mixed up with students� assignments and practice databases. The following is the list of databases that are used for research or contain valuable information and they were moved to Hopper for security;

	{{columns-list\|colwidth=~~15em\|class=plainlist\|style=width: 600px; font-style: italic;~~\|
	* [[AB-hopper]]
	* [[AB_ts-hopper]]
	* [[FSE-hopper]]
	* [[FSE_test-hopper]]
	* [[LearnGIS-hopper]]		{{columns-list\|colwidth=10em\|
	* [[WHD-hopper]]		# a
	* [[b~~-and-t-g-hopper]]~~		# b
	* [[bccd-hopper]]		# c
	* [[bidforme ]]		# d
	* [[datascience-hopper]]		# e
	}}		}}


			AB-hopper
			AB_ts-hopper
			FSE-hopper
			FSE_test-hopper
			LearnGIS-hopper
			WHD-hopper
			b-and-t-g-hopper
			bccd-hopper
			bidforme
			datascience-hopper

Daqasimi18 at 18:39, 3 August 2022

2022-08-03T18:39:58Z

@@ Line 96: / Line 96: @@
 On Bowie there are some databases that are only needed for research and faculty. Some of the faculty�s databases contain important information that has to be secured and accessed by the specific users. To ensure that faculty�s databases and data are secure, system administrators decided to move those databases to Hopper server where research databases on PostgreSQL won�t be mixed up with students� assignments and practice databases. The following is the list of databases that are used for research or contain valuable information and they were moved to Hopper for security;
 dc-tests-hopper
 emergency-hopper