Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

migrate DB to hetz #56

Open
grooviegermanikus opened this issue Feb 8, 2024 · 1 comment
Open

migrate DB to hetz #56

grooviegermanikus opened this issue Feb 8, 2024 · 1 comment

Comments

@grooviegermanikus
Copy link
Collaborator

grooviegermanikus commented Feb 8, 2024 •
edited
Loading

  1. start temporary fly app for migration pointing to new DB
  2. run the temp app for a while (2 days)
  3. point dashboard to new DB and test
  4. delete temp app; update fly prod sidecar to point new DB
  5. delete temporary fly app
grooviegermanikus added a commit that referenced this issue Feb 8, 2024
@grooviegermanikus
fly app for migration
81e5580 
see #56
@grooviegermanikus
Copy link
Collaborator Author

setup fly app olana-bankingstage-geyser-sidecar-migrate-hetzner to fill new DB

grooviegermanikus added a commit that referenced this issue Feb 24, 2024
@grooviegermanikus
postgres schema fixes after moving to self-operated PostgreSQL (#57)
bab2595 
* remove indices from migration.sql which here never created

* BREAKING: make transaction_id the primary key in transactions lookup table

* use varchar in postgres.rs

* add "NOT NULL" constraint wherever possible

* fix small accounts lookup table naming

* fly app for migration

see #56

* autovacuum settings

* databse init script

* explain query_user role

* tune toast_tuple_target and comment on page size

* minor fixes

* dba queries

* jot down the fly machine config

* restore create schema

* tweak storage param for postgres 15
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@grooviegermanikus