Commit Graph
23 Commits
Author SHA1 Message Date
419eba99a1 fix(self-hosted): self hosted docker compose (#30674)
* fix(self-host): ensure migrations connect back to postgres database

* fix(self-host): use supabase_admin user for supavisor pooler

* fix(self-host): services healthchecks

* fix(self-host): vector config path

* feat(ci): add smoke test for self-hosted stack

---------

Co-authored-by: Shawal Mbalire <mbalireshawal@gmail.com>
Co-authored-by: Robson Martins <robson@controle.digital>
2024-11-28 11:37:08 +00:00
Andrew Valleteau 4bad8499ae feat: introduce _supabase database add supavisor to self-hosted (#29596)
* chore: move _analytics to a distinct database

Following: https://github.com/supabase/cli/pull/2707

BREAKING CHANGES:
When migrating from an older version you will need to manually create the new internal _supabase
database and analytics schema the same way the  and  do.
Via:

* feat: add supavisor to the self-hosted stack

* chore(docs): add docs about supavisor

* chore: fix reviewdog warning

* chore: fix typo

* chore: apply pr comments
2024-10-08 13:49:09 +02:00
d1a38abccd fix(docker): Add JWT init script (#17033)
* Add JWT init script

* newline

---------

Co-authored-by: Ant Wilson <awalias@users.noreply.github.com>
Co-authored-by: Bobbie Soedirgo <bobbie@soedirgo.dev>
2023-11-15 15:41:32 +08:00
Filipe Cabaco 86df3b657d Update DB_SCHEMA from _logs to _analytics 2023-04-04 02:09:10 +01:00
Filipe Cabaco 253836dec0 Set schema for logs service 2023-04-04 02:09:10 +01:00
Qiao Han c030d67a80 chore: add empty line 2023-03-09 18:08:08 +08:00
Qiao Han 36abab8662 chore: update grants for webhooks 2023-03-09 18:08:08 +08:00
Francisco Mazzoni 0df99c2d31 feat: enable webhooks for self-hosted 2023-02-02 18:16:43 +08:00
Qiao Han 9b163309c8 feat: update realtime image to v2.0 2023-01-05 15:22:34 +08:00
winwangqi 5ccb85196f fix: POSTGRES_PASSWORD key (#10573)
Fix POSTGRES_PASSWORD key, consistent with /docker/.env.example POSTGRES_PASSWORD
2022-12-20 13:16:50 +01:00
Joshen Lim 83b48a6907 Add database size usage in reports database 2022-11-01 14:30:13 +07:00
Han Qiao eae6905d42 chore: update self hosted to use latest postgres image (#9973)
* chore: remove outdated migration files

* chore: update docker compose to use latest images

* chore: remove commented lines

* chore: update default role passwords

* chore: add no restart flag in dev

* chore: update example env

* chore: add comments

* chore: bump storage and studio images

* chore: default pgmeta to use admin role

* chore: do not update su role
2022-11-01 12:26:12 +08:00
dragarcia 9b6fa6a212 Remove unhelpful comments 2022-04-08 12:40:07 +01:00
dragarcia 7a846ebdd6 update docker init sql file for pg_graphql 2022-04-08 12:33:37 +01:00
dragarcia e5e86ba1eb chore: update self-hosted setup 2022-03-29 16:27:46 +02:00
Benjamin Tan 6edf5b84c8 docker: properly notify PostgREST to reload schema cache on DDL command end 2022-01-14 15:15:00 +08:00
0xflotus 76e1254a91 chore: change case in initial db script
for convenience reasons
2021-12-09 06:27:11 +05:30
Wen Bo Xie 27042469b5 docs: add Realtime security docs 2021-11-30 17:55:21 -05:00
Copple c8d910ac7a test change in auth ownership (#4031)
* test change in auth ownership

* fixes table -> function

* Adds execut permissions

* remove grants

* adds execute to everyone
2021-11-26 16:10:10 +08:00
Bobbie Soedirgo 6511fcc4ca fix(docker): revert self host volumes change (#4011)
* fix(docker): revert self host volumes change

* chore(docker): update images

* chore(docker): pg-meta -> meta
2021-11-24 08:12:39 +08:00
614faed4e4 Chore/postgrest v9 (#3988)
* using slack clone to test

* updates auth functions to handle new GUC commands

* move postgREST to new version

* testing with todo list

* makeing our mount setup far more robust

* Adds some usage commands

* cleans up the auth functions

* test with todos app

* fix env var for GUC

* new auth functions - changed for performance improvement

* Adds some integration tests for RLS

* anon volume on postgres

* remove unused helpers

* fix broken docusaurus build

* Fix complaining vercel

* test instructions

* Use named imports

* Fixes imports

* all relative

* chore: add in tsconfig.json to /web

* finding these all over the place

* Update docker/docker-compose.yml

Co-authored-by: Steve Chavez <stevechavezast@gmail.com>

Co-authored-by: Jonathan Summers-Muir <MildTomato@users.noreply.github.com>
Co-authored-by: Steve Chavez <stevechavezast@gmail.com>
2021-11-24 00:31:07 +08:00
Copple 663490876e makeing our mount setup far more robust (#3995) 2021-11-22 17:08:21 +08:00
Bobbie Soedirgo 0e036d4948 chore: update self-host setup 2021-09-30 07:30:40 +08:00