Re: Postgres database access problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Inpreet Singh <Singh(dot)Inpreet(at)netsity(dot)com>
Cc: operationsengineer1(at)yahoo(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: Postgres database access problem
Date: 2005-01-29 22:16:48
Message-ID: 25819.1107037008@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Inpreet Singh <Singh(dot)Inpreet(at)netsity(dot)com> writes:
> I saw my database and got that it has no owner so probably I deleted my user
> of database accidentally. Now is there a way to create owner of already
> existing database in postgres.

Recreate the user with the same sysid as before.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2005-01-29 22:23:06 Re: distinct vs group by
Previous Message Tom Lane 2005-01-29 22:14:07 Re: distinct vs group by