database owner gone?

Поиск
Список
Период
Сортировка
От Evert Daman
Тема database owner gone?
Дата
Msg-id 002801c654b4$816eb340$91512b0a@B100
обсуждение исходный текст
Ответы Re: database owner gone?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
we have a problem here at a large database using postgresql.
i used it with no problems yesterday and suddenly today all
the databases were no longer visible in phppgadmin.
 
using pgsql -U admin <database> does give me access.
so i thought something was wrong with the usersettings. checking
these settings with \d reveales that the table no longer had
an owner.
 
select * from pg_user gives me only 1 user (postgres). pg_shadow
also gives 1 user. so i tried recreating the admin user with
createuser admin (as postgres user) but that failed saying admin
allready exists! so where is it now? and how do i get access
back to my database using pg_dump and phppgadmin?
 
thanx for any help,
Evert
 
 

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Rajesh Kumar Mallah"
Дата:
Сообщение: Re: Storage and Backup
Следующее
От: "deepak pal"
Дата:
Сообщение: how to use pg_dump in windows xp