Re: How to restore roles without changing postgres password

 

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.