Re: pg_dumpall problem - duplicated users

Tom Lane napisał(a):

>"Bartek GRUbY" <grubby(at)epf(dot)pl> writes:
>
>
>>i have similar problem - can't make dumps of any db with the same error message (and all applications using this pg server works 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