Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How many Maximum Number of database can be created in single instance of PostgreSQL 9.x?

share|improve this question

closed as unclear what you're asking by Craig Ringer, Phil, Paul White, Max Vernon, RolandoMySQLDBA Jul 2 at 20:01

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

    
What exactly do you mean by "instance"? A PostgreSQL server instance with its own postmaster, created by initdb and launched by pg_ctl? A database within a single server? Something else? This makes very little sense. –  Craig Ringer Jul 2 at 1:56
    
Please try to explain what you are trying to achieve. What's the problem you're trying to solve by making lots of "instances"? –  Craig Ringer Jul 2 at 1:57
    
Closevoted, unclear what you're asking. –  Craig Ringer Jul 2 at 2:40
    
I was new to PostgreSQL and my colleague has raised a question regarding this.I have given an answer like it depends up on the size of Disk and the memory allocated to the PostgreSQL database.But he was not satisfied with my answer. –  user38867 Jul 2 at 4:10
    
Well, please try to explain it in a bit more detail. Edit the question and add clarifications - see my first and second comment for guidance. Once you explain what you actually want to know, maybe we can help you. Comment here when done. –  Craig Ringer Jul 2 at 4:21