LogicalBackupCliInstructions.utils.ts18 lines · main

1	export const DB_PASSWORD_PLACEHOLDER = '[YOUR-PASSWORD]'
2
3	export function buildDirectPostgresConnectionUri(settings: {
4	db_user: string
5	db_host: string
6	db_port: number
7	db_name: string
8	}): string {
9	return `postgresql://${settings.db_user}:${DB_PASSWORD_PLACEHOLDER}@${settings.db_host}:${settings.db_port}/${settings.db_name}`
10	}
11
12	export function buildLogicalBackupShellScript(connectionUri: string): string {
13	return [
14	`npx briven db dump --db-url '${connectionUri}' -f roles.sql --role-only`,
15	`npx briven db dump --db-url '${connectionUri}' -f schema.sql`,
16	`npx briven db dump --db-url '${connectionUri}' -f data.sql --use-copy --data-only -x "storage.buckets_vectors" -x "storage.vector_indexes"`,
17	].join('\n')
18	}