Re: [GENERAL] import .sql file into PostgreSQL database

2020-05-09 Thread Michael Paquier
On Thu, May 07, 2020 at 11:46:02PM -0400, Gaurav wrote: > Just going thru old emails and came across this one. Thought to text you. > How have you been? What are you up to? How can I rejoin this group? Fine thanks. In order to subscribe to one or more mailing lists, please feel free to look here:

Re: pg_basebackup cannot compress to STDOUNT

2020-05-09 Thread Support
On 5/8/2020 11:51 PM, Paul Förster wrote: Hi Admin, On 08. May, 2020, at 21:31, Support wrote: 2) Command run? ssh postgres@nodeXXX "pg_basebackup -h /run/postgresql -Ft -D- | pigz -c -p2 " | pigz -cd -p2 | tar -xf- -C /usr/local/pgsql/data I don't get it, sorry. Do I understand you correct

Re: Best way to use trigger to email a report ?

2020-05-09 Thread Tim Clarke
Personally I'd have your trigger put the necessary data into a queue to run the report then have some other process take that data off asynchronously. Either pop it in a table and do it yourself or use a robust distributed broker protocol platform like RabbitMQ or Apache ActiveMQ or Kafka. Tim

Re: Best way to use trigger to email a report ?

2020-05-09 Thread AC Gomez
We're posting a flag to a table. The table has an "event" field. When we post the value "email" into that field, a sweeper app that runs on a schedule looks for this flag, then takes the value in the message field and sends that out as an email. On Sat, May 9, 2020, 12:31 PM Tim Clarke wrote: