"Daniel Ricardo Medina" <dmedina@xxxxxxxxxxxxxxx> writes: > I have try to run this command in single user mod > > select * from pg_shadow; > delete from pg_shadow; > CREATE USER postgres WITH CREATEDB CREATEUSER PASSWORD '***' SYSID 1; > CREATE USER userradar PASSWORD '***' > but the result is the same..... What do you see if you look in pg_shadow right after doing the DELETE? What PG version is this? regards, tom lane
