Re: Real application clustering in postgres.

2020-03-06 Thread Andrew Kerber
Yup, if you need true shared storage, Oracle RAC is still the only solution out there, All the other multi-master solutions work by capturing the sql statements themselves. And properly configured it RAC is indeed part of an HA solution. Any time you have everything in a single data center, as yo

Re: Remote Connection Help

2019-11-21 Thread Andrew Kerber
change your listen_on setting to '*' and add an entry to your hosts file for your machine.something like this: 192.168.1.10 thuban.mydomain thuban Replace 192.168.1.10 with your ip address. On Thu, Nov 21, 2019 at 3:14 PM Jason L. Amerson wrote: > 1) I have attached a screenshot of the output of

Re: Remote Connection Help

2019-11-21 Thread Andrew Kerber
Is your hosts file configured correctly? Is there an entry for the IP address you are using in your hosts file? And does it point to the correct hostname and ip address? On Thu, Nov 21, 2019 at 2:07 PM Jason L. Amerson wrote: > pg_settings show localhost. > > Jason L. Amerson > > > -Origina

Re: ***SPAM*** Re: [SPAM] Remote Connection Help

2019-11-21 Thread Andrew Kerber
If you just removed the iptables rules, then every port is blocked. If you turned off iptables (service iptables stop, chkconfig iptables off,) then iptables is disabled. On Thu, Nov 21, 2019 at 10:50 AM Jason L. Amerson wrote: > I have removed the rules in the iptables and restarted it and got

Re: CASE(?) to write in a different column based on a string pattern

2019-11-13 Thread Andrew Kerber
So what you are doing is transforming the table format from vertical to horizontal. I think you will want to use a union to join the table to itself along with the case statement to produce the output you are looking for. On Wed, Nov 13, 2019 at 10:37 AM Geoff Winkless wrote: > On Wed, 13 Nov 2

Re: drop database

2019-10-17 Thread Andrew Kerber
If you are decommissioning the database, why not just rm -rf the whole system? On Thu, Oct 17, 2019 at 4:31 PM Michael Lewis wrote: > Your plan to loop over tables and truncate them seems great if you are > worried. It seems simple to verify that space is being freed as you go, and > also easy t

Re: Recomended front ends?

2019-08-08 Thread Andrew Kerber
On Thu, Aug 8, 2019 at 1:30 PM Tim Clarke wrote: > On 08/08/2019 17:55, Stuart McGraw wrote: > > > > I would be a little cautious about Django. Last time I checked, > > like many other web frameworks, it treats the database as just another > > component, one that provides data persistence for it

PGPOOL Question

2019-07-08 Thread Andrew Kerber
I know this is the wrong list for this question, but the pgpool list doesnt appear to be working currently. I am hoping someone on this list can point me to an answer. I have a fairly (I thought) straightforward pgpool setup, the backend is postrgresql database that is streaming to a hot standby

Re:

2019-07-02 Thread Andrew Kerber
Yes, CSV stands for comma separated variable length. This means that the fields in each row should be separated by commas, with a carriage return at the end of each record. You have a file using | separators, which mean it is not csv. On Tue, Jul 2, 2019 at 6:04 PM wrote: > Laurenz Albe wrote:

Re: unorthodox use of PG for a customer

2018-08-24 Thread Andrew Kerber
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