Home > mailing lists

Re: How to restore roles without changing postgres password - Mailing list pgsql-general

From	Andrus
Subject	Re: How to restore roles without changing postgres password
Date	February 12, 2020 13:06:56
Msg-id	6316D0244B55410388A5E0FC387B006E@dell2 Whole thread Raw
In response to	Re: How to restore roles without changing postgres password (Justin <zzzzz.graf@gmail.com>)
List	pgsql-general

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.

From: Mladen Marinović
Date: 12 February 2020, 12:22:14
Subject: pg_basebackup connection closed unexpectedly...

From: farjad.farid
Date: 12 February 2020, 14:52:30
Subject: RE: Function not imported in Entity Framework