amazon rds - PostgreSQL 13: create empty copy of database

Question

I have a AWS RDS PostgreSQL 13 server with some databases. I have to create an empty copy of one database (empty means schema (tables, views, functions) + security (users, roles)).

Is pg_dump -s what I am looking for?

Thanks!

question from:https://stackoverflow.com/questions/65598227/postgresql-13-create-empty-copy-of-database

Answer 1

pg_dump -d db_name -s. You will also need to do pg_dumpall -g to get the global data e.g. roles. This will get all global data for the Postgres cluster, so you may have more then you need for the particular database.