Re: [GENERAL] how to create multiple databases running in different dirs

2014-07-02 Thread John R Pierce
> how would an instance of your program know what to connect to, or which > previous instance its 'predecessor' was ? > normally, you have ONE database for a given set of applications, and all > the applications share the same database tables and such. That's the problem, is there some way to t

Re: [GENERAL] how to create multiple databases running in different dirs

2014-07-02 Thread John W Higgins
Afternoon Frank, I believe what you might wish to look at is a single database with a set of schemas[1] which would separate your data in a logical way. You could have a single connection url and then each individual connection could create a schema (or reuse if you wish), set the search path (fir

Re: [GENERAL] how to create multiple databases running in different dirs

2014-07-02 Thread frank ernest
> how would an instance of your program know what to connect to, or which > previous instance its 'predecessor' was ? > normally, you have ONE database for a given set of applications, and all > the applications share the same database tables and such. That's the problem, is there some way to t

Re: [GENERAL] how to create multiple databases running in different dirs

2014-07-01 Thread John R Pierce
On 7/1/2014 7:19 AM, Rémi Cura wrote: If it is so your desire, you could also have multiple server on the same machine (althought on different port). This way each server would have its own repository. which still doesn't answer the question, how would an instance of his program know which

Re: [GENERAL] how to create multiple databases running in different dirs

2014-07-01 Thread Rémi Cura
Hey, postgres already takes care of multiple client writting/reading, so you don't really need to be afraid of concurrency (for most of the stuff) If it is so your desire, you could also have multiple server on the same machine (althought on different port). This way each server would have its own

Re: [GENERAL] how to create multiple databases running in different dirs

2014-06-30 Thread John R Pierce
On 6/30/2014 4:58 PM, frank ernest wrote: Hi, I'm new to postgresql and sql in general. I desired to write a program in C that used an sql data base for IPC and because multiple copies of my program might run on the same machine I wanted a way to ensure that only one copy of each multithreaded

Re: [GENERAL] how to create multiple databases running in different dirs

2014-06-30 Thread Rob Sargent
On 06/30/2014 05:58 PM, frank ernest wrote: Hi, I'm new to postgresql and sql in general. I desired to write a program in C that used an sql data base for IPC and because multiple copies of my program might run on the same machine I wanted a way to ensure that only one copy of each multithreade