Server Migration Fremont Los Angeles
Domains affected:
- abatros.com
- curabara.com
- espwave.com
- fleeflocker.com
- inhelium.com
- lekkyweb.com
- publibase.com
- publibase.org
- publishingautomation.com
- publishing-automation.com
- thgeom.com
- thgeom-academy.com
- editora.us
Databases:
local all postgres peer (pg_hba.cfg)
$ sudo su - postgres
# psql -p 5432
and do not forget to open the port.
- Los Angeles (SSDNODE)
- Fremont (Linode kmw)
- Dallas (Linode blueink)
- 10 (5432)
- blueink
- cms-oacs
- museum-v2
- oacs-5-10-0
- openacs-cms
- test_plv8
- wecan
- 11 (5433)
- cms-oacs
- museum-v2
- museum-v3
- test_plv8 **
- 12 (5434)
- blueink (museum-admin)
- museum-v3 (postgres)
- oacs-5-10-0 (postgres)
- 14 (5435) &emdash; empty
useful commands:
sudo apt-get --purge remove postgresql-14
dkz@fremont:~$ ll /var/lib/postgresql/
dpkg -l | grep postgresql
sudo apt-get remove postgresql-client-common
systemctl list-dependencies postgresql
sudo -u postgres psql --cluster 14/main
sudo service postgresql@14-main restart
sudo ss -tunelp | grep 5434
Moving Apps.
Museum Application (233-mapp)
- deep-search, quick-search and indexes are all using same database.
https://github.com/blueink-bkk/233-mapp
- installed on Fremont (66.175.216.90): Ok. Moved database on Fremont: Ok.
- redeployed on Dallas with zodern:latest → Ok.
- Dallas :
http://museum.ultimheat.com/deep-search → Ok.
- Fremont db: blueink, port:5434, user: postgres
- blueink:
service postgresql@12-main stop → JC access blocked. Ok.
alter user museum_admin with password 'juliet@104plumchit'
- commit/push GitHub, then clone rebuild →meteor npm install --save js-yaml massive pg-monitor object-hash ramda nspell dictionary-fr
dictionary-en-us dictionary-de express fs-extra busboy express-device
- Need some cleaning : replace massive with pg-postgres
css detected: