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

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2005-01-29 22:23:06
Subject: Re: distinct vs group by
Previous:From: Tom LaneDate: 2005-01-29 22:14:07
Subject: Re: distinct vs group by

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group