Re: [GENERAL] Changelog version from 8.1.2 to 9.3.6

Hi Yogesh,     here https://www.postgresql.org/docs/9.3/static/release.html you can find all release notes, including changelogs for all versions. HTH, Moreno. Il 10/06/2016 13:17, Yogesh Sharma ha scritto:

[GENERAL] PostgreSQL crash with PANIC message

Hello, a customer of ours has an old PC (CoreDuo, 4 GB RAM, Windows XP) that's running PostgreSQL. Yesterday PostgreSQL started crashing suddenly with the following log 2016-03-23 10:40:42 CET LOG: CreateProcess call failed: unrecognized winsock error 10004 (error code 1450) 2016-03-23

Re: [GENERAL] PostgreSQL crash with PANIC message

Il 24/03/2016 05:12, Michael Paquier ha scritto: On Thu, Mar 24, 2016 at 5:57 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: On 03/23/2016 12:02 PM, Moreno Andreo wrote: Il 23/03/2016 19:57, Adrian Klaver ha scritto: Might help to look in: Control Panel --> Administrat

Re: [SPAM] Re: [GENERAL] PostgreSQL crash with PANIC message

Il 23/03/2016 21:57, Adrian Klaver ha scritto: On 03/23/2016 12:02 PM, Moreno Andreo wrote: Il 23/03/2016 19:57, Adrian Klaver ha scritto: Might help to look in: Control Panel --> Administrative Tools --> Event Viewer No help there. Nothing strange or pointing to critical resource

Re: [GENERAL] PostgreSQL crash with PANIC message

Il 23/03/2016 19:57, Adrian Klaver ha scritto: Might help to look in: Control Panel --> Administrative Tools --> Event Viewer No help there. Nothing strange or pointing to critical resource usage. Thanks in advance, Moreno. -- Sent via pgsql-general mailing list

Re: [GENERAL] Multimaster

Il 01/04/2016 17:22, Joshua D. Drake ha scritto: On 04/01/2016 04:50 AM, Konstantin Knizhnik wrote: There are also some minor technical issues which lead us to making few changes in pglogical code but we tried to do our best to keep original versions unchanged, so we can switch to public

Re: [GENERAL] Fetching last n records from Posgresql

Il 30/03/2016 11:19, Deole, Pushkar (Pushkar) ha scritto: select * from t order by record_date desc limit 5;   this will return the recent 5 records.. what I want is the oldest 5 records (in last 30

Re: [GENERAL] Fetching last n records from Posgresql

] On Behalf Of Moreno Andreo Sent: Wednesday, March 30, 2016 3:03 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Fetching last n records from Posgresql   Il 30/03/2016

Re: [GENERAL] Multimaster

Il 14/04/2016 07:45, Craig Ringer ha scritto: On 2 April 2016 at 02:15, Moreno Andreo <moreno.and...@evolu-s.it> wrote:   Actually we have to improve what our replicator is

Re: [GENERAL] PG 9.1 on windows setup problem

Il 20/04/2016 20:58, Adrian Klaver ha scritto: On 04/20/2016 07:28 AM, Moreno Andreo wrote: Il 20/04/2016 15:34, Adrian Klaver ha scritto: On 04/20/2016 01:57 AM, Moreno Andreo wrote: Hello, I have a strange problem. I'm installing PostgreSQL 9.1 on Windows XP Home SP3 (don't ask

[GENERAL] PostgreSQL proxying

Hello folks! :-) hope I'm not OT here Need an advise here. I have a PostgreSQL cluster that should be accessed in two ways: - By a Web Services system (always same host in my vLAN, and that is simple) - By a replicator (any host, with unpredictable IP) In my previous configuration I had a

[GENERAL] PostgreSQL and Windows 10 exception 0xC0000018

Hi all,     a strange error is happening to some of our customers. They all have a Windows 10 installation on their machines with our application and, of course, PostgreSQL 9.1 installed (migration to 9.5 upcoming in late summer/fall, but not applicable by now)

Re: [SPAM] [GENERAL] COPY command & binary format

Il 10/05/2016 13:38, Nicolas Paris ha scritto: 2016-05-10 13:04 GMT+02:00 Moreno Andreo <moreno.and...@evolu-s.it>: Il 10/05/2016 12:56, Nicolas Paris ha s

Re: [SPAM] [GENERAL] COPY command & binary format

Il 10/05/2016 12:56, Nicolas Paris ha scritto: Hello, What is the way to build a binary format (instead of a csv) ? Is there specification for this file ?

[GENERAL] PG 9.1 on windows setup problem

Hello, I have a strange problem. I'm installing PostgreSQL 9.1 on Windows XP Home SP3 (don't ask!!! :-)) and facing the following problem (pasted from log) - [...] Starting the database server... Executing cscript //NoLogo "C:\PGSql\installer\server\startserver.vbs"

Re: [GENERAL] PG 9.1 on windows setup problem

Il 20/04/2016 15:34, Adrian Klaver ha scritto: On 04/20/2016 01:57 AM, Moreno Andreo wrote: Hello, I have a strange problem. I'm installing PostgreSQL 9.1 on Windows XP Home SP3 (don't ask!!! :-)) Where did you get the binary/installer? PostgreSQL official site and facing

[GENERAL] WAL directory size calculation

Hi folks! :-) I'm about to bring up my brand new production server and I was wondering if it's possible to calculate (approx.) the WAL directory size. I have to choose what's better in terms of cost vs. performance (we are on Google Cloud Platform) between a ramdisk or a separate persistent

Re: [GENERAL] WAL directory size calculation

Il 28/07/2016 15:54, Andreas Kretschmer ha scritto: Am 28.07.2016 um 15:25 schrieb Moreno Andreo: Hi folks! :-) I'm about to bring up my brand new production server and I was wondering if it's possible to calculate (approx.) the WAL directory size. I have to choose what's better in terms

Re: [SPAM] Re: [GENERAL] WAL directory size calculation

.       From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Moreno Andreo Sent: 29 July 2016 10:19 To: pgsql-general@postgresql.org Subject: Re: [SPAM

Re: [SPAM] Re: [GENERAL] WAL directory size calculation

Il 29/07/2016 10:43, John R Pierce ha scritto: Aside of this, I'm having 350 DBs that sum up a bit more than 1 TB, and plan to use wal_level=archive because I plan to have a backup

Re: [SPAM] Re: [GENERAL] WAL directory size calculation

Il 28/07/2016 20:45, Francisco Olarte ha scritto: On Thu, Jul 28, 2016 at 3:25 PM, Moreno Andreo <moreno.and...@evolu-s.it> wrote: Obviously ramdisk will be times faster disk, but having a, say, 512 GB ramdisk will be a little too expensive :-) Besides defeating the purpose of WAL,

Re: [SPAM] Re: [GENERAL] WAL directory size calculation

Thanks Moreno     From: Moreno Andreo [mailto:moreno.and...@evolu-s.it] Sent: 29 July 2016 12:08 To: FarjadFarid(ChkNet)

Re: [SPAM] Re: [GENERAL] WAL directory size calculation

Il 29/07/2016 15:30, David G. Johnston ha scritto: On Fri, Jul 29, 2016 at 7:08 AM, Moreno Andreo <moreno.and...@evolu-s.it> wrote:

Re: [SPAM] Re: [SPAM] Re: [GENERAL] WAL directory size calculation

Il 29/07/2016 17:26, Francisco Olarte ha scritto: Hi: On Fri, Jul 29, 2016 at 10:35 AM, Moreno Andreo <moreno.and...@evolu-s.it> wrote: After Andreas post and thinking about it a while, I went to the decision that it's better not to use RAM but another persistent disk, because the

Re: [SPAM] Re: [GENERAL] WAL directory size calculation

Il 03/08/2016 18:01, Jeff Janes ha scritto: On Thu, Jul 28, 2016 at 6:25 AM, Moreno Andreo <moreno.and...@evolu-s.it> wrote: Hi folks! :-) I'm about to bring up my brand new production server and I was wondering if it's possible to calculate (approx.) the WAL directory size. I have to

Re: [SPAM] Re: [SPAM] Re: [SPAM] Re: [GENERAL] WAL directory size calculation

Il 03/08/2016 14:12, Michael Paquier ha scritto: On Wed, Aug 3, 2016 at 8:07 PM, Moreno Andreo <moreno.and...@evolu-s.it> wrote: Should I keep fsync off? I'd think it would be better leaving it on, right? >From the docs: https://www.postgresql.org/docs/9.6/static/runtime-config

Re: [SPAM] Re: [GENERAL] Streaming Replica Master-Salve Config.

Il 04/08/2016 18:15, Eduardo Morras ha scritto: [...] a) As others said, max_connections = 200 is too high. Set it at your number of cores (I use number of cores -1) Excuse me for crossthreading, but I have to make things clearer to me. That's one of the things I feel hard to understand how to

Re: [GENERAL] WAL directory size calculation

Il 28/07/2016 15:33, David G. Johnston ha scritto: On Thu, Jul 28, 2016 at 9:25 AM, Moreno Andreo <moreno.and...@evolu-s.it> wrote: I've read somewhere that the formula should be 16

Re: [GENERAL] Replication with non-read-only standby.

Il 01/07/2016 05:21, Venkata Balaji N ha scritto: On Thu, Jun 30, 2016 at 11:15 PM, Nick Babadzhanian wrote: Setup: 2 PostgreSQL servers are geographically spread. The first one

Re: [SPAM] [GENERAL] AD(Active Directory) groups concepts in postgres

Hi Pawan, Il 02/02/2017 16:49, PAWAN SHARMA ha scritto: Hi All,

Re: [GENERAL] Move rows from one database to other

Il 21/02/2017 15:38, Melvin Davidson ha scritto: Depending on how much data you want to move, and if the tables

[GENERAL] echo

Excuse me... I was not receiving email from the list in the last 12 hours just to check.. Thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Latest PostgreSQL on Raspbian Jessie

Il 23/02/2017 10:56, Ertan Küçükoğlu ha scritto: I would like to know; 1- Is it possible to install 9.6.2 with same version pglib on Raspberry Pi? In subject you call it as Raspbian Jessie, so I assume it's somewhat related to Debian Jessie. Debian repository does not (at last, not in the last

Re: [GENERAL] Can't restart Postgres

Il 14/02/2017 20:31, Joshua D. Drake ha scritto: On 02/14/2017 11:17 AM, Shawn Thomas wrote: I inadvertently deleted the ssl-cert-snakeoil.pem out from under a running Postgres instance (9.4) which caused it to shut down. The last line of main.log: FATAL: could not load server certificate

Re: [GENERAL] Auto-Rollback option

Il 13/02/2017 18:59, John R Pierce ha scritto: option? query editor window? what software are you talking about? I'm using 1.22.1 version. 1.22.1 version? PostgreSQL versions currently supported are 9.2.x to 9.6.x I think he's talking about pgAdmin III Cheers Moreno --

Re: [GENERAL] Restore single databaseR

Hi, please don't top post. Il 18/01/2017 15:01, PAWAN SHARMA ha scritto: Thanks for reply, but I have 120 databases running on a one single instance. So it's not possible to take backup of instance instead of taking pg_dumb of all databases separately. Example: suppose we have two

[GENERAL] Question about locking and pg_locks

Hi folks! :-) This morning I was woken up by a call of a coworker screaming "Help, our Postgres server is throwing strange errors!" Not the best way to start your day... OK, to the serious part. "Strange errors" were (in postgresql-9.1-main.log) WARNING: out of shared memory ERROR: out of

Re: [GENERAL] Question about locking and pg_locks

Il 10/09/2016 23:07, Jeff Janes ha scritto: On Thu, Sep 8, 2016 at 4:30 AM, Moreno Andreo <moreno.and...@evolu-s.it> wrote: Hi folks! :-) This morning I was woken up by

Re: [GENERAL] How pg_dump works

Il 10/10/2016 14:16, haman...@t-online.de ha scritto: Hi all, I need to pg_dump a database to another server. The particularity is that the database is bigger than remaining space on disk. Obviously, this is not a problem because i'm dumping to another host, but I need to know if the

[GENERAL] How pg_dump works

Hi all, I need to pg_dump a database to another server. The particularity is that the database is bigger than remaining space on disk. Obviously, this is not a problem because i'm dumping to another host, but I need to know if the procedure streams data to remote host or the data itself is

Re: [GENERAL] How pg_dump works

Il 10/10/2016 14:16, Achilleas Mantzios ha scritto: On 10/10/2016 14:50, Moreno Andreo wrote: Hi all, I need to pg_dump a database to another server. The particularity is that the database is bigger than remaining space on disk. Obviously, this is not a problem because i'm dumping

Re: [SPAM] [GENERAL] psql 9.3 automatic recovery in progress

Il 10/10/2016 18:24, Periko Support ha scritto: 2016-09-12 09:00:01 PDT LOG: server process (PID 23958) was terminated by signal 9: Killed 2016-09-12 10:00:01 PDT LOG: server process (PID 30766) was terminated by signal 9: Killed 2016-09-12 15:00:01 PDT LOG: server process (PID 22030)

[GENERAL] Best practices to manage custom statistics

Hi, I'm checking if there's a best way to obtain stastistics based on my database tables Here's the scenario. First of all, technical details: - Postgresql 9.1, Ubuntu 12 on a 4 core, 32 GB machine with 600 GB disk migrating to Postgresql 9.5.3, Debian 8 on a 8-core, 52 GB machine with 2

[GENERAL] Postgresql errors on Windows with F-Secure AntiVirus

Hi again, our support team is reporting cases where postgres connections are suddenly dropped, but reconnecting again soon everyting is OK. Environment is PostgreSQL 9.1 on Windows (various versions) Asfer some research, I found on postgresql log many of these messages could not reserve

Re: [GENERAL] Replicating hundreds of thousandw of rows

Il 25/11/2016 15:23, Job ha scritto: Hello, Hello, we are using rybyrep with postgresql 9.1 and 9.5 to have (almost-) real time synchronization for 5 years ATM. Unfortunately, it seems a dead project, so we had to find a good JRuby developer to make some customizations. we need to replicate

Re: [SPAM] Re: [GENERAL] Best practices to manage custom statistics

Il 15/11/2016 18:19, Adrian Klaver ha scritto: On 11/15/2016 07:39 AM, Moreno Andreo wrote: Sorry for late reply... i'm in some quite rough days Il 08/11/2016 21:28, Adrian Klaver ha scritto: On 11/08/2016 12:13 PM, Moreno Andreo wrote: [...] In your experience, would this approach help

Re: [SPAM] Re: [SPAM] Re: [GENERAL] Best practices to manage custom statistics

ha scritto: On 11/23/2016 05:24 AM, Moreno Andreo wrote: Il 15/11/2016 18:19, Adrian Klaver ha scritto: On 11/15/2016 07:39 AM, Moreno Andreo wrote: Sorry for late reply... i'm in some quite rough days Il 08/11/2016 21:28, Adrian Klaver ha scritto: On 11/08/2016 12:13 PM, Moreno Andreo

Re: [GENERAL] Best practices to manage custom statistics

Sorry for late reply... i'm in some quite rough days Il 08/11/2016 21:28, Adrian Klaver ha scritto: On 11/08/2016 12:13 PM, Moreno Andreo wrote: [...] In your experience, would this approach help me lower server load? Are there any other approach I can try? Instead of pushing why

Re: [GENERAL] PDF files: to store in database or not

... but what if database is replicated? Thanks Moreno. Il 06/12/2016 19:50, Rich Shepard ha scritto: On Tue, 6 Dec 2016, Joshua D. Drake wrote: Due to the widely variable size of a PDF document, I would say no. I would store the metadata and file location. Joshua, I read your answer as

Re: [GENERAL] Google Cloud Platform, snapshots and WAL

Il 20/03/2017 17:45, Ben Chobot ha scritto: On Mar 20, 2017, at 6:31 AM, Moreno Andreo <moreno.and...@evolu-s.it> wrote: Hi everyone,    I h

[GENERAL] PostgreSQL and Kubernetes

Hi everyone,     I was googling around while searching stuff to finish my cluster solution (already running in production in single-server mode) with barman and pgbouncer, when I ran into this

Re: [GENERAL] PostgreSQL and Kubernetes

Il 30/03/2017 15:27, Adrian Klaver ha scritto: On 03/30/2017 03:10 AM, Moreno Andreo wrote: Hi everyone, I was googling around while searching stuff to finish my cluster solution (already running in production in single-server mode) with barman and pgbouncer, when I ran into this https

Re: [GENERAL] PostgreSQL and Kubernetes

Il 30/03/2017 14:38, Vick Khera ha scritto: On Thu, Mar 30, 2017 at 6:10 AM, Moreno Andreo <moreno.and...@evolu-s.it> wrote: Since I'm on Google Cloud Platform, I thought it would be

[GENERAL] Google Cloud Platform, snapshots and WAL

Hi everyone, I have my PostgreSQL 9.5 server running on a VM instance on Google Compute Engine (Google Cloud Platform) on Debian Jessie (8.3), and I have another dedicated VM instance that, every night at 3.00, takes a snapshot of the whole disk, without stopping the PG instance itself.

Re: [GENERAL] PostgreSQL and Kubernetes

Il 03/04/2017 18:10, Joe Conway ha scritto: On 03/31/2017 01:58 AM, Moreno Andreo wrote: Il 30/03/2017 14:38, Vick Khera ha scritto: On Thu, Mar 30, 2017 at 6:10 AM, Moreno Andreo <moreno.and...@evolu-s.it <mailto:moreno.and...@evolu-s.it>> wrote: Since I'm on Google Cloud

Re: [GENERAL] PostgreSQL and Kubernetes

Il 03/04/2017 22:32, Alex Kliukin ha scritto: as it makes little sense to build an aircraft carrier to carry a single Cessna. :-) A bit extreme, but it makes the idea ... Thanks Moreno.-   Kind

Re: [GENERAL] Archiving data to another server using copy, psql with pipe

Il 06/04/2017 13:58, pinker ha scritto: W dniu 2017-04-06 13:24:16 użytkownik Moreno Andreo <moreno.and...@evolu-s.it> napisał: Il 05/04/2017 23:26, pinker ha scritto: Hi, I'm trying to write an archive manager which will be first copying data from tables with where clause and then,

Re: [GENERAL] Archiving data to another server using copy, psql with pipe

Il 06/04/2017 16:10, pinker ha scritto: Error message says, as one could expect, that the second table has got smaller precision... The question isn't about this particular error - which was induced for purpose - but about atomicity of this operation Sorry, I read your message without paying

Re: [GENERAL] Archiving data to another server using copy, psql with pipe

Il 05/04/2017 23:26, pinker ha scritto: Hi, I'm trying to write an archive manager which will be first copying data from tables with where clause and then, after successful load into second server - delete them. The simplest (and probably fastest) solution I came up with is to use copy: psql -h

Re: [GENERAL] Recover corrupted data

Il 19/04/2017 17:49, Vick Khera ha scritto: 1) restore from backup 2) fix whatever configuration you made to let windows (or your hardware) destroy your data on crash. is there some RAID cache that is not backed up by a battery?

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

Il 14/04/2017 20:55, Melvin Davidson ha scritto: On Fri, Apr 14, 2017 at 2:42 PM, Chris Mair wrote: you should increase shared_memory to 40GB. General

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

Il 14/04/2017 21:06, Igor Neyman ha scritto:   From: Moreno Andreo [mailto:moreno.and...@evolu-s.it] Sent: Friday, April 14, 2017 3:00 PM

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

: On Fri, Apr 14, 2017 at 1:50 PM, Moreno Andreo <moreno.and...@evolu-s.it> wrote: Sorry,  my mistake (I'm a bit nervous...) that's not work_mem, but shared_b

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem [(AUTO-RE)SOLVED...]

Il 14/04/2017 21:15, Igor Neyman ha scritto:   From: Moreno Andreo [mailto:moreno.and...@evolu-s.it] Sent: Friday, April 14, 2017 3:11 PM

[GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

Hi all, About 2 hours and half ago, suddenly (and on the late afternoon of the Easter Friday), customers reported failing connections to our server, or even very slow. After a bit of checking (that also involved server reboot) I noticed (using top) that every process

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

Sorry,  my mistake (I'm a bit nervous...) that's not work_mem, but shared_buffers Thanks Il 14/04/2017 19:33, Melvin Davidson ha scritto: On Fri, Apr 14, 2017 at 1:12 PM, Moreno Andreo

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

Il 14/04/2017 20:40, Igor Neyman ha scritto:   E. How many users were connected when the problem occurred? About 350 connections

[GENERAL] # of connections and architecture design

Hi all, As many of you has read last Friday (and many has tired to help, too, and I still thank you very much), I had a bad service outage. I was pointed to reduce number of maximum connections using a pooler, and that's what I'm building in test lab, but I'm wondering if there's something

Re: [GENERAL] # of connections and architecture design

Il 18/04/2017 18:51, Jeff Janes ha scritto: On Tue, Apr 18, 2017 at 2:42 AM, Moreno Andreo <moreno.and...@evolu-s.it> wrote: Hi all,     As many of you has read last Friday (and ma

[GENERAL] Invalid field size

I've implemented a backup procedure in C# with Npgsql (using COPY TO I dump all tables in a compressed file) that's been working well in the last 5 years (and it's still working, since this is a single, isolated case). OS: Windows 7 PG: 9.1.6 (I know, it's EOL, but I think it's not matter

Re: [GENERAL] Invalid field size

Il 04/07/2017 16:30, Glyn Astill ha scritto: >On Tuesday, 4 July 2017, 12:16:57 GMT+1, Moreno Andreo <moreno.and...@evolu-s.it> wrote: > > > Any ideas? As for many error I got in the past I assume we

Re: [SPAM] Re: [GENERAL] Invalid field size

Il 04/07/2017 16:36, Adrian Klaver ha scritto: On 07/04/2017 04:16 AM, Moreno Andreo wrote: I've implemented a backup procedure in C# with Npgsql (using COPY TO I dump all tables in a compressed file) that's been working well in the last 5 years (and it's still working, since this is a single

Re: [GENERAL] Invalid field size

Il 04/07/2017 16:51, Tom Lane ha scritto: Moreno Andreo <moreno.and...@evolu-s.it> writes: I've implemented a backup procedure in C# with Npgsql (using COPY TO I dump all tables in a compressed file) that's been working well in the last 5 years (and it's still working, since this is a

Re: [SPAM] Re: [SPAM] Re: [GENERAL] Invalid field size

Il 04/07/2017 18:25, Adrian Klaver ha scritto: On 07/04/2017 09:02 AM, Moreno Andreo wrote: Il 04/07/2017 17:39, Adrian Klaver ha scritto: So what you are saying is "in the last 5 years you've been extremely lucky?" :-) Your original post went back and forth on whether you w

Re: [SPAM] Re: [GENERAL] Invalid field size

Il 04/07/2017 17:39, Adrian Klaver ha scritto: On 07/04/2017 08:19 AM, Moreno Andreo wrote: Il 04/07/2017 16:51, Tom Lane ha scritto: Moreno Andreo <moreno.and...@evolu-s.it> writes: I've implemented a backup procedure in C# with Npgsql (using COPY TO I dump all tables in a compresse

Re: [GENERAL] Invalid field size

Il 04/07/2017 18:55, Daniel Verite ha scritto: I don't quite see from your posts whether that particular file to import was tried and failed only once or retried and failed again. Only once, and until the user will not return from holidays I'll not be able to reproduce it. Cheers Moreno

Re: [SPAM] Re: [GENERAL] Invalid field size

Il 04/07/2017 17:42, Adrian Klaver ha scritto: On 07/04/2017 08:37 AM, Moreno Andreo wrote: Il 04/07/2017 17:25, Tom Lane ha scritto: Moreno Andreo <moreno.and...@evolu-s.it> writes: Il 04/07/2017 16:51, Tom Lane ha scritto: Pushing binary data around on Windows is always a haz

Re: [GENERAL] Invalid field size

Il 04/07/2017 17:42, Daniel Verite ha scritto: Moreno Andreo wrote: As you can see I have 2 bytea fields, blob and thumbnail (the one it seems it's giving the error), but AFAIK the former is never used, so it should be always null. Googling around did not help. Despite the auto

Re: [SPAM] Re: [SPAM] Re: [GENERAL] Invalid field size

Il 04/07/2017 19:28, Tom Lane ha scritto: Moreno Andreo <moreno.and...@evolu-s.it> writes: So the hint is to abandon manual COPY and let pg_dump do the hard work? If it is a newline-conversion problem, compressed pg_dump archives would be just as subject to corruption as your binary COP

Re: [GENERAL] Invalid field size

Il 04/07/2017 17:25, Tom Lane ha scritto: Moreno Andreo <moreno.and...@evolu-s.it> writes: Il 04/07/2017 16:51, Tom Lane ha scritto: Pushing binary data around on Windows is always a hazardous proposition. So what you are saying is "in the last 5 years you've been extremely lucky

Re: [SPAM] [GENERAL] How to install pgadmin3 or pgadmin4 on linux machine

Il 05/07/2017 13:35, PAWAN SHARMA ha scritto: Hi All, Please help me to install

Re: [GENERAL] Invalid field size

Il 04/07/2017 20:51, Daniel Verite ha scritto: Tom Lane wrote: Moreno Andreo <moreno.and...@evolu-s.it> writes: So the hint is to abandon manual COPY and let pg_dump do the hard work? If it is a newline-conversion problem, compressed pg_dump archives would be just as s

Re: [SPAM] Re: [GENERAL] Invalid field size

Il 05/07/2017 16:33, Adrian Klaver ha scritto: On 07/05/2017 01:05 AM, Moreno Andreo wrote: Il 04/07/2017 20:51, Daniel Verite ha scritto: Tom Lane wrote: Moreno Andreo <moreno.and...@evolu-s.it> writes: So the hint is to abandon manual COPY and let pg_dump do the hard

Re: [GENERAL] "joining" table records

Il 21/06/2017 19:11, David G. Johnston ha scritto: On Wed, Jun 21, 2017 at 9:47 AM, Moreno Andreo <moreno.and...@evolu-s.it> wrote: I have this table rec_code | rec_date | int1 | int2 | 10 2014-07-21 3 4 11 2014-07-21 5 10 2015-01-04 1

Re: [SPAM] [GENERAL] ERROR: query returned no rows

Il 26/06/2017 20:21, Alexander Farber ha scritto: RETURNING player1, score2, score1 INTO _opponent, _score1, -- the line 85

[GENERAL] "joining" table records

I have this table rec_code | rec_date | int1 | int2 | 10 2014-07-21 3 4 11 2014-07-21 5 10 2015-01-04 1 2 11 2016-02-05 6 That's the result I need to get from a SELECT statement rec_date | int1 | int2 | tempvalue 2014-07-21 3 4

Re: [SPAM] [GENERAL] Sql server to Postgres Migration issue!

Il 18/05/2017 14:46, Rakesh Mamidala ha scritto: java.lang.ClassCastException: org.postgresql.jdbc.PgConnection cannot be cast to org.postgresql.jdbc2.AbstractJdbc2Connection  This

Re: [GENERAL] Performance issue with Pointcloud extension

Il 08/06/2017 19:10, Eric Lemoine ha scritto: How can such a thing happen? Thanks for any insight on what could cause this. I'd try raising shared_buffers to 1 GB or something near 40% of the available memory If you run the query again, after getting bad results, what do you get? Cheers

Re: [SPAM] Re: [GENERAL] VM-Ware Backup of VM safe?

Il 20/09/2017 17:15, Klaus P. Pieper ha scritto: -Ursprüngliche Nachricht- Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] Im Auftrag von Thomas Güttler Gesendet: Mittwoch, 20. September 2017 10:03 An: pgsql-general@postgresql.org Betreff: [GENERAL]

Re: [GENERAL] VM-Ware Backup of VM safe?

Il 20/09/2017 13:36, PT ha scritto: On Wed, 20 Sep 2017 10:03:15 +0200 Thomas Güttler wrote: We run a PostgreSQL 9.6 server in a virtual machine. The virtual machine is managed by the customer. He does backup the VM. Is this enough, is this safe? There are so

Re: [SPAM] Re: [GENERAL] Invalid magic number 0000 in log file

Il 25/08/2017 22:01, Peter Eisentraut ha scritto: On 8/25/17 14:24, Moreno Andreo wrote: I know that's related to XLOG files, but do not have idea on how to deal with it. I had a quick googling but found nothing but "your files are corrupted. You'd better initdb." That's p

[GENERAL] Invalid magic number 0000 in log file

Hi everyone,     a customer reported an issue starting Postgres on his machine after reinstalling Windows (10 before, 10 now) without formatting (so there's Windows and Windows.old) because of Windows not starting up anymore. Before this reinstallation everything was OK. Now here's the log