Tom Lane napisał(a):
"Bartek GRUbY" <grubby@xxxxxx> 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
