Re: all postgres users do "not exist"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: all postgres users do "not exist"
Дата
Msg-id 12936.1163658755@sss.pgh.pa.us
обсуждение исходный текст
Ответ на all postgres users do "not exist"  (Will Cameron <novawcameron@yahoo.com>)
Ответы Re: all postgres users do "not exist"  (Will Cameron <novawcameron@yahoo.com>)
Список pgsql-admin
Will Cameron <novawcameron@yahoo.com> writes:
>     We are using (PostgreSQL) 8.0.1 for Solaris.  Apparently our
> postgres users were wiped out somehow, for I cannot even log in as
> superuser "postgres".  Our pg_hba.conf settings are as loose as possible
> ("trust").  This problem started mid session after we ran a .sql script
> to upgrade a DSpace digital library database within the postgres system.

Better take a closer look at what that script did.

Meanwhile, you can probably get out of this by starting a standalone
postgres session and using it to recreate your SQL users.

            regards, tom lane

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

Предыдущее
От: "Mark Steben"
Дата:
Сообщение: Question on partitioning
Следующее
От: Kis János Tamás
Дата:
Сообщение: Re: Postgres at startup