Thanks for that. I shall use it when I do the repeat migration.
Cheers,
Stephen
On 14/10/14 10:21, Adrian Klaver wrote:
On 10/13/2014 04:28 PM, Stephen Davies wrote:
No. Just pg_dump and pg_restore/postgis_restore.pl.
Roles(users) are global to a cluster so they will not be picked up by pg_dump.
You have the options of:
1) Using pg_dumpall to dump the entire cluster into a text file
http://www.postgresql.org/docs/9.3/interactive/app-pg-dumpall.html
$ pg_dumpall > db.out
2) Or do pg_dump on the individual databases and pg_dumpall -g to get just the
global objects, which is what Vick Khera was getting at.
-g
--globals-only
Dump only global objects (roles and tablespaces), no databases.
On 13/10/14 22:24, Vick Khera wrote:
On Mon, Oct 13, 2014 at 12:11 AM, Stephen Davies <sdavies@xxxxxxxxxx>
wrote:
I have fixed this by manually granting access where necessary but wonder
whether the original issue is a bug or something that I have missed
in the
migration.
pg_dump emits the necessary GRANTs for the tables.
Did you use pg_dumpall --globals-only to copy over your users and
their settings?
--
=============================================================================
Stephen Davies Consulting P/L Phone: 08-8177 1595
Adelaide, South Australia. Mobile:040 304 0583
Records & Collections Management.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
