Skip to content

ERROR: relation "tb_config" does not exist when install  #163

@Sievpao10

Description

@Sievpao10

Dear valued team,

Currently, I am facing issue ERROR: relation "tb_config" does not exist after following all the installation step.
[postgres@DC-DB eXperDB_Repository]$ ./install.sh -h 192.168.56.51 -d postgres -p 5432 -U postgres -W postgres1


  • __ __ __ ___ *
  • \ / /_ ___ _ _| | \ *
  • / _ \ /|- / _ ) '| | | ' / *
  • _/ |_| _|_| | | | ' \ *
  • //_\ |/|/ *

Install eXperDB-PGMON Repository

Step.1 Create the databse of owner.
Database owner pgmon already exists, skipping creation.
Please enter password for pgmon:

Step.2 Create the databse.
Input Database name(Default : experdb) : pgmon
Would you like to drop the database pgmon before recreate it? [y/N/q] y
Running: dropdb -h localhost -p 5432 -U postgres pgmon
Running: createdb -h localhost -p 5432 -U postgres -E UTF8 --lc-collate=en_US.UTF-8 --lc-ctype=en_US.UTF-8 --owner pgmon pgmon

Step.3 Create the schema and tables.
Running: psql -h localhost -p 5432 -U pgmon -d pgmon -c "CREATE SCHEMA pgmon;"
Would you like to create schema pgmon in database pgmon? [y/N/q] y
CREATE SCHEMA

Step.4 Configure agent connection information.
Input Agent Host(Default : 192.168.56.51) :
Input Agent Port(Default : 5960) :
ERROR: relation "tb_config" does not exist
LINE 1: select 't' as result from tb_config where (select count(*) a...
^
ERROR: relation "tb_config" does not exist
LINE 1: update tb_config set agent_ip = trim('192.168.56.51'), agent...
^
Failure to update the agent ip and port of tb_config
ERROR:
[postgres@princebank eXperDB_Repository]$

Please kindly help to suggest and fix.
I am looking forward to hearing from you soon.
Your help and support is highly appreciated.

Thank you

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions