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

[sudhakar yala]

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.

[Krisztian Kovacs]

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]

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';

[Dave Bosman [Realdolmen]]

Hi @sudhakar yala

You should be able to start your application and change the baseurl fom the interface. 

No need for changing it in the database. 

Regards

Dave

[sudhakar yala]

Hi @Dave Bosman [Realdolmen]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.