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

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

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.

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.

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,

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

634 views 21 11
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you