Re: [GENERAL] Rounding Double Precision or Numeric

2017-06-01 Thread Louis Battuello
> On Jun 1, 2017, at 12:58 PM, Scott Marlowe wrote: > > On Thu, Jun 1, 2017 at 10:42 AM, Steve Atkins <mailto:st...@blighty.com>> wrote: >> >>> On Jun 1, 2017, at 9:26 AM, Louis Battuello >>> wrote: >>> >>> Is the round() functio

[GENERAL] Rounding Double Precision or Numeric

2017-06-01 Thread Louis Battuello
Is the round() function implemented differently for double precision than for numeric? Forgive me if this exists somewhere in the documentation, but I can't seem to find it. I've noticed with 9.6 on OSX, the .5 rounding is handled differently between the types. (I haven't tested other versions,

Re: [GENERAL] Fastest way to duplicate a quite large database

2016-04-12 Thread Louis Battuello
> On Apr 12, 2016, at 11:14 AM, John R Pierce wrote: > > On 4/12/2016 7:55 AM, John McKown wrote: >> Hum, I don't know exactly how to do it, but on Linux, you could put the >> "Customer" database in a tablespace which resides on a BTRFS filesystem. >> BTRFS can do a quick "snapshot" of the fil

Re: [GENERAL] Fastest way to duplicate a quite large database

2016-04-12 Thread Louis Battuello
> On Apr 12, 2016, at 10:51 AM, Edson Richter wrote: > > Same machine, same cluster - just different database name. > > Atenciosamente, > > Edson Carlos Ericksson Richter > > Em 12/04/2016 11:46, John R Pierce escreveu: >> On 4/12/2016 7:25 AM, Edson Richter wrote: >>> >>> I have a database

Re: [GENERAL] Standby pg_dump Conflict with Recovery

2015-10-16 Thread Louis Battuello
> On Oct 16, 2015, at 9:35 AM, Adrian Klaver wrote: > > On 10/15/2015 03:30 PM, Louis Battuello wrote: >> >>> On Oct 15, 2015, at 6:16 PM, Adrian Klaver >> <mailto:adrian.kla...@aklaver.com>> wrote: >>> > >>> >>> How

Re: [GENERAL] Standby pg_dump Conflict with Recovery

2015-10-15 Thread Louis Battuello
> On Oct 15, 2015, at 6:16 PM, Adrian Klaver wrote: > > On 10/15/2015 03:03 PM, Louis Battuello wrote: >> Hello All, >> >> I’ve got a confusing issue with dumping data from a standby PostgreSQL >> 9.4.5 database. >> >> At night, on a nearly

[GENERAL] Standby pg_dump Conflict with Recovery

2015-10-15 Thread Louis Battuello
Hell All, I’ve got a confusing issue with dumping data from a standby PostgreSQL 9.4.5 database. At night, on a nearly completely idle server, I run a pg_dump of a database that contains numerous small tables and one 3GB table. The dump consistently fails when reaching the 3GB table with this

Re: [GENERAL] "Interrupt requested" in postgresql-DAY.log

2014-05-27 Thread Louis Battuello
On May 27, 2014, at 10:52 AM, Tom Lane wrote: > Louis Battuello writes: >> I have a PostgreSQL 9.3.4 database running on CentOS 6 with PostGIS 2.1.2. >> Each night, I run a cron job to dump (pg_dump) a few schemas for development >> snapshots. Everything runs without err

[GENERAL] "Interrupt requested" in postgresql-DAY.log

2014-05-27 Thread Louis Battuello
Hi, I have a PostgreSQL 9.3.4 database running on CentOS 6 with PostGIS 2.1.2. Each night, I run a cron job to dump (pg_dump) a few schemas for development snapshots. Everything runs without error. However, it seems that the dump process consistently results in a single line in the postgresql-