Skip to content
  • Xela's avatar
    Add some SQL in README.md · 20aefc2e
    Xela authored
    
    
    Getting the error when adding non-root postgres user for exporter:
    ```
    postgres=# CREATE OR REPLACE FUNCTION get_pg_stat_statements() RETURNS SETOF pg_stat_statements AS
    postgres-# $$ SELECT * FROM public.pg_stat_statements; $$
    postgres-# LANGUAGE sql
    postgres-# VOLATILE
    postgres-# SECURITY DEFINER;
    ERROR:  type "pg_stat_statements" does not exist
    ```
    Add following sql command for enable pg_stat_statements:
    ```
    CREATE EXTENSION IF NOT EXISTS pg_stat_statements;
    ```
    
    Signed-off-by: default avatarXela Tirdan <xelatirdan@gmail.com>
    20aefc2e