[pg92@redhatB tf]$ view pg92_globle.sql
  
--
-- PostgreSQL database cluster dump
--
  
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
  
 Roles

  
CREATE ROLE francs;
ALTER ROLE francs WITH NOSUPERUSER NOINHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION PASSWORD 'md53dd797adaf7158f9625ccda805c4d881';
CREATE ROLE londiste_reader;
ALTER ROLE londiste_reader WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN NOREPLICATION;
....
  

 Tablespaces

  
CREATE TABLESPACE tbs_skytf OWNER postgres LOCATION '/database/pg92/pgdata/pg_tbs/tbs_skytf';
REVOKE ALL ON TABLESPACE tbs_skytf FROM PUBLIC;
REVOKE ALL ON TABLESPACE tbs_skytf FROM postgres;
GRANT ALL ON TABLESPACE tbs_skytf TO postgres;
GRANT ALL ON TABLESPACE tbs_skytf TO skytf;
...
CREATE TABLESPACE tbs_francs OWNER postgres LOCATION '/database/pg92/pgdata/pg_tbs/tbs_francs';
REVOKE ALL ON TABLESPACE tbs_francs FROM PUBLIC;
REVOKE ALL ON TABLESPACE tbs_francs FROM postgres;
GRANT ALL ON TABLESPACE tbs_francs TO postgres;
GRANT ALL ON TABLESPACE tbs_francs TO francs;