Re: how to create multiple databases running in different dirs - Mailing list pgsql-general

From Rob Sargent
Subject Re: how to create multiple databases running in different dirs
Date
Msg-id 53B1FB1C.2020303@gmail.com
Whole thread Raw
In response to how to create multiple databases running in different dirs  ("frank ernest" <doark@mail.com>)
List pgsql-general
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 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?
 
Thanks, David
 
Is each runtime instance of your application to have a new, empty database?  No data from any other run of the application?

pgsql-general by date:

Previous
From: "frank ernest"
Date:
Subject: how to create multiple databases running in different dirs
Next
From: Michael Paquier
Date:
Subject: Re: lock contention, need profiling idea