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]> 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/to >>> pic/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]. > 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 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.
