[Spacewalk-list] Template tables in database

[Paul Robert Marino]

actually slight fix on a typo in the previous email they are used in the
creation of a new database not a table, also if you want to understand why
they are there read this short page
https://www.postgresql.org/docs/9.4/static/manage-ag-templatedbs.html
incidentally you can use that "create database NAME template DATABASENAME"
syntax to duplicate any database in PostgreSQL,, but if you don't specify a
template in the create database command the planner adds "TEMPLATE
template1" to it without your knowledge. If template1 does not exist then
the command will fail and depending on the version the database server may
crash.

On Wed, Nov 30, 2016 at 7:49 PM, <prmarino1 at gmail.com> wrote:

> NO YOU CAN NOT!!!!
> Those are part of how PostgerSQL works under the hood whenever a new table
> is created.
> You may not be aware of it but any time you create a table in PostgreSQL
> it uses one of those 2 templates to set up a lot of things you need under
> the hood like the ability for the pgsql user to manage them‎.
> Do not ever remove those templates!
>
> *From: *Daryl Rose
> *Sent: *Wednesday, November 30, 2016 12:24
> *To: *spacewalk-list at redhat.com
> *Reply To: *spacewalk-list at redhat.com
> *Subject: *[Spacewalk-list] Template tables in database
>
> Hello,
>
>
> During the virtual to physical migration, I discovered that there are two
> template tables in the postgres database.  Can I remove these, or are they
> needed for the WUI?  The reason why I ask is because I get errors when
> backing them up.
>
>
> *pg_dump: [archiver (db)] connection to database "template1" failed:
> FATAL:  no pg_hba.conf entry for host "[local]", user "postgres", database
> "template1", SSL off*
> *pg_dumpall: pg_dump failed on database "template1", exiting*
>
> Review some documentation, I see that I can add an entry to the
> pg_hba.conf file that would allow them to be backed up.  However, when I
> look at the pg_hba.conf file, I see that postgres and rhnschema are
> defined, but the two template tables are not.
>
>
> *local rhnschema rhnuser md5*
> *host  rhnschema rhnuser 127.0.0.1/8 <http://127.0.0.1/8> md5*
> *host  rhnschema rhnuser ::1/128 md5*
> *local rhnschema postgres ident map=usermap*
> *local postgres postgres ident map=usermap*
>
> I can add in the two tables, but I would prefer to remove them if they're not
> needed.
>
>
> Thank you.
>
>
> Daryl
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20161130/09fb8fab/attachment.htm>