Not able to Store data in pstgres database.

[tejaswinit2024]

I have install the latest version of Convoy v24.1.2 but still i am not able to store the data in the postgres database as I have added the database connection details in convoy file and configured not able to store data. Is their any procedure need to follow please mention.

[linear]

CON-303 Not able to Store data in pstgres database.

[jirevwe]

You can use this guide to create the config file.

[tejaswinit2024]

2024-02-23 17:15:52 2024-02-23 11:45:52.459 UTC [1] LOG: starting PostgreSQL 15.2 on x86_64-pc-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r4) 12.2.1 20220924, 64-bit 2024-02-23 17:15:52 2024-02-23 11:45:52.459 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-02-23 17:15:52 2024-02-23 11:45:52.459 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-02-23 17:15:52 2024-02-23 11:45:52.463 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-02-23 17:15:52 2024-02-23 11:45:52.469 UTC [24] LOG: database system was shut down at 2024-02-23 11:45:19 UTC 2024-02-23 17:15:52 2024-02-23 11:45:52.475 UTC [1] LOG: database system is ready to accept connections 2024-02-23 17:15:52 2024-02-23 17:15:52 PostgreSQL Database directory appears to contain a database; Skipping initialization 2024-02-23 17:15:52 these are the logs i am getting when i config the convoy.. Thanks, Tejaswini

…

________________________________ From: Raymond Tukpe ***@***.***> Sent: Friday, February 23, 2024 5:01 PM To: frain-dev/convoy ***@***.***> Cc: Tejaswini Gowda ***@***.***>; Author ***@***.***> Subject: Re: [frain-dev/convoy] Not able to Store data in pstgres database. (Issue #1941) CAUTION: This email was sent from an external email account. Proceed carefully. You can use this guide<https://docs.getconvoy.io/deployment/configuration> to create the config file. — Reply to this email directly, view it on GitHub<#1941 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BGMLTUAXSEVL76DEXC5ANWDYVB425AVCNFSM6AAAAABDWR2UTSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRRGE3DMOBVHE>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[jirevwe]

Hmm, These are postgres logs, what am I meant to do with them? Can I see your convoy.json file?

[tejaswinit2024]

This is my convoy.json file. Here i have configured the Db connection but still i am not able to store the data in database. Thanks, Tejaswini

…

________________________________ From: Raymond Tukpe ***@***.***> Sent: Friday, February 23, 2024 7:17 PM To: frain-dev/convoy ***@***.***> Cc: Tejaswini Gowda ***@***.***>; Author ***@***.***> Subject: Re: [frain-dev/convoy] Not able to Store data in pstgres database. (Issue #1941) CAUTION: This email was sent from an external email account. Proceed carefully. Hmm, These are postgres logs, what am I meant to do with them? Can I see your convoy.json file? — Reply to this email directly, view it on GitHub<#1941 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BGMLTUBS477PJS5RRWJXSMLYVCMXXAVCNFSM6AAAAABDWR2UTSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRRGM2TONJUG4>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[jirevwe]

There's no convoy.json file in your message. It might be because you are attaching it to your email. It might be best to open the issue on Git Hub and paste it as text, or just send another email with it in the email body and not an attachment.

[tejaswinit2024]

convoy.json file { "auth": { "native": { "enabled": true }, "jwt": { "enabled": true, "secret": "<insert-jwt-secret>", "expiry": 3600, "refresh_secret": "<insert-jwt-refresh-secret>", "refresh_expiry": 86400 }, "is_signup_enabled": true }, "database": { "type": "postgres", "scheme": "postgres", "host": "localhost", "username": "postgres", "password": "postgres", "database": "convoy", "options": "sslmode=disable", "port": 5432, "max_open_conn": 100, "max_idle_conn": 10, "conn_max_lifetime": 3600 }, "redis": { "scheme": "redis", "host": "localhost", "username": "redis", "password": "redis", "database": "0", "port": 6379, "addresses": "" }, "prometheus": { "dsn": "<insert-prometheus-dsn>" }, "server": { "http": { "ssl": true, "ssl_cert_file": "<insert-ssl-cert-file>", "ssl_key_file": "<insert-ssl-key-file>", "port": 5005, "ingest_port": 5006, "worker_port": 5007, "socket_port": 5008, "domain_port": 5009, "proxy": "" } }, "max_response_size": 102400, "smtp": { "ssl": true, "provider": "<insert-smtp-provider>", "url": "<insert-smtp-url>", "port": 587, "username": "<insert-smtp-username>", "password": "<insert-smtp-password>", "from": "<insert-smtp-from>", "reply-to": "<insert-smtp-reply-to>" }, "env": "production", "logger": { "level": "info" }, "tracer": { "type": "new_relic", "new_relic": { "app_name": "<insert-new-relic-app-name>", "license_key": "<insert-new-relic-license-key>", "config_enabled": true, "distributed_tracer_enabled": true } }, "host": "<insert-host>", "custom_domain_suffix": "<insert-custom-domain-suffix>", "feature_flag": "experimental", "analytics": { "enabled": true }, "storage_policy": { "type": "s3 | on_prem", "s3": { "prefix": "<insert-s3-prefix>", "bucket": "<insert-s3-bucket>", "access_key": "<insert-s3-access-key>", "secret_key": "<insert-s3-secret-key>", "region": "<insert-s3-region>", "session_token": "<insert-s3-session-token>", "endpoint": "<insert-s3-endpoint>" }, "on_prem": { "path": "<insert-on-prem-path>" } }, "consumer_pool_size": 200 }

…

________________________________ From: Raymond Tukpe ***@***.***> Sent: Monday, February 26, 2024 3:33 PM To: frain-dev/convoy ***@***.***> Cc: Tejaswini Gowda ***@***.***>; Author ***@***.***> Subject: Re: [frain-dev/convoy] Not able to Store data in pstgres database. (Issue #1941) CAUTION: This email was sent from an external email account. Proceed carefully. There's no convoy.json file in your message. It might be because you are attaching it to your email. It might be best to open the issue on Git Hub and paste it as text, or just send another email with it in the email body and not an attachment. — Reply to this email directly, view it on GitHub<#1941 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BGMLTUEUOOWCIUTRSXISJBDYVRMY3AVCNFSM6AAAAABDWR2UTSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRTG4ZTSOJXGI>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[jirevwe]

Hey @tejaswinit2024

Have you had any luck with this? If you need more hands-on help, consider joining our Slack community.