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

1 vote
Accepted answer

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
Community showcase
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

98 views 3 4
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