Re: how to create multiple databases running in different dirs

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 program got one
> database but I'm uncertain how to go about this. As the program might
> be run several different times and each time it should only get the
> data base from it's predisesor I can't use the pid as a unique data
> base name. I thought that I might start multiple pgsql instances but
> somehow that seems wrong. Any ideas?

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.

--
john r pierce 37N 122W
somewhere on the middle of the left coast