It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

can a postgres database instance be shared between fisheye and confluence?

John Casey Apr 17, 2014

I have a small team <25 devolopers. We have been running with the default datbase option for fisheye but recently installed confluence on postgres. Is it advisable to run both applications on the same datbase instance?

3 answers

1 accepted

1 vote
Answer accepted
Gustavo Refosco Apr 17, 2014

Hi John,

I'm sorry for my mistake, I totally missed the "instance". Please disregard my concerns (I tought you were talking about using the same database, as many other users raised this question once, sorry for the confusion with your question too).

It shouldn't be an issue to use the same instance for both databases. Indeed the performance might be affected, but I think this would depend on the configuration of your server.

0 votes
Gustavo Refosco Apr 17, 2014

Hi John,

This is not advised. Each application has it own schema, so you should use separate databases for them.

For more information about the database migration and steps to migrate for FishEye please take a look at the Migrating to an External Database document.

For Confluence, please refers to its Database Configuration document.

John Casey Apr 17, 2014

Ex-Oracle DBA here.

Just to be clear, I'm talking about database instance (linux process). One database instance can support mulitple users (fisheyeuser and Confluenceuser) with multiple different schemas. Otherwise i will need to run postgres on two different physical servers or I need to run two postgres instances on the same server (which is a painhttp://opensourcedbms.com/dbms/running-multiple-postgresql-9-2-instances-on-one-server-in-centos-6rhel-6fedora/).

Databases are suppose to be mult-user and mult-schema. Can you explane why running on the same instance is a bad idea? Performance issues or data integrity issues or some other reason?

thanks,

0 votes
John Casey Apr 17, 2014

Ex-Oracle DBA here.

Just to be clear, I'm talking about database instance (linux process). One database instance can support mulitple users (fisheyeuser and Confluenceuser) with multiple different schemas. Otherwise i will need to run postgres on two different physical servers or I need to run two postgres instances on the same server (which is a pain http://opensourcedbms.com/dbms/running-multiple-postgresql-9-2-instances-on-one-server-in-centos-6rhel-6fedora/).

Databases are suppose to be mult-user and mult-schema. Can you explane why running on the same instance is a bad idea? Performance issues or data integrity issues or some other reason?

thanks,

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

936 views 0 19
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you