Re: [HACKERS] Disaster!

of=somefile # cat file1 somefile newfile # mv newfile file1 file1 is /usr/local/pgsql/data/pg_clog/000D -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; --- Martín Marqués | Programador, DBA Centro de Telemática| Administrador

Re: [HACKERS] Disaster!

insight on what occurred here, why those 8k of zeros fixed it, and what is a WAL replay? I am very curious about it. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; --- Martín Marqués | Programador, DBA Centro de Telemática

Re: [HACKERS] Re: Final call for platform testing

On Wednesday 04 April 2001 13:29, Pete Forman wrote: Solaris 2.7-8 Sparc7.1 2001-03-22, Marc Fournier I've reported Solaris 2.6 Sparc as working on a post-RC1 snapshot. Same for Solaris 8 Sparc, but only tested with RC1. -- El mejor sistema operativo es aquel que te da de comer. Cuida

Re: [HACKERS] Configure problems on Solaris 2.7, pgsql 7.02 and 7.03

On Wednesday 04 April 2001 22:42, Ciaran Johnston wrote: Hi, Sorry to bother you's but I am currently doing a database comparison and have been trying to get postgresql installed. I'm running Solaris 2.7. I downloaded pgsql 7.03 and ran ./configure in the src/ directory. This was fine until

Re: [HACKERS] syslog by default?

? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral

Re: [HACKERS] Putting timestamps in PostgreSQL log

base de datos relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional

[HACKERS] pg_dump bug

, and have to change the permission by hand. Has this already been reported? saludos... :-) -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED

[HACKERS] Rules and missing inserts

cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del

[HACKERS] Missing inserts

... :-) -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica

[HACKERS] chunk size problem

relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional

Re: [HACKERS] Missing inserts

. Is there some logic? TIA! -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica

Re: [HACKERS] Integrated autovacuum

. Running on a 8.0.3 server with autovacuum running every 5 minutes. -- 17:52:04 up 25 days, 2:37, 1 user, load average: 0.90, 1.00, 0.97 - Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad

Re: [HACKERS] Integrated autovacuum

El Mié 27 Jul 2005 18:23, Alvaro Herrera escribió: On Wed, Jul 27, 2005 at 06:05:26PM -0300, Martín Marqués wrote: Will there be a way to ballance the amount of stats the autovacuum gets? Something like the analyze parameters that the contrib version has, but integrated

Re: [GENERAL] [HACKERS] plPHP in core?

, 0.61, 0.64 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral

Re: [GENERAL] [HACKERS] plPHP in core?

separate step. The same thing can be done with PHP. -- 09:25:38 up 3 days, 17:54, 1 user, load average: 0.45, 0.28, 0.38 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador

[HACKERS] problem with commitfest redirection

When ever I try to see the patch from this commit it never loads: https://commitfest.postgresql.org/action/patch_view?id=1129 Some problem there? I can see other patches, from other commits. -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support

Re: [HACKERS] problem with commitfest redirection

El 21/06/13 23:47, Jaime Casanova escribió: On Fri, Jun 21, 2013 at 8:56 PM, Martín Marqués mar...@2ndquadrant.com wrote: When ever I try to see the patch from this commit it never loads: https://commitfest.postgresql.org/action/patch_view?id=1129 Some problem there? I can see other patches

[HACKERS] yum psycopg2 doc package not signed

is not signed Something wrong with the packages? -- Martín Marqués http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] yum psycopg2 doc package not signed

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 El 21/01/14 20:11, Devrim GÜNDÜZ escribió: Hi, On Tue, 2014-01-21 at 20:19 -0200, Martín Marqués wrote: I was updating the packages from one of my servers and I got this message: Package python-psycopg2-doc-2.5.2-1.f19.x86_64.rpm

[HACKERS] Regression test errors

, -- Martín Marqués http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services regression.diffs Description: Binary data From b6db8388e37f6afaa431e31239fd972d10140cc1 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Mart=C3=ADn=20Marqu=C3=A9s?= mar...@2ndquadrant.com Date: Fri, 7 Mar

Re: [HACKERS] Regression test errors

, because silly changes should be tested as well ;)). 2014-03-07 21:46 GMT-03:00 Martín Marqués mar...@2ndquadrant.com: I was testing some builds I was doing and found that the regression tests fails when doing the against a Hot Standby server: $ make standbycheck [...] == running

[HACKERS] postgres messages error

Cheers, -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] about lob(idea)

in a common catalog table (pg_largeobjects). If the LO were stored per-database, with a some alike schema as pg_largeobjects, then they could be placed on any tablespace available, and even get dumped on a normal DB dump, which makes administration much simpler. Cheers, -- Martín Marqués

Re: [HACKERS] [GENERAL] PgQ and pg_dump

El 16/06/16 a las 09:48, Michael Paquier escribió: > On Thu, Jun 16, 2016 at 8:37 PM, Martín Marqués <mar...@2ndquadrant.com> > wrote: > >> This problem came up due to a difference between pg_dump on 9.1.12 and >> 9.1.22 (I believe it was due to a patch on pg_dump tha

Re: [HACKERS] [GENERAL] PgQ and pg_dump

El 16/06/16 a las 00:08, Michael Paquier escribió: > On Wed, Jun 15, 2016 at 7:19 PM, Martín Marqués <mar...@2ndquadrant.com> > wrote: >> >> How would the recovery process work? We expect the schema to be there >> when restoring the tables? > > pg_dump cre

Re: [HACKERS] [GENERAL] PgQ and pg_dump

2016-06-21 13:08 GMT-03:00 Robert Haas <robertmh...@gmail.com>: > On Thu, Jun 16, 2016 at 1:46 PM, Martín Marqués <mar...@2ndquadrant.com> > wrote: >> The comment is accurate on what is going to be dumpable and what's not >> from the code. In our case, as the pgq s

Re: [HACKERS] [GENERAL] PgQ and pg_dump

Hi, 2016-06-16 9:48 GMT-03:00 Michael Paquier <michael.paqu...@gmail.com>: > On Thu, Jun 16, 2016 at 8:37 PM, Martín Marqués <mar...@2ndquadrant.com> > wrote: >> El 16/06/16 a las 00:08, Michael Paquier escribió: >>> On Wed, Jun 15, 2016 at 7:19 PM, Martí

Re: [HACKERS] 10.0

ntroversy about switching to major.minor versioning this in -advocacy? http://www.postgresql.org/message-id/ee13fd2bb44cb086b457be34e81d5...@biglumber.com IMO, this versioning is pretty good and people understand it well, with the other will be using postgres 13 by 2020, which isn't far away. ;) --

Re: [HACKERS] 10.0

+1 And another +1 on Tom's opinion on it being too late after beta1 has been released. -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make cha

[HACKERS] Minor documentation patch

, and how I got there, and I believe it gives better meaning to the sentence in question. I applied the same change on another part which had the same phrase. Cheers, -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services &

[HACKERS] pg_dump with tables created in schemas created by extensions

expected due to the bug we have at hand. I believe the fix will be simple after the back and forth mails with Michael, Stephen and Tom. I will work on that later, but preferred to have the tests the show the problem which will also make testing the fix easier. Thoughts? Regards, -- Martín

Re: [HACKERS] Index corruption with CREATE INDEX CONCURRENTLY

tantly run index checks (query a sample of the data from the heap and from the index and check they match). In our case, the customer was not aware of the dups until we found them. Regards, -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, T

Re: [HACKERS] Index corruption with CREATE INDEX CONCURRENTLY

's also been comments about maybe this being the cause of old reports about index corruption. I ask myself if it's a good idea to make a point release with a know corruption bug in it. Regards, -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Tra

Re: [HACKERS] pg_dump with tables created in schemas created by extensions

2016-08-24 17:01 GMT-03:00 Martín Marqués <mar...@2ndquadrant.com>: > 2016-08-24 11:15 GMT-03:00 Stephen Frost <sfr...@snowman.net>: >> Michael, >> >> * Michael Paquier (michael.paqu...@gmail.com) wrote: >>> The patch attached includes all those tests and

Re: [HACKERS] pg_dump with tables created in schemas created by extensions

index issue though, > and this is broken for some time, so that's not exclusive to 9.6 :) Hi Michael, Do you see any easier way than what I mentioned earlier (adding a selectDumpableIndex() function) to fix the index dumping issue? Regards, -- Martín Marquéshttp://www.2ndQuadrant.com/ Postgre

Re: [HACKERS] Sample configuration files

makes total sense. I will have a better check at the patch and get back (didn't find anything wrong at the first look at it). Regards, -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing l

Re: [HACKERS] pg_dump with tables created in schemas created by extensions

they depend on will not be dumped, so it's the developer/DB designer who has to take care of these things. If in the near or not so near future we provide a patch to deal with these missing dependencies, we can easily patch pg_dump so it deals with this correctly. Regards, -- Martín Marqués

Re: [HACKERS] pg_dump with tables created in schemas created by extensions

. I think this patch is a very good first approach. Future improvements can be made for indexes, but we need to get the extension dependencies right first. That could be done later, on a different patch. Thoughts? -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development

Re: [HACKERS] pg_dump with tables created in schemas created by extensions

2016-08-30 2:02 GMT-03:00 Michael Paquier <michael.paqu...@gmail.com>: > On Tue, Aug 30, 2016 at 5:43 AM, Martín Marqués <mar...@2ndquadrant.com> > wrote: >> This is v4 of the patch, which is actually a cleaner version from the >> v2 one Michael sent. >>

Re: [HACKERS] pg_dump with tables created in schemas created by extensions

on and regress_pg_dump_schema.test_index doesn't. Or is this something we shouldn't support (in that case we should document it). -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (p

Re: [HACKERS] pg_dump with tables created in schemas created by extensions

Hi, 2016-08-25 8:10 GMT-03:00 Michael Paquier <michael.paqu...@gmail.com>: > On Thu, Aug 25, 2016 at 10:25 AM, Martín Marqués <mar...@2ndquadrant.com> > wrote: >> 2016-08-24 21:34 GMT-03:00 Michael Paquier <michael.paqu...@gmail.com>: >>> >>

Re: [HACKERS] pg_dump with tables created in schemas created by extensions

Hi, 2016-08-26 10:53 GMT-03:00 Martín Marqués <mar...@2ndquadrant.com>: > > There's still one issue, which I'll add a test for as well, which is > that if the index was created by the extension, it will be dumped > anyway. I'll have a look at that as well. Looking at this is

Re: [HACKERS] pg_dump with tables created in schemas created by extensions

Hi Michael, 2016-08-23 5:02 GMT-03:00 Michael Paquier <michael.paqu...@gmail.com>: > On Sat, Aug 13, 2016 at 6:58 AM, Martín Marqués <mar...@2ndquadrant.com> > wrote: >> I believe the fix will be simple after the back and forth mails with >> Michael, Stephen and

Re: [HACKERS] pg_dump with tables created in schemas created by extensions

Hi, 2016-08-23 16:46 GMT-03:00 Martín Marqués <mar...@2ndquadrant.com>: > > I will add tests for sequence and functions as you mention and test again. > > Then I'll check if other tests should be added as well. I found quite some other objects we should be checking as well,

Re: [HACKERS] pg_dump with tables created in schemas created by extensions

r 12 failures regarding the CREATE INDEX that Michael reported but can't quite find where it's originated. (or actually where the problem is) -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mail

Re: [HACKERS] Bug with pg_basebackup and 'shared' tablespace

her. -- Martín Marquéshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] pg_basebackup --progress output for batch execution

atement, but you get it ;) ) An example where using isatty() might fail is if you run pg_basebackup from a tty but redirect the output to a file, I believe that in that case isatty() will return true, but it's very likely that the user might want batch mode output. But maybe we should also add