:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
import { useActions, useValues } from 'kea'
import { Form } from 'kea-forms'
import { LemonButton, LemonCheckbox, LemonInput, LemonModal, LemonSelect, lemonToast } from '@posthog/lemon-ui'
import { LemonField } from 'lib/lemon-ui/LemonField'
import { LemonFileInput } from 'lib/lemon-ui/LemonFileInput/LemonFileInput'
import IconPostgres from 'public/services/postgres.png'
import { PostgreSQLSetupModalLogicProps, postgreSQLSetupModalLogic } from './postgreSQLSetupModalLogic'
export const PostgreSQLSetupModal = (props: PostgreSQLSetupModalLogicProps): JSX.Element => {
const { postgreSQLIntegration, isPostgreSQLIntegrationSubmitting } = useValues(postgreSQLSetupModalLogic(props))
const { submitPostgreSQLIntegration, setPostgreSQLIntegrationValue } = useActions(postgreSQLSetupModalLogic(props))
return (
<LemonModal
isOpen={props.isOpen}
title={
<div className="flex items-center gap-2">
<img src={IconPostgres} alt="PostgreSQL" className="w-6 h-6" />
<span>Configure PostgreSQL integration</span>
</div>
}
onClose={props.onComplete}
>
<Form logic={postgreSQLSetupModalLogic} props={props} formKey="postgreSQLIntegration">
<div className="gap-4 flex flex-col">
<LemonField
name="name"
label="Name"
info="What this connection is called wherever PostHog lists it. Optional — without one it shows the user and host."
>
<LemonInput placeholder="Customer database" />
</LemonField>
<LemonField name="host" label="Host">
<LemonInput placeholder="my-host" />
</LemonField>
<LemonField name="port" label="Port">
<LemonInput placeholder="5432" type="number" min="0" max="65535" />
</LemonField>
<LemonField name="user" label="User">
<LemonInput placeholder="postgres" />
</LemonField>
<LemonField name="password" label="Password">
<LemonInput type="password" />
</LemonField>
<LemonField
name="ssl_mode"
label="Verify server identity?"
info={
<>
Verifies that the certificate presented by the database server is signed by a trusted
certificate authority — and, optionally, that its hostname matches the host you entered.
This guards against man-in-the-middle attacks.
<br />
<br />
The connection is always encrypted regardless of this setting, because PostHog requires
TLS. These options only add verification of the server certificate.
</>
}
>
<LemonSelect
options={[
{ value: 'no', label: 'No' },
{ value: 'verify-ca', label: 'Verify certificate authority' },
{ value: 'verify-full', label: 'Verify certificate authority and server hostname' },
]}
/>
</LemonField>
{postgreSQLIntegration.ssl_mode !== 'no' && (
<>
<LemonField name="use_system_ca">
{({ value, onChange }) => (
<LemonCheckbox
bordered
checked={!!value}
onChange={onChange}
label="Use the system certificate authorities"
/>
)}
</LemonField>
{!postgreSQLIntegration.use_system_ca && (
<LemonField name="ssl_root_cert" label="Root certificate">
{() => (
<LemonFileInput
accept=".crt,.pem,.cer,.ca-bundle"
multiple={false}
onChange={(files) => {
if (files[0]) {
void files[0]
.text()
.then((text) =>
setPostgreSQLIntegrationValue('ssl_root_cert', text)
)
.catch(() => {
lemonToast.error('Failed to read the certificate file')
setPostgreSQLIntegrationValue('ssl_root_cert', null)
})
} else {
setPostgreSQLIntegrationValue('ssl_root_cert', null)
}
}}
/>
)}
</LemonField>
)}
</>
)}
<div className="flex justify-end">
<LemonButton
type="primary"
htmlType="submit"
loading={isPostgreSQLIntegrationSubmitting}
onClick={submitPostgreSQLIntegration}
>
Connect
</LemonButton>
</div>
</div>
</Form>
</LemonModal>
)
}