| #!/usr/bin/env -S bash -e |
| |
| # Copyright 2026 The Go Authors. All rights reserved. |
| # Use of this source code is governed by a BSD-style |
| # license that can be found in the LICENSE file. |
| |
| # This script dumps the schema of the local database |
| # into a file. |
| # |
| # You must have a local DB running at localhost:5432. |
| # That should be true if you've been testing with a DB. |
| # |
| # You must have pg_dump installed. |
| # If your installed version doesn't match your DB version, |
| # it may not work; set PG_DUMP to an alternate version. |
| # For example, pg_dump from v18 postgres will not work |
| # with a v14 database, but the v16 pg_dump will. |
| # |
| # GO_DISCOVERY_DATABASE_PASSWORD must be set to the |
| # password of the DB user "postgres". |
| |
| outfile=db-schema.sql |
| |
| pgdump=$PG_DUMP |
| if [[ -z $pgdump ]]; then |
| pgdump=pg_dump |
| fi |
| |
| db="dbname=discovery-db host=127.0.0.1 sslmode=disable port=5432 user=postgres password=$GO_DISCOVERY_DATABASE_PASSWORD" |
| |
| echo '-- Copyright 2026 The Go Authors. All rights reserved. |
| -- Use of this source code is governed by a BSD-style |
| -- license that can be found in the LICENSE file. |
| ' > $outfile |
| |
| $pgdump -s "$db" >> $outfile |
