Versions Compared

Old Version 2

changes.mady.by.user Chichi

Saved on

compared with

New Version Current

changes.mady.by.user Sidney Chen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Scroll ignore
scroll-viewporttrue
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-htmltrue
scroll-epubtrue

Open in new tab

This page will guide you through the setup of Postgres in K using the direct connect method.

...

  • The user must also be able to connect to all databases that you want onboarded.

Info

Note that visibility of entries in the pg_catalog tables will depend on if the user has SELECT access to the table, so make sure SELECT is granted to the <kada user> for all tables within the database. You may need to re-apply this grant if schemas are dropped, you may also wish to apply a default grant on the schema so future tables can be visible.

  1. Code Block
    GRANT SELECT ON ALL TABLES IN SCHEMA <schema> TO <kada user>
  2. Code Block
    ALTER DEFAULT PRIVILEGES IN SCHEMA <schema> public GRANT SELECT ON TABLES TO <kada user>

...

Step 2) Connecting K to Postgres

...