vindrg@gmail.com writes:
> We've discovered, that pg_dumpall produced dump of roles from 9.4 cluster
> are not compatible with 9.4, i.e. cannot be restored due to NOBYPASSRLS
> option in SQL file.
> Its produced SQL file contains lines like this:
> ALTER ROLE <some_user> WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB
> LOGIN NOREPLICATION NOBYPASSRLS PASSWORD '<some_password>';
> Note NOBYPASSRLS that is available since 9.5. pg_dumpall reported 9.4.12
> version, and dumped cluster itself in of 9.4.
It's certainly impossible that 9.4 pg_dumpall produced that.
> It seems that it is actually dumped by 9.5 pg_dumpall available in another
> packaged, installed to test 9.5 some time ago:
Apparently you're getting burnt by something in the debian "alternatives"
mechanism. The core Postgres project isn't the place to complain about
that though, you need to complain to debian packaging people.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs