[Spacewalk-list] Migrated postgresql database to separate box, but rhn-search doesn't know about it

[Jan Pazdziora]

On Tue, Jul 17, 2012 at 06:00:48PM -0700, Ian Forde wrote:
> As the subject alludes, I recently migrated the postgresql database
> from the Spacewalk server to a separate box.  Checking the list
> archives, I was under the impression that all I had to do was:
> 
> Stop Spacewalk
> Dump the database
> Restore the database onto the new box
> Stop the old database
> Change /etc/rhn/rhn.conf to have 'db_host = newhost'
> Start Spacewalk

If the PostgreSQL is on different machine than localhost, you are
hitting bug 836374 which was fixed in Spacewalk nightly.

As noted in the bug, as a workaround you can try to setup a xinetd
server to redirect that port from the localhost to the remote server.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat