database owner gone?

Поиск

Список

Период

Сортировка

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 по дате отправления: