Re: pg_dumpall problem - duplicated users

Tom Lane napisał(a):

>"Bartek GRUbY" <grubby@epf.pl> writes:
>
>
>>i have similar problem - can't make dumps of any db with the same error message (and all applications using this pg
serverworks fine) . But in my case, i think, only user 'postgres' is duplicated: 
>>
>>
>
>
>
>>template1=> select * from pg_catalog.pg_shadow where usename = 'postgres';
>> usename  | usesysid | usecreatedb | usesuper | usecatupd |               passwd                | valuntil |
useconfig

>>----------+----------+-------------+----------+-----------+-------------------------------------+----------+-----------
>> postgres |        1 | t           | t        | t         |                                     |          |
>> postgres |        1 | t           | t        | t         | md5c084502ed11efa9d3d96d29717a5e555 |          |
>>(2 rows)
>>
>>
>
>What PG version are you using exactly?  Could we see the system columns
>for those rows, ie,
>
>    select ctid,xmin,xmax,cmin,xmax,* from pg_shadow where usename = 'postgres';
>
>            regards, tom lane
>
>
I'm using exactly  PostgreSQL 7.3.9 on i686-pc-linux-gnu, compiled by
GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3) :]

If it helps:

postgres=> select ctid,xmin,xmax,cmin,xmax,* from pg_shadow where
usename = 'postgres';
  ctid  |    xmin    | xmax  | cmin  | xmax  | usename  | usesysid |
usecreatedb | usesuper | usecatupd |               passwd
| valuntil | useconfig

--------+------------+-------+-------+-------+----------+----------+-------------+----------+-----------+-------------------------------------+----------+-----------
  (0,1) |          1 | 50469 | 50469 | 50469 | postgres |        1 |
t           | t        | t         |
|          |
 (1,25) | 2559800612 |     0 |     0 |     0 | postgres |        1 |
t           | t        | t         | md5c084502ed11efa9d3d96d29717a5e555
|          |
(2 rows)


If U have any ideas or more questions please write. Like I said, my
deadline is near :[ Now i'm thinking about writing a script to backup
all data and schemas from all dbs by myself and reinstallin PG... but it
is a lot of work and i cant check if i did everything right for sure :(

Greetings,
Bartek