Hi Alan, I am new to postgresql so can you please provide details on setting of pg_hba.conf.
I am trying to use RDS as external db, I am have exported db and get the connection working however getting error while creating new repositories thereafter. Appreciate all help. Thanks On Thursday, 11 May 2017 14:23:16 UTC+1, Alan Griffiths wrote: > > I did something like this: - > > 1. Install katello as normal, utilising local DB > 2. Export foreman and candlepin DBs using pgdump tools > 3. Import DBs into remote DB server (ensure pg_hba.conf is has appropriate > entries) > 4. Change DB connection strings in the following locations > /etc/foreman/database.yml and /etc/candlepin/candlepin.conf > 5. Restart Katello > > As others have noted, this will break the upgrade process - so precede > with caution > > On 10 May 2017 at 14:42, GKASERA <[email protected] <javascript:>> wrote: > >> Hi Alan, >> >> Can you help with steps to use external db instance. >> >> Thanks >> >> On Tuesday, 28 March 2017 21:19:41 UTC+1, Alan Griffiths wrote: >>> >>> How did you set it up initially? Let foreman-installer create a local DB >>> then transfer it to a remote host and update candlepin.conf ? >>> >>> On 28 March 2017 at 19:55, Neil Hanlon <[email protected]> wrote: >>> >>>> The install scripts don't do a great job of managing. I've actually had >>>> to break candlepin upgrades for it to work on my end. There is a bug >>>> report/enhancement request for this. I'll see if I can dig up the link. >>>> >>>> Ultimately, you can point the candlepin.conf to an external server, but >>>> you will have issues during upgrades. >>>> >>>> On Mar 28, 2017 14:13, <[email protected]> wrote: >>>> >>>>> Hi, >>>>> >>>>> Ideally I would like the option to configure Katello with a remote >>>>> database. This is supported in Foreman, but from what I can see candlepin >>>>> installation scripts are hard coded to assume a local db. Is there any >>>>> technical reason for this? I would have assumed it's just a JDBC >>>>> connection >>>>> and is agnostic about the location? >>>>> >>>>> Thanks, >>>>> >>>>> Alan >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Foreman users" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> To post to this group, send email to [email protected]. >>>>> Visit this group at https://groups.google.com/group/foreman-users. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> -- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "Foreman users" group. >>>> To unsubscribe from this topic, visit >>>> https://groups.google.com/d/topic/foreman-users/Krz_wMppo1g/unsubscribe >>>> . >>>> To unsubscribe from this group and all its topics, send an email to >>>> [email protected]. >>>> To post to this group, send email to [email protected]. >>>> Visit this group at https://groups.google.com/group/foreman-users. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "Foreman users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/foreman-users/Krz_wMppo1g/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at https://groups.google.com/group/foreman-users. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "Foreman users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.
