Hey , I was setting up pact broker on local and wa...
# pact-brokera
Ayush
08/17/2022, 10:31 AMHey , I was setting up pact broker on local and was wondering where the pacts are being stored and the role of postgres db that we set up
I couldn’t find any tables in the pact_broker database
m
Matt (pactflow.io / pact-js / pact-go)
08/17/2022, 11:02 AM
I can assure you a proper setup stores pacts in the PG database. My guess is that either you're looking at the wrong schema in the database or you've configured the data to go elsewhere (e.g. sqlite)
Matt (pactflow.io / pact-js / pact-go)
08/17/2022, 11:02 AM
Without your setup it's impossible to say.
b
Beth (pactflow.io/Pact Broker/pact-ruby)
08/17/2022, 11:16 PM
You can run this docker compose and then inspect the database https://github.com/pact-foundation/pact-broker-docker/blob/master/docker-compose.yml
Beth (pactflow.io/Pact Broker/pact-ruby)
08/17/2022, 11:18 PM
docker compose up Copy code
$ docker exec -it pact-broker-docker-postgres-1 psql -U postgres
psql (14.3 (Debian 14.3-1.pgdg110+1))
Type "help" for help.
postgres=# select * from pacticipants;
id | name | repository_url | created_at | updated_at | display_name | repositor
y_name | repository_namespace | main_development_branches | main_branch
----+-------------+-----------------------------------------------------+----------------------------+----------------------------+--------------+----------
-------+----------------------+---------------------------+-------------
1 | Example App | <https://github.com/example-organization/Example> App | 2022-08-01 23:16:42.900855 | 2022-08-17 23:16:42.960083 | Example App |
| | | main
2 | Example API | <https://github.com/example-organization/Example> API | 2022-08-01 23:16:42.907195 | 2022-08-17 23:16:43.124324 | Example API |
| | | main
(2 rows)a
Ayush
08/19/2022, 8:44 AMThanks for the help , it seems it was pgdb permission issue with the user
đź‘Ť 1