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.

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

Postgres: accept list of init .sql dumps #64

Closed
Tracked by #3718
shivaraj-bh opened this issue Dec 13, 2023 · 0 comments · Fixed by #67
Closed
Tracked by #3718

Postgres: accept list of init .sql dumps #64

shivaraj-bh opened this issue Dec 13, 2023 · 0 comments · Fixed by #67
Labels
enhancement New feature or request good first issue Good for newcomers

Comments

@shivaraj-bh
Copy link
Member

Probably like this:

services.postgres.pg1 = {
  enable = true;
  initDumps = [
    ./dump1.sql
    ./dump2.sql
  ];
};
@shivaraj-bh shivaraj-bh added enhancement New feature or request good first issue Good for newcomers labels Dec 13, 2023
srid added a commit to nammayatri/nammayatri that referenced this issue Jan 22, 2024
Migrate from docker-compose to Nix (via
https://github.com/juspay/services-flake )

TODO:
- [x] Add osrm-server to services
(f8b27f1)
(97e0824)
- [x]
`db-primary`(02eb257)
(f9fa2af)
  - [x] juspay/services-flake#64
- [x] nixpkgs: `postgis` extension doesn't work on macOS (**merging with
main solved it — main has a more latest nixpkgs**)
- [x] `location-db`
(02eb257)
(01e238c)
- [x] Figure out the configuration for syncing `db-replica` and
`location-db-replica` with their respective masters **->** Run
[pg_basebackup](https://www.postgresql.org/docs/current/app-pgbasebackup.html)
in a separate process.
(02eb257)
(ad639bd)
  - [x] juspay/services-flake#70 
- [ ] Once successful, write a short note on
juspay/services-flake#65
- [x] `redis`
(02eb257)
- [x] `initalDumps` in passetto service
(nammayatri/passetto#5)
- [x] `initialDumps` in
[services-flake](juspay/services-flake#64).
- [x] `passetto`
(02eb257)
- [x] `zookeeper`
(5b5e008)
- [x] `kafka`
(5b5e008)
- [x] `nginx`
(5b5e008)
- [x] `redis-cluster`
(5b5e008)
- [ ] Update FAQ section linking to a `services-flake` doc explaining
about data directory and how to get a fresh start for a service.
- [x] Add `namespace` to `pgBaseBackup*` processes.

The following issues will be part of a different PR
- Add grafana to services-flake
juspay/services-flake#59
- Add prometheus to services-flake
juspay/services-flake#60
- Add pgadmin to services-flake
juspay/services-flake#80

## Run services natively with `services-flake` (MacOS and Linux)
```
nix run github:shivaraj-bh/nammayatri/services-flake#services --refresh
```

**Note: passetto-server uses rosetta emulation on MacOS due to
juspay/passetto#2

---------

Co-authored-by: Rohit Singh <rsrohitsingh68@gmail.com>
Co-authored-by: Shivaraj <shivaraj@shivaraj-macbookpro.beagle-neon.ts.net>
Co-authored-by: Sridhar Ratnakumar <3998+srid@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request good first issue Good for newcomers
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant