Re: [HACKERS] initdb and xpg_user - Mailing list pgsql-hackers

From jwieck@debis.com (Jan Wieck)
Subject Re: [HACKERS] initdb and xpg_user
Date
Msg-id m0yDAoj-000BFRC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to initdb and xpg_user  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] initdb and xpg_user  (Bruce Momjian <maillist@candle.pha.pa.us>)
List 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 by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] PL/pgSQL - for discussion
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] PL/pgSQL - for discussion