Help: Dumb newbie locked himself out!

Поиск
Список
Период
Сортировка
От Balazs Wellisch
Тема Help: Dumb newbie locked himself out!
Дата
Msg-id JPEOKLNNLDPGJFFAAFLNIEODCPAA.balazs@bwellisch.com
обсуждение исходный текст
Ответ на Re: Newbie Stupid Question  (AarniRuuhimäki / Megative Tmi / KYMI.com<aarni.ruuhimaki@kymi.com>)
Ответы Re: Help: Dumb newbie locked himself out!  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hello all,

sorry for the dumb question but I managed to mess up the privileges in my
database and now I'm unable to create or modify any users. I can still
connect to my database using the postgres user but I don't have the
permissions to do anything. How can I reset the permissions so that the
postgres user will have full access again?

This is a RedHat Linux 7.2 machine running PostgreSQL 7.1.3, standard RPM
installation of everything.

Thank you for you help in advance,

Balazs



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

Предыдущее
От: "D. Duccini"
Дата:
Сообщение: Re: mirroring databases
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Help: Dumb newbie locked himself out!