Re: unorthodox use of PG for a customer

On 8/27/2018 8:20 AM, John McKown wrote: On Fri, Aug 24, 2018 at 1:19 PM David Gauthier > wrote: I can't think of anything better.  Does anyone have any ideas? Yes, but the civil authorities would prosecute you if they found the body. And that's why we ha

Re: unorthodox use of PG for a customer

Hi Dave, lots of nice inputs but let's try to summarize your user's needs. On Fri, Aug 24, 2018 at 3:18 PM, David Gauthier wrote: > [...] > > He's writing a script/program that runs on a workstation and needs to > write data to a DB. This process also sends work to a batch system on a > server

Re: unorthodox use of PG for a customer

On Fri, Aug 24, 2018 at 1:19 PM David Gauthier wrote: > Hi Everyone: > > I'm going to throw this internal customer request out for ideas, even > though I think it's a bit crazy. I'm on the brink of telling him it's > impractical and/or inadvisable. But maybe someone has a solution. > Reading b

Re: unorthodox use of PG for a customer

Hmmm I usually don't participate in forums and accidentally sent my reply to David Gauthier directly. This issue sounds interesting I'll give it another try and send the reply to the group. >From my simple, engineering hat perspective I feel this question is difficult to answer without hard num

Re: unorthodox use of PG for a customer

David Gauthier writes: > Hi Everyone: > > I'm going to throw this internal customer request out for ideas, even > though I think it's a bit crazy. I'm on the brink of telling him it's > impractical and/or inadvisable. But maybe someone has a solution. > > He's writing a script/program that ru

Re: unorthodox use of PG for a customer

On 08/24/2018 02:35 PM, Andrew Kerber wrote: > Unless I am missing something, it sounds like you might be able to do this > with an nfs export shared to each workstation. That's no different from polling the central database though, you're just using nfs server and files instead of a db server and

Re: unorthodox use of PG for a customer

Unless I am missing something, it sounds like you might be able to do this with an nfs export shared to each workstation. But I am not sure if I understood what you were describing either. On Fri, Aug 24, 2018 at 2:22 PM Edson Carlos Ericksson Richter < rich...@simkorp.com.br> wrote: > Em 24/08/2

Re: unorthodox use of PG for a customer

Em 24/08/2018 16:07, David Gauthier escreveu: I tried to convince him of the wisdom of one central DB.  I'll try again. >>So are the 58 database(stores) on the workstation going to be working with data independent to each or is the data shared/synced between instances? No, 58 workstations, each

Re: unorthodox use of PG for a customer

On 08/24/2018 02:07 PM, David Gauthier wrote: > > ... He likes the idea of a > separate DB per workarea. He just doesn't gt it. Well there are advantages to that. > But for some reason, he doesn't like > the client/server DB model which would work so nicely here. I'm just > trying to make sur

Re: unorthodox use of PG for a customer

On 08/24/2018 12:07 PM, David Gauthier wrote: I tried to convince him of the wisdom of one central DB.  I'll try again. >>So are the 58 database(stores) on the workstation going to be working with data independent to each or is the data shared/synced between instances? No, 58 workstations, eac

Re: unorthodox use of PG for a customer

I tried to convince him of the wisdom of one central DB. I'll try again. >>So are the 58 database(stores) on the workstation going to be working with data independent to each or is the data shared/synced between instances? No, 58 workstations, each with its own DB. There's a concept of a "worka

Re: unorthodox use of PG for a customer

Em 24/08/2018 15:18, David Gauthier escreveu: Hi Everyone: I'm going to throw this internal customer request out for ideas, even though I think it's a bit crazy.  I'm on the brink of telling him it's impractical and/or inadvisable.  But maybe someone has a solution. He's writing a script/pro

Re: unorthodox use of PG for a customer

On 08/24/2018 11:18 AM, David Gauthier wrote: Hi Everyone: I'm going to throw this internal customer request out for ideas, even though I think it's a bit crazy.  I'm on the brink of telling him it's impractical and/or inadvisable.  But maybe someone has a solution. He's writing a script/pro

Re: unorthodox use of PG for a customer

> he doesn't want the overhead, dependencies and worries of anything like an external DB with a DBA, etc... . He also wants this to be fast. So they're trading consistency concerns for ... not having a central db? Even if your shop requires a DBA for any DB, it sounds like a really bad deal. Jim

unorthodox use of PG for a customer

Hi Everyone: I'm going to throw this internal customer request out for ideas, even though I think it's a bit crazy. I'm on the brink of telling him it's impractical and/or inadvisable. But maybe someone has a solution. He's writing a script/program that runs on a workstation and needs to write