how to get pg_dump to include create user command

Question

I need to create a dump of all the commands below.

   test=> create user rdstest login password 'rdstest';
   CREATE ROLE
   test=> grant connect on database test to rdstest;
   GRANT
   test=> create user devadmin login password 'devtest';
   CREATE ROLE
   test=> grant connect on database test to devadmin;
   GRANT
   test=> grant rdstest to devadmin with admin option;
   GRANT ROLE
   test=> grant rdstest to devadmin;
   GRANT ROLE
   test=> create schema authorization rdstest;
   CREATE SCHEMA

when i tried to create it using pg_dump as pg_dump -U devadmin -h ****xxx.rds.amazonaws.com test > Outfile.sql

I can only see the schema related commands

CREATE SCHEMA rdstest;
ALTER SCHEMA rdstest OWNER TO rdstest;

How to get pg_dump to include all the commands:create user command,grant connect on database test to rdstest etc.

Answer 1

pg_dump can not do that, because pg_dump only dumps a single database and that information is not part of one database, but stored globally in the Postgres "cluster".

You need to use pg_dumpall for that, using the --globals-only option:

pg_dumpall --globals-only  --file=globals.sql