Thank you Paul. I appreciate the information. I'll leave them alone.
Daryl ________________________________ From: [email protected] <[email protected]> on behalf of Paul Robert Marino <[email protected]> Sent: Wednesday, November 30, 2016 9:32 PM To: Daryl Rose Subject: Re: [Spacewalk-list] Template tables in database 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 PostgreSQL: Documentation: 9.4: Template Databases<https://www.postgresql.org/docs/9.4/static/manage-ag-templatedbs.html> www.postgresql.org 21.3. Template Databases. CREATE DATABASE actually works by copying an existing database. By default, it copies the standard system database named template1. 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, <[email protected]<mailto:[email protected]>> 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: [email protected]<mailto:[email protected]> Reply To: [email protected]<mailto:[email protected]> 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
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
