Re: [GENERAL] pg_restore out of memory

2016-08-02 Thread Miguel Ramos
useful that we make some additional tests, or some observation of the file, we would be glad to return the help. Best Regards, -- Miguel Ramos -- 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] pg_restore out of memory

2016-08-02 Thread Miguel Ramos
useful that we make some additional tests, or some observation of the file, we would be glad to return the help. Best Regards, -- Miguel Ramos -- 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] pg_restore out of memory

2016-07-19 Thread Miguel Ramos
A Qui, 14-07-2016 às 10:52 +0100, Miguel Ramos escreveu: > > A Qua, 13-07-2016 às 18:42 -0400, Tom Lane escreveu: > > > > I wrote: > > > > > > I'm still suspicious that this might be some sort of NOTICE- > > > processing- > > > rel

Re: [GENERAL] pg_restore out of memory

2016-07-15 Thread Miguel Ramos
A Sex, 15-07-2016 às 07:16 -0700, Adrian Klaver escreveu: > On 07/15/2016 12:37 AM, Miguel Ramos wrote: > > What else? > > The pg_dump file you are restoring from is a custom format. > > Do you have room to do something like?: > > 1) pg_restore

Re: [GENERAL] pg_restore out of memory

2016-07-15 Thread Miguel Ramos
A Qui, 14-07-2016 às 10:52 +0100, Miguel Ramos escreveu: > > A Qua, 13-07-2016 às 18:42 -0400, Tom Lane escreveu: > > > > I wrote: > > > > > > I'm still suspicious that this might be some sort of NOTICE- > > > processing- > > > rel

Re: [GENERAL] pg_restore out of memory

2016-07-14 Thread Miguel Ramos
Yes. Both 9.1.8, I checked right now. -- Miguel A Qua, 13-07-2016 às 13:59 -0700, John R Pierce escreveu: > On 7/13/2016 1:51 PM, Miguel Ramos wrote: > > Finally, here are the log messages at the moment of the error. > > It is clearly not while building indices. > > >

Re: [GENERAL] pg_restore out of memory

2016-07-14 Thread Miguel Ramos
port switch. The server has two aggregated links to the switch. I ran pg_restore locally because the server is in another office, connected to mine through a VPN. Now I have arranjed for a PC to be there for me and my next test will be to do the restore using the latest pgadmin. Thanks, -

Re: [GENERAL] pg_restore out of memory

2016-07-14 Thread Miguel Ramos
A Qua, 13-07-2016 às 17:15 -0400, Tom Lane escreveu: > Miguel Ramos writes: > > So, what does this mean? > > Was it the client that aborted? I think I saw that "unexpected > > message > > type 0x58" on other types of interruptions. > > Yeah, 0x5

Re: [GENERAL] pg_restore out of memory

2016-07-14 Thread Miguel Ramos
of sync with the OS... it will all be a lot harder. -- Miguel A Qua, 13-07-2016 às 14:19 -0700, John R Pierce escreveu: > On 7/13/2016 2:11 PM, Miguel Ramos wrote: > > Yes. > > Both 9.1.8, I checked right now. > > 9.1 is up to 9.1.22, thats a lot of bug fixes you're missing.

Re: [GENERAL] pg_restore out of memory

2016-07-13 Thread Miguel Ramos
Yes. Both 9.1.8, I checked right now. -- Miguel A Qua, 13-07-2016 às 13:59 -0700, John R Pierce escreveu: > On 7/13/2016 1:51 PM, Miguel Ramos wrote: > > Finally, here are the log messages at the moment of the error. > > It is clearly not while building indices. > > >

Re: [GENERAL] pg_restore out of memory

2016-07-13 Thread Miguel Ramos
A Ter, 12-07-2016 às 13:08 +, Sameer Kumar escreveu: > On Tue, 12 Jul 2016, 7:25 p.m. Miguel Ramos, > wrote: > > I found two relevant threads on the mailing-lists. > > The most recent one sugested that postgresql was being configured > > to use > > more memory

Re: [GENERAL] pg_restore out of memory

2016-07-13 Thread Miguel Ramos
gres[97889]: [870-1] LOG: unexpected EOF on client connection Thanks, -- Miguel A Ter, 12-07-2016 às 15:10 -0400, Tom Lane escreveu: > Miguel Ramos writes: > > This because I have the impression that it is during index > > creation, > > where I think client role would b

Re: [GENERAL] pg_restore out of memory

2016-07-12 Thread Miguel Ramos
A Ter, 12-07-2016 às 11:58 -0400, Tom Lane escreveu: >  > Anyway, it would be useful to try running the restore with a more > modern > version of pg_restore, to see if that helps. > > regards, tom lane > > I have the scheduled restart tonight. So, I will do the other test

Re: [GENERAL] pg_restore out of memory

2016-07-12 Thread Miguel Ramos
Às 16:23 de 12-07-2016, Miguel Ramos escreveu: It looks to me like this error is pg_restore itself running out of memory, not reporting a server-side OOM condition. You could verify that by looking in the server log to see whether any out-of-memory error appeared there. But assuming that I&#

Re: [GENERAL] pg_restore out of memory

2016-07-12 Thread Miguel Ramos
Às 15:40 de 12-07-2016, Tom Lane escreveu: Miguel Ramos writes: We have backed up a database and now when trying to restore it to the same server we get this: # pg_restore -d recovery /mnt/paysdeloire2013_convertida2.1.dump pg_restore: [custom archiver] out of memory It looks to me like

Re: [GENERAL] pg_restore out of memory

2016-07-12 Thread Miguel Ramos
n 24h... -- Miguel Ramos -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] pg_restore out of memory

2016-07-12 Thread Miguel Ramos
on the server, this is a test restore. We have about one or two months of slack before we really need to remove them from the server to recover space. -- Miguel Ramos -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general