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)
  • 12 (empty)
• Fremont (Linode kmw)
  • 9.6 (5433)
    • empty
  • 14 (5432)
    • Museum
• 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:

• postgres=# drop database museum with (force);
• postgresql-server-doesnt-start
• how-to-install-postgresql-on-ubuntu-20-04
• sudo -u postgres pg_dumpall -U postgres -p 5432 >5432.sql

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