Update migration documentation
1 unresolved thread
1 unresolved thread
Merge request reports
Activity
requested review from @lautenbach
assigned to @luijben
mentioned in commit eb4b7dcb
53 53 54 54 ## Dump and restore 55 55 On the database server, dump the newly combined table with the correct format and the date in the filename for future reference as follows: 56 > pg_dump -d ldvadmin -U ldvadmin -t lofardata_dataproduct -O > lofardata_fixture_<the_date>.sql 56 > pg_dump -d ldvadmin -U ldvadmin -t lofardata_dataproduct -O > lofardata_fixture_$(date +%d-%m-%y).sql 57 58 After the dump, copy the dumped .sql file to the server where ldvspec is deployed using the SCP command (for production, this is sdc.astron.nl). Subsequently, connect to this server and then to the ldv-spec-postgres docker container, which hosts the ldvspec database. 59 60 Before loading the data into the lofardata_dataproduct table, make sure to login to the database and empty the table: 61 62 > truncate table lofardata_dataproduct;
Please register or sign in to reply