Horton

Re: How to restore roles without changing postgres password

Andrus <kobruleht2@hot.ee>

View thread View on postgr.es
From: "Andrus" <kobruleht2@hot.ee>
To: "Justin" <zzzzz.graf@gmail.com>, "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "pgsql-general" <pgsql-general@postgresql.org>
Date: 2020-02-12T10:06:56Z
Lists: pgsql-general, pgsql-docs 
Hi!

>Not a bad idea,  would want to extend this to all the roles on the server not just postgres  

>I've  edited the global dump many times  removing/editing table spaces, comment old users, etc..  

Maybe it is easier to create plpgsql procedure which returns desired script as text.
Or it retrieves globals from other cluster using dblink and applies changes to new cluster.

This can be called instead of pq_dumpall and can edited for custom needs.
Editing plpgsql script is easier for postgres users than creating sed script to delete commands from sql file.

Andrus.

Commits

  1. Doc: fix old oversights in GRANT/REVOKE documentation.