Re: [HACKERS] initdb and xpg_user

Поиск
Список
Период
Сортировка
От jwieck@debis.com (Jan Wieck)
Тема Re: [HACKERS] initdb and xpg_user
Дата
Msg-id m0yDAoj-000BFRC@orion.SAPserv.Hamburg.dsh.de
обсуждение исходный текст
Ответ на initdb and xpg_user  (Bruce Momjian <maillist@candle.pha.pa.us>)
Ответы Re: [HACKERS] initdb and xpg_user
Список pgsql-hackers
>
> I have a xpg_user file all my database directories.

    Hands off - this is my bug :-)

>
> Seems initdb is creating it.  Any way to prevent it from being created?
>

    Add a

    mv $PGDATA/base/template1/xpg_user $PGDATA/base/template1/pg_user

    after the UPDATE pg_class renaming xpg_user to pg_user in initdb.

    But this showed up another FEATURE! If you remove a tables file,
    the next time it is accessed it is recreated empty! I think this
    is not right, because after a system crash, a database file (I
    know, very unlikely) could reside in lost+found. It's IMHO not
    good to assume the table is empty and recreate the file silent.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #

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

Предыдущее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Re: [HACKERS] PL/pgSQL - for discussion
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] PL/pgSQL - for discussion