supabase / benchmarks-archive

Infrastucture benchmarks
https://supabase.com
MIT License
31 stars 3 forks source link

Running pg and pgrest on same node #32

Closed Lakshmipathi closed 2 years ago

Lakshmipathi commented 2 years ago

Hi @steve-chavez , Moving this from slack to keep track of this issue.

Bug report

Hey, I had to remove this line while trying to use same node for both pg and pgrest with export PGRBENCH_SEPARATE_PG="false" option:

diff --git a/postgrest/deploy.nix b/postgrest/deploy.nix
 index 0d2e236..aaa5868 100644
 --- a/postgrest/deploy.nix
 +++ b/postgrest/deploy.nix
 @@ -211,7 +211,6 @@ in {
      ];
      networking.hosts = {
       "${nodes.pgrstServer.config.networking.privateIPv4}"   = [ "pgrst" ];
-      "${nodes.pg.config.networking.privateIPv4}"            = [ "pg" ];
     };
    };
  }

Describe the bug

Using same node for both pg and pgrest with export PGRBENCH_SEPARATE_PG="false" option, throws error.