Need a postgres query to manually change base URL and banner of Confluence using postgres database

Question

Hi Team,

I am trying to automate the deprod confluence after refreshing the non prod environments, as after refresh application comes up pointing to prod url, application is using postgres DB.

Need a postgres query to manually change base url before application comes up.

sudhakar yala · Answer

Hmm dint get that, if I can get some query to check what baseurl is pointing to and a query to change that query in postgres database.

Like we have below query for jira.

select propertyvalue from propertyentry PE
join propertystring PS on PE.id=PS.id
where PE.property_key = 'jira.baseurl';

Krisztian Kovacs_rapuo3 · Answer

Hi @sudhakar yala,

I wonder if using a reverse proxy would help you along the process, though that is mainly used with Jira data center, however pointing it to one instance or the other you could alternate between the two (first one being prod then the second one).

Would that help?

sudhakar yala · Answer

Hi @Dave Bosman _Inetum_Thanks for your quick reply, Yes we can do that and we are doing that currently but however we need that to happen even before application comes up as we do not want to take chances it being pointed to prod url.