Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
[ pg_dumpall emits this: ]
DELETE FROM pg_shadow WHERE usesysid (SELECT datdba FROM pg_database
WHERE datname = 'template0');
Now if the file pg_user.sql is used accidentally by a user that is not
postgres the result is that all users
Hi all,
doing a postgres dump I a couple of time in an
annoying problem:
# pg_dumpall -g pg_user.sql
# head -n 12 pg_user.sql
--
-- PostgreSQL database cluster dump
--
\connect template1
--
-- Users
--
DELETE FROM pg_shadow WHERE usesysid (SELECT datdba FROM pg_database
WHERE datname =
Gaetano Mendola [EMAIL PROTECTED] writes:
[ pg_dumpall emits this: ]
DELETE FROM pg_shadow WHERE usesysid (SELECT datdba FROM pg_database
WHERE datname = 'template0');
Now if the file pg_user.sql is used accidentally by a user that is not
postgres the result is that all users are deleted (