What is the best way to set up our database if the Confluence server will change IP addresses?

[Heather Thomas]

We have Confluence set up on an internal server for our small company and are just starting to build up the content. We want to have someone in a different location add content so we have purchased a second license and are installing it on a PC which will go to that secondary location. We then plan to have that person export the space with their content and we will import the space on our instance of Confluence.

I have successfully installed Postgre SQL and Confluence on the new PC, and am in the process now of setting up Confluence. I'm stuck on the 'Set up your database' part. The error includes:

FATAL: no pg_hba.conf entry for host "the current IP address of the PC on our LAN"

I found an article explaining how to configure that .conf file by adding the IP address, but even if I get that working in my office it won't work when we move the PC to a new location on a new network with a new IP address.

Any ideas for how to overcome this? I don't recall having to set up that .conf file for our first installation either, so maybe I've done something else wrong before this step.

Thanks in advance for any ideas and suggestions!

Heather

[AnnWorley]

Hi Heather,

Most organizations use DNS to resolve a "friendly" host name for the computer to the IP address. The name can remain the same and the IP address can be changed in DNS:

Computers and other network devices on the Internet use an IP address to route your request to the site you're trying to reach. This is similar to dialing a phone number to connect to the person you're trying to call. Thanks to DNS, though, you don't have to keep your own address book of IP addresses. Instead, you just connect through a domain name server, also called a DNS server or name server, which manages a massive database that maps domain names to IP addresses.

If the database is on the same machine as the Confluence instance, you may use "localhost" instead of the IP address in the database portion of the setup wizard.

An example of a PostgreSQL JDBC URL is:

jdbc:postgresql://localhost:5432/confluence

where:

<jdbc:database_type>://<hostname_or_IP>:<port_number>/<database_name>

I sure hope that helps with the installation, please let me know any follow-up questions.

Thanks,

Ann

[Heather Thomas]

Thank you, Ann! I used the JDBC URL, adjusted for my info, but still had problems. I ended up having to provide a password for the database owner (in both PGADMIN 4 and on the Confluence setup page). Previously they both matched with no password, but I guess it wanted one.

Anyway, I wanted to thank you for answering!

Heather

[AnnWorley]

Thank you for following up to let us know what the issue turned out to be. :)

Please reach out with a new question if we can help with anything!