Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

help me plz with 2 postgres users


  • From: "spol(at)mail(dot)ru" <spol(at)mail(dot)ru>
  • To: pgsql-bugs(at)postgresql(dot)org
  • Subject: help me plz with 2 postgres users
  • Date: Tue, 26 Feb 2008 14:25:19 +0300
  • Message-id: <47C3F71F(dot)5050501(at)mail(dot)ru>

Hello?
help me plz? i don't khow what to do...

How can I delete first postgres user.

template1=# select usename,passwd,valuntil,ctid,xmin,xmax,cmin,cmax from pg_shadow where usesysid=1; usename | passwd | valuntil | ctid | xmin | xmax | cmin | cmax ----------+-------------------------------------+----------+-------+------+----------+----------+------ postgres | | | (0,1) | 1 | 16754522 | 16754522 | 0 postgres | md65476547442532.. | infinity | (0,2) | 2 | 0 | 0 | 0
(2 rows)

thx for your help.
Oleg



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group