<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css" style="display:none;"></style> </head> <body dir="ltr"> <div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr"> <p>Hello,</p> <p><br> </p> <p>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. </p> <p><br> </p> <p></p> <div><i><span style="color: rgb(255, 0, 0);">pg_dump: [archiver (db)] connection to database "template1" failed: FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database "template1", SSL off</span></i></div> <div><i><span style="color: rgb(255, 0, 0);">pg_dumpall: pg_dump failed on database "template1", exiting</span></i></div> <br> <p></p> <p>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. </p> <p><br> </p> <p><i></i></p> <div><i><span style="color: rgb(255, 0, 0);">local rhnschema rhnuser md5</span></i></div> <div><i><span style="color: rgb(255, 0, 0);">host rhnschema rhnuser 127.0.0.1/8 md5</span></i></div> <div><i><span style="color: rgb(255, 0, 0);">host rhnschema rhnuser ::1/128 md5</span></i></div> <div><i><span style="color: rgb(255, 0, 0);">local rhnschema postgres ident map=usermap</span></i></div> <div><i><span style="color: rgb(255, 0, 0);">local postgres postgres ident map=usermap</span></i></div> <i><br> </i> <p></p> <p><span style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">I can add in the two tables, but I would prefer to remove them if </span><span style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">they're</span><span style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;"> not needed.</span><br> </p> <p><span style="font-family: Calibri, Arial, Helvetica, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;"><br> </span></p> <p>Thank you.</p> <p><br> </p> <p>Daryl</p> <p><br> </p> </div> </body> </html>