Re: Postgres database access problem - Mailing list pgsql-novice

From Tom Lane
Subject Re: Postgres database access problem
Date
Msg-id 25819.1107037008@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres database access problem  (Inpreet Singh <Singh.Inpreet@netsity.com>)
List pgsql-novice
Inpreet Singh <Singh.Inpreet@netsity.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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: distinct vs group by
Next
From:
Date:
Subject: pgAdminIII and User Grants