postgresql

[night dew]

how to integrate postgresql with backstage to see all the schema and entities

[near kayak]

Hi @night dew, can you clarify what your mean? When you say "schema and entities" do you mean of the Postgres database itself? Backstage uses Postgres to store data and the entities in the Catalog come from YAML files that would live along with their respective Components.

[night dew]

yes i mean Postgres database itself

[near kayak]

Ok, there's no plugin that I know of that does that then.

Also, ideally please don't post in several places. It makes extra work for those trying to help.

[night dew]

@near kayak As you have mentioned backsatge use postgresql to store data and entitites , so we configure backstage with postgresql then ideally some default tables should be created right . but could get nay default tables

database:
client: pg
connection:
host: 127.0.0.1
port: 5432
user: user_name
password: password

is there any config missing from my side to generate the tabels auomatic

[honest tide]

Have you veried the connection and populated any entities?

[dapper nexus]

Hi @night dew , PostgreSQL does indeed show the data in tables from backstage, and you can view this data directly using tools such as pgAdmin.

[night dew]

connection i have verified its able to connect properly actually it was giving some permision issue when i cretaed new user , later on given the permision to the newwly created user then that permision isue gone .
Ideally my understanding was it will show all the related tables related to backstage .
But unfortunally unable to see anything

[night dew]

instead of pgAdmin i am using dbeaver uniivalsal DB

[dapper nexus]

I see, not sure what might be going wrong.

[night dew]

i got to see now i guess i was using some other uI tool like dbeaver , there i could not see but now able to see in pgAdmin

[night dew]

hey Team ,
Just to reframe the question regarding postgresql , is there any pugin via which we can see all th eschema and entitites present in our application and all application data is in postgresql

https://backstage.io/docs/deployment/k8s#creating-the-postgresql-database

[near kayak]

For myself I think your question can be interpreted in a few ways. Can you share some exact examples so I can properly answer, please?