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 d
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 = 'te
I just want to let you know your sugestion worked and allowed me to dump and restore the current database.
Thanks much,
Steven
On Sat, 2003-11-08 at 11:05, Tom Lane wrote:
Steven Tower <[EMAIL PROTECTED]> writes:
> I am receiving the following error from Postgres 7.3.3 on Linux
> Bogus att
Quoth [EMAIL PROTECTED] (Stephen Frost):
> * Christopher Browne ([EMAIL PROTECTED]) wrote:
>> On one of our test servers, I set "fsync=false", and a test load's
>> load time dropped from about 90 minutes to 3 minutes. (It was
>> REALLY update heavy, with huge numbers of tiny transactions.)
>>
>>