Re: how to create multiple databases running in different dirs

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: how to create multiple databases running in different dirs
Date: 2014-07-01 00:04:44
Message-ID: 53B1FB1C.2020303@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2014-07-01 00:06:58 Re: lock contention, need profiling idea
Previous Message frank ernest 2014-06-30 23:58:06 how to create multiple databases running in different dirs