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
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