From: | GRUbY <grubby(at)epf(dot)pl> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_dumpall problem - duplicated users |
Date: | 2005-09-01 17:17:27 |
Message-ID: | 431737A7.8030602@epf.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-09-01 18:26:16 | Re: pg_dumpall problem - duplicated users |
Previous Message | Tom Lane | 2005-09-01 15:04:44 | Re: pg_dumpall problem - duplicated users |