| From: | "frank ernest" <doark(at)mail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how to create multiple databases running in different dirs |
| Date: | 2014-07-02 23:24:34 |
| Message-ID: | trinity-ca10a953-5901-4a49-a7e4-afe2d8a18ba3-1404343474277@3capp-mailcom-lxa06 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>
<div>> how would an instance of your program know what to connect to, or which<br/>
> previous instance its 'predecessor' was ?</div>
<div>> normally, you have ONE database for a given set of applications, and all<br/>
> the applications share the same database tables and such.</div>
<div><br/>
That's the problem, is there some way to tell pgsql "Go to dir X, open your data base Y and prepare for connections at adress Z and port P"? And could pgsql accept multiple connections on the same address and port? I was thinking of using my pID but that would change and if I used a user created string then if I started only on a single instace of pgsql and pointed it to it's databases the user might get the strings duplicated and that would be no good. I also thought of naming each database with a name generated by using the uuid library but I'm not sure which would be best.</div>
<div> </div>
<div>If I choose to have multiple servers running on the same machine how would my program start them?</div>
<div> </div>
<div>> Is each runtime instance of your application to have a new, empty<br/>
> database? No data from any other run of the application?</div>
<div> </div>
<div>No, the dynamically generated content is to be dropped (drop table dynamic_content;) but the rest is to be preserved. The idea is to create a database of a file system but the files contain no data, I only want their metadata and I will add a few additional metadta values to each file.</div>
<div> </div>
<div>Thanks, David</div>
<div> </div>
</div></div></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John W Higgins | 2014-07-02 23:56:21 | Re: how to create multiple databases running in different dirs |
| Previous Message | Kevin Grittner | 2014-07-02 21:45:27 | Re: Two-way encryption |